Articles with the tag:
Articles with the tag:
Try in the cloud

Introducing the Spreadsheet Editor user interface

The Spreadsheet Editor uses a tabbed interface where editing commands are grouped into tabs by functionality.

Main window of the Online Spreadsheet Editor:

Online Spreadsheet Editor window

Main window of the Desktop Spreadsheet Editor:

Desktop Spreadsheet Editor window

The editor interface consists of the following main elements:

  1. The Editor header displays the logo, tabs for all opened spreadsheets, with their names and menu tabs..

    On the left side of the Editor header there are the Save, Print file, Undo and Redo buttons are located.

    Icons in the editor header

    On the right side of the Editor header along with the user name the following icons are displayed:

    • Open file location Open file location - in the desktop version, it allows opening the folder, where the file is stored, in the File explorer window. In the online version, it allows opening the folder in the Documents module where the file is stored, in a new browser tab.
    • View Settings icon - allows adjusting the View Settings and accessing the Advanced Settings of the editor.
    • Manage document access rights icon Manage document access rights - (available in the online version only) allows setting access rights for the documents stored in the cloud.
    • Favorites icon Mark as favorite - click the star to add a file to favorites as to make it easy to find. The added file is just a shortcut so the file itself remains stored in its original location. Deleting a file from favorites does not remove the file from its original location.
  2. The top toolbar displays a set of editing commands depending on the selected menu tab. Currently, the following tabs are available: File, Home, Insert, Layout, Formula, Data, Pivot Table, Collaboration, Protection, View, Plugins.

    The Copy icon Copy and Paste icon Paste options are always available at the left part of the Top toolbar regardless of the selected tab.

  3. The Formula bar allows entering and editing formulas or values in the cells. The Formula bar displays the contents of the currently selected cell.
  4. The Status bar at the bottom of the editor window contains some navigation tools: sheet navigation buttons, sheet tabs, and zoom buttons. The Status bar also displays the number of filtered records if you apply a filter, or the results of automatic calculations if you select several cells containing data.
  5. The Left sidebar contains the following icons:
    • Search icon - allows using the Search and Replace tool,
    • Comments icon - allows opening the Comments panel,
    • Chat icon - (available in the online version only) allows opening the Chat panel,
    • Feedback and Support icon - (available in the online version only) allows contacting our support team,
    • About icon - (available in the online version only) allows viewing the information about the program.
  6. The Right sidebar allows adjusting additional parameters of different objects. When you select a particular object in a worksheet, the corresponding icon is activated on the right sidebar. Click this icon to expand the right sidebar.
  7. The Working area allows viewing the contents of a spreadsheet, as well as entering and editing data.
  8. The horizontal and vertical Scroll bars allow scrolling up/down and left/right.

For your convenience, you can hide some components and display them again when necessary. To learn more on how to adjust view settings please refer to this page.

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action