Excel Worksheets
 |
 |
 |
 |
 |
 |
 |
Additional Resources
Excel Worksheets | Microsoft Excel XP |
 |
 |
What's on this page... Working with Worksheets Adding a New Worksheet Renaming a Worksheet Moving a Worksheet Copying a Worksheet Deleting a Worksheet |
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 Worksheets
A 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
worksheet:
| CTRL + PageUp | Activates the previous sheet, if there is one. |
| CTRL + PageDown | Activates the next sheet, if there is one. |
Adding A New Worksheet
What? Three Excel worksheets aren't enough for you! Fortunately, you can add a new worksheet to a workbook in several ways.
 |
To add a new Worksheet, follow any of the following methods:
| ► | Choose Insert ► Worksheet from the menu bar. |
| OR | |
| ► | Right-click on a sheet tab. Choose Insert from the shortcut menu. Select Worksheet from the Insert dialog box and click OK. |
| OR | |
| ► | Press SHIFT + F11 |
| Back to Top |
| See also... Rename or Move Worksheet | Copy or Delete Worksheet |
| Return to Excel XP from Excel Worksheets |
Excel XP Topics
- Tips- Excel Screen Layout
- Navigational Techniques
- Working with Workbooks
- Templates
- Working with Worksheets
- Moving Around
- Move Worksheets
- Copy Worksheets
- Insert & Delete Cells
- Insert & Delete Rows
- Insert & Delete Columns
- Resize Row
- Resize Column
- Editing Data
- Content Color
- Cell Color
- Number Formats
- Fonts
- Alignment
- Text Direction
- Indent Contents
- Merge Cells
- Copy
- Move
- Undo & Redo
- Using Zoom
- Freeze & Unfreeze Titles
- Split Worksheet
- Spreadsheet Data
- AutoFill
- AutoComplete
- Comment
- Find
- Replace
- Spellcheck
- Formulas
- Functions
- Password
- Sorting
- AutoFilter
- Advanced Filter
- Macros
- Charts
- Charting
- Charting Elements
- Gantt Chart
- PivotTable
- PivotTable Calculations
- PivotTable Layout
- PivotTable Format
- PDF to Excel
- PDF-to-Excel Converter
- Excel to PDF Converter