• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 227
  • Last Modified:

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 ?
2 Solutions
Bob BenderCommented:
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.

Martin LissOlder than dirtCommented:
Here's a macro you can use.

Sub AddSheet()

    Sheets.Add After:=Sheets(Sheets.Count)
    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'
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.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now