Renaming spreadsheets
Each spreadsheet in a notebook has a tab at the bottom. This tab displays the name of the spreadsheet. Spreadsheets are initially named with letters of the alphabet in sequence, from A to Z, continuing from AA to AZ, up to ZZZ. You can assign a descriptive name to a spreadsheet using up to 64 characters (letters and numbers).
You can also change the spreadsheet name to reflect the naming conventions used by applications such as Microsoft Excel.
To rename a spreadsheet |  |
|
1.
|
|
Click Format
 Sheet properties. |
|
2.
|
|
Click the Name tab.
|
|
3.
|
|
Type a descriptive name.
|
|
•
|
|
The Objects sheet (the last sheet in the notebook) cannot be renamed.
|
|
•
|
|
When you rename a spreadsheet, formulas that refer to the renamed spreadsheet adjust to use the new name.
|
|
•
|
|
To reassign the original name to a spreadsheet, click Reset.
|
|
•
|
|
You can also name a spreadsheet by double-clicking its tab.
|
To use Microsoft Excel conventions when you rename a spreadsheet | |
|
1.
|
|
Click Tools
Settings. |
|
2.
|
|
Click Compatibility.
|
|
3.
|
|
Enable the Display as numbers check box.
|
|
•
|
|
To change spreadsheet tabs back to letters, disable the Display as numbers check box.
|