Additional Resources
|
Excel Worksheets | Microsoft Excel XP
|
![Microsoft Excel XP logo](https://www.word-excel-access-help.com/image-files/xexcel_01.jpg.pagespeed.ic.QyAeKTxAp-.jpg) |
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.
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. |
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 |
|
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
|