word-excel-access-help.com logo
Excel Worksheets
Home
Word 2007
Excel 2007
Access 2007
Word xp
Excel xp
Access xp

Additional Resources







Excel Worksheets | Microsoft Excel XP

Microsoft Excel XP logo
Learn step-by-step what Excel worksheets are and what to do with them. Learn how to add, rename, move, copy and delete worksheets in a few easy steps.

Excel Office Helper 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.

Excel worksheets tabs example


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.

Excel Worksheets Tab Scrolling Buttons

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.

Excel Worksheets: Insert a New Worksheet


To add a new Worksheet, follow any of the following methods:

Choose InsertWorksheet 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
- Print
- 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