Renaming sheets

From Apache OpenOffice Wiki
Jump to: navigation, search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.


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