Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default I want to open multiple new worksheets

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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 83
Default I want to open multiple new worksheets

"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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10,124
Default I want to open multiple new worksheets

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open multiple files into multiple worksheets of the same workbook lil Matt Excel Discussion (Misc queries) 1 October 31st 06 09:03 PM
Multiple pages open when I open Excel Lancashire Lass New Users to Excel 1 August 20th 06 05:52 PM
batch file to open multiple worksheets Kurt S Excel Discussion (Misc queries) 4 June 12th 06 07:45 PM
How do I open multiple hidden worksheets all at once? Last Samurai Excel Worksheet Functions 2 July 15th 05 02:41 AM
Multiple worksheets open on starting Excel. Jerry Excel Discussion (Misc queries) 3 April 13th 05 06:45 PM


All times are GMT +1. The time now is 04:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"