ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Large Excel file size (https://www.excelbanter.com/excel-discussion-misc-queries/100520-large-excel-file-size.html)

Simon G

Large Excel file size
 
I am creating a number of small sheets using the top left hand corner of the
available space (A1 to AN45). However, if I hit [End] [Home] the cursor goes
to the bottom right hand corner of the sheet, (cell IV65536), despite the
cells from AN45 to IV65536 being empty. I frequently select all of the blank
rows (and columns) and delete them. This results in a small file becoming
significantly large. How do I correct this problem?

Ron de Bruin

Large Excel file size
 
Have you save/close/reopen ?

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



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Simon G" wrote in message ...
I am creating a number of small sheets using the top left hand corner of the
available space (A1 to AN45). However, if I hit [End] [Home] the cursor goes
to the bottom right hand corner of the sheet, (cell IV65536), despite the
cells from AN45 to IV65536 being empty. I frequently select all of the blank
rows (and columns) and delete them. This results in a small file becoming
significantly large. How do I correct this problem?





All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com