Excel Magic 3: Tame Those Worksheets!

MICROSOFT EXCEL 2003, 2007 and 2010:
Worksheet Management

1. Insert
Keyboard - Shift F11 (All Versions)
Right click and select - Insert Worksheet (2003)
Click the Insert Worksheet Button (2007 and 2010 only)

2. Delete
Right click a sheet and select - Delete.
Note: Deleted sheets cannot be restored.

3. Move or Copy
Click and drag a sheet tab to move it to a new position between existing sheets. Right click and select Move or Copy to duplicate a sheet or move it to a different workbook.

4. Rename
Right click and select - Rename.
Note: The characters - ?\*/[ ] . : - are reserved by the system and cannot be used in a worksheet name. The word "history" is also reserved. Insert a number or underscore after the word if it must be used as a sheet name.

5. Set Tab Color - Hide or Unhide
Right click and select - Tab Color.
Hide - Right click a sheet and select - Hide.
Unhide - Right click any sheet and select - Unhide.

6. Navigate Worksheets or View a List
Navigate: Use the arrows next to the sheet tabs to go to the first, previous, next or last worksheet.


View a List of All Worksheets:
Right click the arrows next to the sheet tabs. A list of non-hidden worksheets displays.

To view both hidden and non-hidden worksheets, view File Properties.
2003 - File Properties, Contents Tab
2007-2010 - Office Button, Prepare, Properties, Document Properties, Advanced, Contents Tab


7. Format An Entire Worksheet
Select the entire worksheet - click the button above Row 1.

8. Group and Format Multiple Worksheets
Format multiple worksheets at the same time:
- Click the first worksheet tab. Hold the control key and select the other tabs. Grouped worksheets display the same white color. Right click and select - Ungroup Sheets to turn off grouping.

9. Save a Worksheet as a Template
Press the F12 key. Select - Excel Template in the Save as Type List.


10. Create Formulas to Calculate Between Worksheets
Include the sheet name before the cell range in the formula:
=SUM(Sheet1!A4,Sheet2!A4)

Join our Global Learning Community
The Microsoft certified professionals at Brandpointe can help you conquer FOE (Fear of Excel).

Quick guides, AdobeConnect sessions, Flash videos or Skype sessions with an instructor, we can provide successful tools.

Register to become a member of our online community. We provide a seamless learning experience anytime you need it, with Ovation - our global learning site. www.beovation.com