Solved

How to add tab in Microsoft Excel 2010 ?

Posted on 2014-04-26
2
204 Views
Last Modified: 2014-04-27
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 ?
0
Comment
Question by:naseeam
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 5

Accepted Solution

by:
Bob Bender earned 300 total points
ID: 40025353
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
 
LVL 47

Assisted Solution

by:Martin Liss
Martin Liss earned 100 total points
ID: 40025600
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

Featured Post

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question