Multiple Worksheet Basics in Microsoft Excel 2010

As you can see, the three start-off worksheets that stock an Excel workbook share the same first name—
Sheet1, Sheet2, and Sheet3 (you move between worksheets simply by clicking the tab of the sheet you
want to access, or by utilizing these keyboard equivalents: Ctrl+Pg Dn to advance to the next sheet on
the right; Ctrl+Pg Up to the next sheet to your left). But as with file names, Sheet1, etc. are default
identities which can be changed as your needs require. As a result, you might very well want to
rename any or all of these, and it’s easy to do so. To rename a worksheet: 
•  Right-click the tab of the sheet you want to rename. Click Rename on the shortcut
menu (Figure 7–5):

Figure 7–5. By any other name..where to rename a worksheet

•  Since the current tab is selected, just type the new name, and press Enter.
You can also rename the sheet by double-clicking the sheet tab in question, which also selects the
tab. Type the new name and press Enter. You’re allotted 31 characters per name.