Screen elements

The command menu is only displayed in macOS and contains the commands responsible for the main functions of the application.

The main menu contains:

•Button to log in and out of the cloud.

•Commands for working with files and the application.

•Application settings.

To open the main menu, click the button on the Toolbar.

The main menu closes automatically after selecting a command. To close the menu manually, do one of the following:

•Click the button.

•Click anywhere outside of the main menu.

•Press Esc.

To work with the main menu, use the following keyboard keys:

The toolbar contains:

• : Button to open the main menu.

•Tabs for switching between Toolbar tools.

•Search bar Find (Ctrl+/): Used to search for quick actions and data in the document.

•Avatar: Contains the initials or photo of the operating system user. When you log in to the cloud, it changes to the avatar of the user of the MyOffice: Documents Online system.

You can change the way the Toolbar is displayed.

The range field displays the address or name of the selected cell/range of cells, as well as to create new names.

The formula bar is an editable line where you can enter, edit, and view data and formulas.

You can change the height of the Formula bar to make it easier to work with a large amount of information in a cell. To do this, proceed as follows:

1.Move the cursor to the bottom border of the bar. The cursor will look like .

2.Hold down the left mouse button and drag the bar border down or up.

3.Release the left mouse button.

The last set height is saved for both the current and subsequent sessions in the application, but may be reset when you install updates. At the same time, changing the bar height does not affect already opened documents.

Pressing Alt+Enter (Windows, Linux) or Option+ Enter (macOS) while typing characters into a cell does not enlarge the Formula bar.

The size of the Formula bar is limited by the workspace: at least one row must be displayed in the workspace.

To quickly return the bar size to the default size, you can collapse the bar. To do this, proceed with one of the following:

•Double-left-click the bottom border of the bar.

•Click  Collapse formula bar.

•Press Ctrl+Shift+U (Windows, Linux) or  Cmd+ Shift+U (macOS).

To quickly expand the bar, do one of the following:

•Click  Expand formula bar.

•Press Ctrl+Shift+U (Windows, Linux) or  Cmd+ Shift+U (macOS).

The line will be expanded to the size previously set manually or to the default size (72 pixels).

The workspace is the active area of the worksheet within which user actions are performed. If needed, the borders of the workspace can be expanded.

The sheet tabs are designed to navigate through the sheets of a spreadsheet.

The Sidebar contains the following buttons:

 Find and replace: Open the Find and replace pane.

 Insert function: Open the Insert function pane.

 Pivot table: Open the Pivot table settings pane. The button is displayed if a user selects an element of the pivot table.

 Macros: Open the Macros pane. The button is displayed if the file contains at least one macro.

 Name manager: Open the Name manager.

 Chart: Open the chart settings pane.

 Table: Open the Table customization pane. The button is displayed if a table element or the entire table is selected in the document.

 All validations: Open the pane for working with cells containing data validation.

 Recovered files: Open the document backups pane. The button is displayed if there is at least one unsaved copy.

 Manage protection: Open the document content protection management pane.

If a document is open in the cloud, the Sidebar displays avatars of reviewers who are working on that presentation at the same time as the current user.

The Status bar displays the following elements:

•Server connection status indicator: Displayed if the user is logged into the cloud.

•Document access permission level: Displayed if a document stored in the cloud is open in the application.

•Icon of the selected mode of formulas recalculation.

•Automatic calculation values.

•Tools to zoom in or out the current sheet.