Excel: How do I insert a new worksheet? How do I name my worksheets?

Problem:

Microsoft Excel: How do I insert a new worksheet? How do I name my worksheets?

Solution:

Adding Worksheets - Office 2003 and Earlier

  1. To add a single worksheet, click on the Insert menu at the top of the screen and select Worksheet.
  2. Another way to add one worksheet at a time is to go to the bottom of your open worksheet where you see Sheet 1.
  3. Right click on the name (Sheet 1, 2, etc.), and choose Insert from the menu.
  4. You will be asked what you would like to add, choose Worksheet and click ok.

Adding Worksheets - Office 2007

To add a worksheet in Office 2007 click the New Worksheet button to the right of your right-most sheet tab. You can also use Shift+F11.

Naming A Worksheet - All Versions

In order to change the name of a worksheet to something other than Sheet 1, Sheet 2, etc.

  1. Locate the sheet name at the bottom of your Excel workbook.

  2. Right click on the name of the sheet you want to change.
  3. Select the Rename option from the pop-up menu.
  4. Simply begin typing the name that you would like to appear.

Did this document solve or help you with your problem?

Yes   No  

Category: Software : Excel     Platform: All Windows
Document #: 480     Author: Echo Schneider    
Last Modified by: Joshua Moor on 06/10/2008