4.2. The Spreadsheet Edit Page Components

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

  • File button. Shows the File tool bar that allows applying file functions.

  • Format button. Shows the Format tool bar that allows formatting the document's contents.

  • Insert button. Shows the Insert tool bar that allows inserting objects like images, tables or hyperlinks in the spreadsheet.

  • Rows/Colums button. Shows the Review tool bar that allows using 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 to the left of the cursor.

    • Show tool bars checkbox. Defines whether the tool bars 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 tool bar 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 dialogue. Use the control elements in the upper part of the dialogue to print the document or to save it as a PDF file.

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

Format tool bar Contains the following:

  • character formatting tools

    • font family, font size

    • emphasis

    • text colour

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

    • cell borders, border style, border colour

    • Merge or unmerge cells.

    • cell style, copy formatting, delete formatting

Insert tool bar 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 tool bar will be displayed.

  • insert a chart

    If a chart is selected, the Chart tool bar is displayed that allows editing the chart.

Rows/Columns tool bar 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.