4.2. The Spreadsheet Edit Page Components

Office menu bar The Office menu bar includes the following buttons:

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

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

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

  • Rows/Colums button. Shows the Review 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 sheet 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 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 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

    • Save 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 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 Contains the following tools:

  • calculate the sum of the selected cells

  • insert or edit hyperlink

  • insert image

    If a file has been selected, the Drawing toolbar will be displayed.

  • insert a chart

    If a chart is selected, the Chart toolbar is displayed that allows to edit the chart.

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

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