I want to open multiple new worksheets

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
 
G

Gordon

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


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?
 
D

Don Guillett

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top