Difference between revisions of "Documentation/OOoAuthors User Manual/Getting Started/Renaming sheets"

From Apache OpenOffice Wiki
Jump to: navigation, search
 
Line 13: Line 13:
 
* Right-click on a sheet tab and select '''Rename Sheet''' from the pop-up menu and replace the existing name with a better one.
 
* 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|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.}}
+
{{Note|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.}}
  
 
{{CCBY}}
 
{{CCBY}}
 
[[Category:Getting Started (Documentation)]]
 
[[Category:Getting Started (Documentation)]]

Latest revision as of 09:01, 2 July 2018


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