How to make the spreadsheet only as big as the data requires?

F

Farmer Ra Ra

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?
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Slow opening spreadsheet with images in Excel 2007 0
Microsoft Works to Microsoft Office 6
Lookups - how to obtain data from a master spreadsheet into another 5
Merging Data from two rows into one 1
Another Running Totals Problem 9
How could I split a spreadsheet containing 600 rows, so there's 100rows in each new workbook 6
pulling data from two spreadsheets 1

Top