How to add tab in Microsoft Excel 2010 ?

I have some.xls file  In the bottom of file there are tabs.  I have overview tab, Specs tab, etc.

I want to add another tab which will contain Revision History of my file.  How do I do that ?
LVL 1
naseeamAsked:
Who is Participating?
 
Bob BenderConnect With a Mentor Commented:
Since it seems you have a bunch of sheets.....

To the left of the Sheet names is a navigation tool.   Use the right most one(  >| symbol ) to go to the end of the list of spreadsheet list.

Click on the * tab (last one on list with a gold sparkly star) and a new Sheet opens up.

Right click on the tab and you can rename it.

Bob
0
 
Martin LissConnect With a Mentor Older than dirtCommented:
Here's a macro you can use.

Sub AddSheet()

    Sheets.Add After:=Sheets(Sheets.Count)
    Sheets(Sheets.Count).Select
    Sheets(Sheets.Count).Name = "Revision History"
End Sub

Open in new window


To do it manually
1.    select the sheet that the new sheet should follow
2.    press Shift+F11
3.    right-click on the new tab and select 'Rename'
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.