How can we help you?

Interface of the main window when working in Windows and Linux OS:

main_window_standard_windows

Interface of the main window when working in macOS:

main_window_standard_macos

Command menu

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

Main menu

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 main_menu_button 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 main_menu_button button.

Click anywhere outside of the main menu.

Press Esc.

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

Keyboard shortcut

Description

and

Go to the next or previous menu item

Open the sub-menu of the selected command (if available)

Tab

Go to the right side of the menu

Shift+Tab

Go to the left side of the menu

Go to the left side menu from the right side of the Recent documents menu

Space

Click the button, select the checkbox, select a setting from the settings group

Enter

Run the selected command or open a recent document

Esc

Close the main menu

Toolbar

The toolbar contains:

main_menu_button : 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.

Range field

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

Formula bar

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 resize_cursor.

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 alt Option+enter 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 t_up Collapse formula bar.

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

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

Click t_down Expand formula bar.

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

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

Workspace

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.

Sheet tabs

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

Sidebar

The Sidebar contains the following buttons:

side_panel_search Find and replace: Open the Find and replace pane.

side_panel_function Insert function: Open the Insert function pane.

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

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

side_panel_defined_names Name manager: Open the Name manager.

side_panel_charts Chart: Open the chart settings pane.

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

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

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

side_panel_protection 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.

Status bar

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.

Was this helpful?
Yes
No
Next
Toolbar