Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
"mrbucks1" wrote in message
... 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? |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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. -- Don Guillett Microsoft MVP Excel SalesAid Software "mrbucks1" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Open multiple files into multiple worksheets of the same workbook | Excel Discussion (Misc queries) | |||
Multiple pages open when I open Excel | New Users to Excel | |||
batch file to open multiple worksheets | Excel Discussion (Misc queries) | |||
How do I open multiple hidden worksheets all at once? | Excel Worksheet Functions | |||
Multiple worksheets open on starting Excel. | Excel Discussion (Misc queries) |