Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i make spreadsheet have fewer rows
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i make spreadsheet have fewer rows
Look he
http://www.contextures.com/xlfaqApp.html#Unused -- Kind regards, Niek Otten Microsoft MVP - Excel "Lindab" wrote in message ... |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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i make spreadsheet have fewer rows
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 DTHIS web: www.nickhodge.co.uk UK Excel User Conference In Cambridge November 28th - December 1st 2007 Register Now @ http://www.exceluserconference.com/UKEUC.html "Lindab" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i make spreadsheet have fewer rows
Thanks for your reply Niek. I am going to go over the article and I do thank
you for your quick response. "Niek Otten" wrote: Look he http://www.contextures.com/xlfaqApp.html#Unused -- Kind regards, Niek Otten Microsoft MVP - Excel "Lindab" wrote in message ... |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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I make rows and columns appear when I print a spreadsheet | Excel Worksheet Functions | |||
Can I make rows of an excell spreadsheet 'selectable' (on/off)? | Excel Worksheet Functions | |||
Decrease size of a worksheet so it has fewer than 64,000 rows? | Excel Discussion (Misc queries) | |||
Linking from several cells of 1 spreadsheet to fewer of another? | Excel Worksheet Functions | |||
Print several worksheets at once with fewer pages | Excel Discussion (Misc queries) |