by The Dean on May 19th, 2008

Question

Help answer this question below.

I used up all my default tabs( sheets) on the bottom of an Excel spreadsheet book. How do I add another tab?

Like
Report

Share:: Facebook; Twitter; Other

Answers. 3 helpful answers below.

by Greekgod on May 19th, 2008
right click on the sheet tab and choose move or copy
Comments
- Thanks, I don't know why i couldn't figure that out.
  
  Report
  
  by The Dean on May 19th, 2008
- Listen it happens all the time do not worry about it. At least you asked instead of staying quite and suffering
  
  Report
  
  by Greekgod on May 19th, 2008
Add a comment...
- Like
- Report
2 comments | Post one | Permalink
by Brian I on May 19th, 2008
Right click on the last tab and select Insert... Worksheet from the menu that appears. You may want to drag the new tab one place to the right after it's been inserted.

If you want to insert multiple new worksheets select that number of tabs before right clicking.

If you find that you often have to add extra worksheets you can increase the number using the Tools... Options menu (General tab).
Comments
- Thanks, I don't know why i couldn't figure that out.
  
  Report
  
  by The Dean on May 19th, 2008
- This method actually works the best for me. +5
  
  Report
  
  by The Dean on May 19th, 2008
- Glad to be able to help. The main problem with using the Create a Copy option is that, even after you delete everything, you still have the cell formatting and protection settings carried over from the other tab and that can cause all sorts of problems.
  
  Report
  
  by Brian I on May 19th, 2008
Add a comment...
- Like
- Report
3 comments | Post one | Permalink
by Shay37 on May 19th, 2008
Right click on one of the existing tabs click on "Move or Copy" and at the bottom of that box, select "Create a Copy"... It will be another identical page and you can delete whatever you want on it without messing with the original tab.
Comments
- Thanks, I don't know why i couldn't figure that out.
  
  Report
  
  by The Dean on May 19th, 2008
- You're welcome! It's hard to figure out because it's a weird way going about it...You'd think they would have a button that simply says "Create new tab"... :-)
  
  Report
  
  by Shay37 on May 19th, 2008
- This method is real handy if you don't want to create all those cell formulas again. +5
  
  Report
  
  by The Dean on May 19th, 2008
Add a comment...
- Like
- Report
3 comments | Post one | Permalink

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

How do I identify duplicate rows in Excel 2003? (In plain english please.)
by Yeahwell... on September 16th, 2011 | 1 person likes this
Dynamic chart issue
by Lucian_M on September 18th, 2011 | 1 person likes this
How to build a spreadsheet to record loans made monthly (at diff. interest rates) without a fixed repayment date and keep running total due?
by dganswerbag on October 14th, 2011 | 1 person likes this
In Excel how do I make a spreadsheet so a user can put in the numbers and it would calculate the result?
by KATTALNUVA on October 14th, 2011 | 1 person likes this
I need a formula in Excel that does the following.. If the value in cell A1=X, then multiply cell B1 by 5..if A1=Y, then multiply B1 by 8.
by leslie2413 on September 1st, 2011 | 2 people like this
More Microsoft Excel See only professionally researched Microsoft Excel questions

You're reading I used up all my default tabs( sheets) on the bottom of an Excel spreadsheet book. How do I add another tab?

Question

I used up all my default tabs( sheets) on the bottom of an Excel spreadsheet book. How do I add another tab?

Answers. 3 helpful answers below.

Comments

Comments

Comments

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

Follow us on Facebook!

Related Ads

Related Questions

I have a microsoft excel spreadsheet with multiple tabs (pages) however when It is open windows shows an excel icon for each tab on the task bar, like I have 12 excel files open instead on one file with 12 tabs. How can I fix this?

How can I configure an Excel spreadsheet to transfer page data and charts on one tab to special forms and charts on other tabs automatically?

I need Excel help! I am trying to add a tab at the bottom...how do I do this?

I want to print 4 tabs in excel (2003) to one pdf (adobe reader 9) file. Why does excel print the first tab to one pdf file and the next three tabs to a different pdf file?

In Excel, how do I create a list from the same cells on different sheets within a book? Example: Cell A1 on each sheet lists a different name. Cell A2 lists a number. Can I create a report that will list the A1 and A2 from multiple sheets for comparison?

Professionally Researched

How Do I Delete a Tab From an Excel Spreadsheet?

How do I add a calendar date picker to an Excel spreadsheet?

How do I add an alert in an Excel spreadsheet?

How do i add an excel spreadsheet to a blogger post?

How do i add days to a date in a spreadsheet in ms excel?

ANSWERBAG BUZZ

Answerbag.com
Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!

Question

I used up all my default tabs( sheets) on the bottom of an Excel spreadsheet book. How do I add another tab?

Answers. 3 helpful answers below.

Comments

Comments

Comments

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

Follow us on Facebook!

Related Ads

Related Questions

Professionally Researched

ANSWERBAG BUZZ

Answerbag.com Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!

Answerbag.com
Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!