ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   My worksheet went from 80KB to 4MB why? (https://www.excelbanter.com/excel-discussion-misc-queries/35418-my-worksheet-went-80kb-4mb-why.html)

Kelly

My worksheet went from 80KB to 4MB why?
 
How could I go from 80KB to 4MB?

Biff

Hi!

One possibility:

Hold down the CTRL key and hit the END key.

Where does it take you? Is there any data in that area?

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

Other contributors: formatting entire columns or rows when it's not needed!
Using entire columns or rows as range references when not necessary!

Biff

"Kelly" wrote in message
...
How could I go from 80KB to 4MB?





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

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