View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mike Rogers Mike Rogers is offline
external usenet poster
 
Posts: 194
Default Excel 2002 : How to reduce the number of unused worksheet ?

Mr. Low

Save you work and back it up. Select the first one you want to delete, get
over to the last one hold down "shift" hit "enter". All those sheets should
be selected (it will say "grouped" after your file name at the top). Right
click and select "delete". Make sure you have ONLY the ones you want to
delete selected. If by some chance you deleted something not intended, close
your wok without saving and start over.

Mike Rogers

"Mr. Low" wrote:

Dear Sir,

I have a file which was open with maximum number of worksheet (255 pages) by
its default.

I have done a lot of work in that file using up about 50 pages currently,..

I wish to only have 60 pages active and the remaining 195 pages to be added
when I need them. This is to reduce the memory usage of the PC .

Is there a way to removed those unused worksheet ?

For future new files I have already default it at 10 worksheet .



Thanks

Low


--
A36B58K641