Reducing file size in Microsoft Excel

In this article, we will learn how we can reduce the used area in a sheet in Microsoft Excel. The vertical scroll bar gets shorter as the used area of a sheet grows larger thereby making it inconvenient to use. Reducing the size of the used area also reduces the size of the workbook.

Let’s take an example to understand how we can reduce the used area in a sheet.

We have a worksheet, and the size of that worksheet is 228KB.

img1

To reduce the file size, follow below given steps:-

  • Open the worksheet.
  • Find the last cell that contains data in the sheet.
  • Delete all the rows and columns after this cell.
  • In this example, to delete the rows, select the blank cell after the last cell D11 to the data.
  • Select the cell D12.
  • Press the key Shift+Space on your keyboard.
  • Press Ctrl+Shit+Down Arrow key.
  • Rows will get selected till the last row.
  • Press Ctrl+- on the keyboard to delete the blank rows.
  • To delete the columns, select the blank cell after the last cell D1 to the data.
  • Select the cell E1.
  • Press the key Ctrl+Space on your keyboard.
  • Press Ctrl+Shit+Right Arrow key.
  • Columns will get selected till the last row.
  • Press Ctrl+- on the keyboard to delete the blank columns.

img2

This way the data size will reduce from 228KB to 194KB in Microsoft Excel.

Users are saying about us...

  1. I have Excel 2002 running in WinXP. (In addition to your tip, some instructions say to select cell A1 before saving.) However I have found that this procedure is very unreliable and doesn’t always work. (This has been after trying to insert columns which would be trying to push data off the sheet.) I have had to resort to copying all my data to a new Sheet to reduce the “used area”. If you are aware of this problem, and know a way around it I would like to know. Cheers

  2. “Excel remembers the selected cell position and this can be useful for work that one wishes to resume at a later time or in cases where the same cells are used over and over.

    Needless to say it can become a major annoyance to have to move the cursor before making a single entry if said entry is done dozens of times per day.

    Could someone tell me how to make a cell become NULL (not an empty string) with VBA?

    This would probably help solve the reliability problem of the above tip.

    Thanks,

    Louis Rousseau”

  3. Thanks for this! I was deleting the rows, but the area still wouldn’t shrink. I didn’t realize that you actually had to do a save before the shrink would actually take effect.

  4. There is a typo (or perhaps, the product of a warped sense of humor? ;) “Ctrl+Shit+Down”

    Thanks for the great information!

    Yes, Saving after the edit did have to be done for me as well before I could see the change. I still have more rows than desired, but not 1000′s anyway!

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube