Dakalo said:
WHY IS IT THAT WHEN DELETING INFORMATION IN A SHEET, THE
SIZE OF THE DOCUMENT DOES NOT GET REDEUCED?
Please turn off your Caps Lock.
Ignoring things such as charts, graphics, etc, the size of a file depends
largely on the number of cells in the used area of each worksheet. On any
worksheet, you can get to the 'last used cell' using Ctrl+End. In this
context, a cell is 'used' either if it contains something or if it is
formatted.
If you delete data but leave formatting, you will not see any appreciable
decrease in file size. The same will apply if you delete lots of data but
leave something (anything - even just a space character) in a cell far from
the top left (cell A1).
If Ctrl+End takes you past where you think it should, select all rows below
the area you want and delete them (using Delete on an Edit menu, NOT the
keyboard Delete key). Repeat for columns to the right of your data/formulas.
Save the file (and, on some early versions of Excel, close and restart
Excel). Ctrl+End will now take you to where you think is the end of your
used area, and the file size will be smaller.
One more general hint: Formatting whole rows and/or whole columns is much
more efficient than formatting individual cells. Basically, if you format
column A, Excel remembers the formatting data once. If you format only cells
A1:A50, it remembers it 50 times.
