Spreadsheet

4.2. The Spreadsheet Edit Page Components

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.

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

  • 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

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.

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

  • Download icon . Downloads the selected document.

  • Print icon . Displays the current document in a print dialog. Use the control elements in the upper part of the dialog to print the document or to save it as a PDF file.

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

Format toolbar 

The Format toolbar

Contains the following:

  • character formatting tools

    • font family, font size

    • emphasis

    • text color

  • cell formatting tools

    • horizontal alignment, vertical alignment, automatic word wrap

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

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

    • cell fill color

    • cell borders, border style, border color

    • Merge or unmerge cells.

    • cell style, copy formatting, delete formatting

Insert toolbar 

The Insert toolbar

Contains the following tools:

  • calculate the sum of the selected cells

  • 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

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.