Spreadsheet

4.2. The Spreadsheet Edit Page

The Spreadsheet Edit page contains the following components.

Note: When having a small screen width, a compact toolbar is displayed. In the compact toolbar, some text is replaced with icons. Multiple menu items are combined in scrollbars.

Office menu bar

The Office menu bar includes the following buttons:

  • File tab. Shows the File toolbar that allows to apply file functions.

  • Format tab. Shows the Format toolbar that allows to format the document's content.

  • Data tab. Shows the Data toolbar that allows to sort or filter data.

  • Insert tab. Shows the Insert toolbar that allows to insert objects like images, tables or hyperlinks in the text.

  • Rows/Columns tab. Shows the Rows/Columns toolbar that allows to use tools for editing rows and columns.

  • Encryption icon . Is displayed when having opened an encrypted document.

  • Notifications about saving processes. Notify whether all changes in the document have been saved.

  • Revert icon . Reverts the last operation.

  • Recover icon . Recovers the last reverted operation.

  • Toggle search icon . Displays control elements for searching for or replacing text strings.

  • View button. Opens a menu with the following entries:

    • Functions for zooming in or zooming out the spreadsheet.

    • Split table button. Splits the sheet above and left of the current cursor position.

    • Freeze sheet button. Freezes the rows above and the columns left of the cursor.

    • Show toolbars checkbox. Defines whether the toolbars are always displayed.

    • Show collaborators checkbox. Defines whether the document editors list is displayed. This function is only activated if you edit the document together with other users.

    • Show grid lines checkbox. Defines whether grid lines are displayed.

    • Show sheet tabs checkbox. Defines whether tabs for additional sheets are displayed below the spreadsheet.

  • Close document icon . Closes the Format window.

File toolbar

The File toolbar

Note: When having opened an encrypted document, functions for saving, downloading, sending and sharing the document are available.

Contains the following tools:

  • Rename document input field. To rename the document, click on the file name.

  • Save in Drive button. Opens a menu with the following entries:

    • Save as. Saves the selected document under a different name or in another folder.

    • Save as template. Saves the selected document as template.

    • Export as PDF. Exports the selected document in PDF format.

    • AutoSave checkbox. Defines whether the document gets saved automatically in regular intervals.

  • Download icon . Downloads the selected document.

  • Print as PDF icon . Generates a PDF version of the current document.

  • Send as mail icon . Sends the selected document as an E-Mail attachment.

  • Share icon . Opens a menu with the following entries:

    • Invite people. Displays functions for inviting other users to read or edit the document.

    • Get link. Displays functions for sharing the document with the help of a link.

Format toolbar

The Format toolbar

Contains the following:

  • Character formatting tools.

    • font family, font size

    • emphasis

    • more font styles, clear formatting

    • format painter

    • text color

  • cell formatting tools

    • background color

    • horizontal alignment, vertical alignment, automatic word wrap, merge or unmerge cells

    • currency formatting in percentage terms

    • Number format. Defines the cell content's format, e.g. number.

    • Format codes. Defines the subformat, e.g. the number of decimal places.

    • cell border, border style, border color

    • cell style

Data toolbar

The Data toolbar

Contains the following:

  • Tools for sorting the selected cells

  • Tools for filtering the selected cells

  • Tools for creating, editing or displaying named ranges. Within formulas, named ranges can be used instead of the original cell addresses.

Insert toolbar

The Insert toolbar

Contains the following tools:

  • calculate the sum of the selected cells

  • Insert a function. Clicking on it opens the Insert Function window. The window displays the available functions. If clicking on a function, a function description is displayed.

  • insert or edit hyperlink

  • insert image

  • insert a chart

Rows/Columns toolbar

The Rows/Columns toolbar

Contains the following tools:

  • insert row, delete selected row, set the row height

  • insert column, delete selected column, set the column width

Image toolbar

The Image toolbar

If an image has been selected, the Image toolbar will be displayed. It contains the following tools:

  • Delete image

  • set border style, set border color

Chart toolbar

The Chart toolbar

If a chart has been selected, the Chart toolbar will be displayed. It contains the following tools:

  • delete chart

  • define chart type, e.g. column, line, pie

  • set labels for axes, set colors, select style set

  • set labels and colors for data points

  • hide or show legend, set legend position

  • adjust data source

Document window

The document window is centrally located. It lets you create and edit the document's content.