If you look at an Excel workbook, you may notice that it's composed of one or more worksheets, each with its own little tab at the bottom-left of the workbook window.
These tabs make Excel worksheets look like upside-down folders (you know, those manila folders that fit neatly into a drawer, and whose tabs make them easy to find even if the folders are all stacked into right rows).
The similarity stops there, however, because Excel worksheets are much more useful than a bunch of upside-down manila folders.
Excel worksheets are the holders of the cells into which you place your valuable, hard earned data. Just try putting some valuable things into upside-down manila folders in your file cabinet!
On this page, you'll find out about fundamental worksheet management.
Working With WorksheetsA workbook can consist of any number of Excel worksheets.
To activate a different worksheet, just click its tab. If the tab for the sheet that you want to activate is not visible, use the tab scrolling buttons (located to the left of the worksheet tabs) to scroll the sheet tabs.
You can also use these shortcut keys to activate a different
|CTRL + PageUp
|Activates the previous sheet, if there is one.
|CTRL + PageDown
|Activates the next sheet, if there is one.
|Choose Insert ► Worksheet from the menu bar.
|Right-click on a sheet tab.
Choose Insert from the shortcut menu.
Select Worksheet from the Insert dialog box and click OK.
|Press SHIFT + F11
|Back to Top
|See also... Rename or Move Worksheet | Copy or Delete Worksheet
|Return to Excel XP from Excel Worksheets