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

From Apache OpenOffice Wiki
Jump to: navigation, search
 
(Clean up TOC and category references)
Line 1: Line 1:
{{GSCalcToc|Calcsheet=block|PrevNext=block|Prev=Documentation/OOoAuthors_User_Manual/Getting Started/Deleting sheets|Next=Documentation/OOoAuthors_User_Manual/Getting Started/Viewing Calc}}
+
{{Documentation/GSCalcTOC
 +
|Calcsheet=block
 +
|ShowPrevNext=block
 +
|PrevPage=Documentation/OOoAuthors User Manual/Getting Started/Deleting sheets
 +
|NextPage=Documentation/OOoAuthors User Manual/Getting Started/Viewing Calc
 +
}}
 
==Renaming sheets==
 
==Renaming sheets==
  
Line 10: Line 15:
  
 
'''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.
 +
 +
[[Category:Getting Started (Documentation)]]

Revision as of 11:02, 7 November 2007


Renaming sheets

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.

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.

Personal tools