I want to open multiple new worksheets

  • Thread starter Thread starter mrbucks1
  • Start date Start date
M

mrbucks1

I have projects wehre I need 30+ worksheets. I used to be able to click the
new worksheet button, paste headings and start. With 2007 it seems I have to
go through 3 steps. Is there a blank worksheet button I can set up to click
and open. I do not like that I have to clieck the icon, new, and then click
the copy of the new blank worksheet.

So, in a nutshell, is there a one click new worksheet button somewhere?

Thanks

TB
 
mrbucks1 said:
I have projects wehre I need 30+ worksheets. I used to be able to click the
new worksheet button, paste headings and start. With 2007 it seems I have
to
go through 3 steps. Is there a blank worksheet button I can set up to
click
and open. I do not like that I have to clieck the icon, new, and then
click
the copy of the new blank worksheet.

So, in a nutshell, is there a one click new worksheet button somewhere?

Thanks

TB
Click to expand...


Do you mean a work SHEET within a workbook, (because you can set Excel to
open as many worksheets in a new workbook as you like) or are you talking
about individual workBOOKS?
 
Have you looked at the item immediately to the right of your last worksheet
tab. And/or customize the ribbon and add the insert worksheet icon.
 
Back
Top