Renaming sheets

Getting Started with OpenOffice.org 2.x

Chapter 7: Getting Started with Calc

< Previous Section

Next Section >

• Parts of the main Calc window
• File management
• Navigating within spreadsheets

• Going to a particular cell
• Moving from cell to cell
• Moving from sheet to sheet

• Selecting cells
• Selecting columns and rows
• Inserting columns and rows
• Deleting columns and rows
• Working with sheets

• Inserting new sheets
• Deleting sheets
• Renaming sheets

• Viewing Calc

• Freezing rows and columns
• Splitting the window

• Entering data into a sheet
• Printing

• Print options
• Selecting sheets to print
• Printing rows or columns on every page
• Defining a print range

< Previous Page

Next Page >

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.

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.