how can i make spreadsheet have fewer rows

[Guest]

I have made a spreadsheet for a calendar of physicians schedules. The file I
have made for 2008 has a worksheet that I use to calculate how many call
days, vacation days, time in each office. The worksheet that I use to
calculate these items has 66,000+ rows. I am afraid I have forgotten how to
reduce the size of each individual spreadsheet within a file. Please help!
This file takes 10 minutes to open and save.

 

[Niek Otten]

Look here:

http://www.contextures.com/xlfaqApp.html#Unused

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have made a spreadsheet for a calendar of physicians schedules. The file I
| have made for 2008 has a worksheet that I use to calculate how many call
| days, vacation days, time in each office. The worksheet that I use to
| calculate these items has 66,000+ rows. I am afraid I have forgotten how to
| reduce the size of each individual spreadsheet within a file. Please help!
| This file takes 10 minutes to open and save.

 

[Nick Hodge]

Linda

There is no compact command as in Access. If you have 66,000+ rows this must
be XL2007 (Prior versions only have 65536 rows)

If this is the case you could try highlighting any additional rows between
the bottom when when dragging the vertical scrollbar all the way down and
the last row after your actual data. Once you have highlighted the *entire*
rows, right click any selected row label and select delete. Save the file
and that's as small as you'll get it (Doing the same for columns as well)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html

 

[Guest]

Thanks for your reply Niek. I am going to go over the article and I do thank
you for your quick response.