Renaming sheets

From Apache OpenOffice Wiki
< Documentation‎ | OOoAuthors User Manual‎ | Getting Started
Revision as of 09:01, 2 July 2018 by Sancho (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

The default name for the a new sheet is "SheetX", where X is a number. While this works for a small spreadsheet with only a few sheets, it becomes awkward when there are many sheets.

To give a sheet a more meaningful name, you can:

  • Enter the name in the name box when you create the sheet, or
  • Right-click on a sheet tab and select Rename Sheet from the pop-up menu and replace the existing name with a better one.
Documentation note.png Sheet names must start with either a letter or a number; other characters including spaces are not allowed. Aside from the first character of the sheet name, allowed characters are letters, numbers, spaces, and the underline character. Attempting to rename a sheet with an invalid name will produce an error message.
Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Personal tools