| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
How to make the spreadsheet only as big as the data requires?
My spreadsheet is 100's of rows long but I only need 500. How do I save a
file that reflects the used segment rather than a masssive document that is majorally blank? |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
How to make the spreadsheet only as big as the data requires?
You cannot get rid of them...........a worksheet contains a set number of
columns and rows. You can hide the unused rows and columns. If they are truly unused, they add nothing to the file size. Gord Dibben MS Excel MVP On Wed, 28 Oct 2009 02:19:01 -0700, Farmer Ra Ra <Farmer Ra wrote: My spreadsheet is 100's of rows long but I only need 500. How do I save a file that reflects the used segment rather than a masssive document that is majorally blank? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to make both averages AND sums of one spreadsheet of data | Excel Discussion (Misc queries) | |||
| How do I make a timeline using data in a spreadsheet? | Excel Discussion (Misc queries) | |||
| DATA SORT REQUIRES IDENTICALLLY MERGED CELLS???? HELP PLEASE | Excel Worksheet Functions | |||
| How to make a picture appear behind data in a spreadsheet | New Users to Excel | |||
| question requires answer | Excel Worksheet Functions | |||
Linear Mode
