Inserting And Renaming Worksheets

Download starting Sheet

We have finished with the data entry sheet now, so lets create an index page. We now need to insert a worksheet.

Insert A Worksheet

Steps:

• Press in sequence: ALT then I then W

Note:

• This will add a new worksheet at the beginning of the workbook.
• The name of the new worksheet will be "Sheet4" if the name of the last sheet added was "Sheet3".  i.e. it adds 1 to the number at the end.
• To select the new worksheet, just click on the tab at the bottom

Rename A Worksheet

To rename a worksheet, double click on the current tab name, and type in your new name.

• Do this now, and rename the new worksheet: "Index", and the data worksheet: "Data"

Note:

• You cannot name a worksheet with the same name as an existing worksheet
• Worksheet names cannot be over 31 characters long
• Worksheets cannot be named using certain characters  ( / for example)
• You cannnot Undo this action
• Changing a worksheet name will automatically change any formulae / charts or pivot tables linked to that worksheet.
• You cannot insert or rename a worksheet if the workbook structure is protected

Other things you can do with a worksheet tab:

If you right click on a worksheet tab, you'll see that you can:

• Delete the tab
• Move it around
• Copy it
• Change the colour
• Hide it

Your sheet should now look like this

Next Lesson: Teach Yourself Excel Lesson 25 - Create A Pivot Table

Training Video on Inserting And Renaming Worksheets in Excel: