Each time you open a new document in Excel, you open a new workbook containing three worksheets. Worksheets can be added to and deleted from the workbook. It may help to think of a workbook as an entire document and the worksheets as pages within the document.
When you save an Excel document, you are saving and naming the entire workbook. You can also name the worksheets within a workbook, as described in this guide.
Activating and Moving Between Worksheets
To activate a Worksheet, click the desired tab at the bottom of the Excel screen. In the example below, click Sheet1 to activate that sheet.
To move between worksheets, click another tab at the bottom of the Excel screen. In the example below, click the Sheet2 tab to activate Sheet 2.
Selecting Multiple Worksheets
To select multiple worksheets, select the first worksheet tab and press Shift + click to select contiguous sheets, or Ctrl + click to select non-contiguous sheets.
In the example below,
Hold down the Ctrl key.
Click Sheet3. Sheets 1 and 3 are selected.
Adding a Worksheet to a Workbook
To add a worksheet to a workbook, click the Insert Worksheet tab, or press Shift + F11.
Deleting a Worksheet from a Workbook
To delete a worksheet from a workbook
Select the sheet to delete.
Right-click the tab and choose Delete.
Changing the Name of a Worksheet
To change the name of a worksheet,
Right-click the sheet to rename, and select Rename.
Type a new name for the worksheet. In the example below, type Apples.
Press Enter or click away from the tab.
Changing the Sheet Tab Color
To change the sheet tab color,
Right-click the sheet to rename and choose Tab Color.
Select the desired color from the Colors pallet. The tab color changes.
To rearrange worksheets, click and drag the desired sheet to the desired location.
In the example below,
Click the Apples tab.
While holding down the left mouse button, drag the Apples tab between Sheet1 and Sheet2. Notice the cursor, and the arrow pointing to the new sheet location.
Release the mouse button. The Apples worksheet is moved between Sheet1 and Sheet2.
Hiding and Unhiding Worksheets
To hide a worksheet, right-click the sheet to hide and select Hide.
To unhide a worksheet,
Right-click any of the tabs and select Unhide.
Select the sheet to unhide from the Unhide dialog box.
This Audacity tutorial will show you how to use the basic tools and procedures in the open source audio editing program, Audacity. Not just screen shots, but free narrated multimedia tutorials - You'll learn to use Audacity for recording and editing audio files that can be used for podcasting, mixing music and vocals, creating sound tracks, and other audio projects.
This Excel 2003 Tutorial will introduce you to the basics of using the Excel 2003 spreadsheet program. You'll learn to create a spreadsheet, basic Excel workbook skills, work with cells, enter and manipulate data, apply formulas, format data, create and work with charts, and manage Excel workbooks.
This Podcasting tutorial includes a step by step guide that will show you how to record, publish and promote your podcast. Using inexpensive equipment and free software, you'll be publishing podcasts in no time.
This LCD Projector Guide will assist you in the use and purchase of a digital LCD projector or DLP projector. It will discuss the differences between LCD and DLP projectors, size and portability considerations, lamp types and brightness, resolution, image quality and other considerations in the use and purchase of a digital projector.
This Microsoft Word 2007 Workspace tutorial will acquaint you with the new tools and features in the Word 2007 Window. It's changed significantly from previus versions and even experienced users will find this helpful.
Get the Excel 2007 Ebook: The Ultimate Guide and receive all of the Excel 2007 tutorials in one handy reference guide. Purchase online easily with your credit card or PayPal and have the Ebook emailed to your email address (pdf format)
Price: $12.95. California residents pay 7.25% Sales tax. Delivered via email.