Spreadsheet

4.4. Editing Spreadsheets

The following options exist:

Note: In order to edit a document, you need to have edit permissions for the Drive folder containing the document.

How to edit a spreadsheet:

  1. Create a new spreadsheet or open an existing spreadsheet.

  2. To edit the document, use the common techniques from the familiar Office applications:

    • To format characters or paragraphs or to edit cells, use the Format toolbar.

    • To use the clipboard functions, use the context menu or your system's key combination.

    • In order to sort or filter selected cells or to create named ranges, use the Data toolbar.

    • To insert various elements, use the Insert toolbar. Those elements can be inserted:

      • sum functions or other functions

      • hyperlink, image, chart

      • comments

        To display, create or edit comments, use the Review toolbar.

    • In order to insert, delete or format whole rows or columns, use the Rows/Columns toolbar.

    Tip: Many functions can also be activated in the context menu.

    Note: All changes are immediately saved.

  3. In order to add or delete a table or to change the tables' order, use the table tabs below the table.

  4. To search and replace text elements, click the Toggle search icon on the right side of the Office menu bar. Control elements for searching and replacing will be shown.

  5. To rename, save, download or print the spreadsheet or to send it in an E-Mail, use the File toolbar.

  6. To finish editing and to close the spreadsheet, click the Close document iconon the right side of the Office menu bar.

User interface:

Related topics:

Parent topic: Spreadsheet