Trimming Spreadsheet. How to get excel to recognize only used spa

G

Guest

I have several large (as in using a vast number of cells) spreadsheets that
are becoming a problem regarding their size. When I hit ctrl-end to see what
excel recognizes as the end of a particular spreadsheet, it, for some reason,
includes an additional 500 rows. How can I get excel to recognize the actual
last row/column cell?
 

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

Excel Visual Basic to get current row number 1
Excel comments moving and changing sizes 2
Why the arbitrary spreadsheet size limitations? 7
Matching and Moving Data From One Spreadsheet to Another? 1
How Do I minimize .XLS file sizes from 7M+? 1
How to print only the used portion of excel spreadsheet? 4
Manually delete cells not being used at ends of workbook 3
Exporting to csv file 5

Top