quick way to add tabs

[excellentexcel]

hi guys just wondering if there is a quick way to add any number of tabs to a spreadsheet

ie one particular spreadsheet i need to have 32 sheets (tabs) but am getting seriously bored to right click insert worksheet time after time
there must be a quicker way???

thanks

[dylanemcgregor]

I don't have a copy of Excel 2007 on me, but I thought that one of the nice features was a "+" button on the tab/worksheet bar that automatically added a new worksheet?

If you are using an older version of Excel then I don't know of an answer.

[VBA Noob]

Using Xl07 if you click on the icon next to the sheet tab it will add a new sheet or try pressing shift + f11.

Or right cick sheet tabs > select all sheets > move or copy > tick copy

HTH

VBA Noob

[dylanemcgregor]

or try pressing shift + f11.

Thanks for this one. Works in 2003 as well, and something I never knew about, but will find useful.

[excellentexcel]

hey thanks guys
ive just found a nice little option purely by chance
go to excel options when creating new workbook and then input the number of sheets you want
open new
then reset it
sorry

[VBA Noob]

Not ideal method if each new workbook has lots of sheets as will increase the size of you're new excel files from now on unless you remember to change it back

Please mark as solved

VBA Noob

[excellentexcel]

shift + f11 is good though
thanks for that