Computer Training & Application Solutions made Simple
Contact us for a free consultation
  • Click to send us an email. We'd love to hear from you!   Ottawa       613-656-4229
  • Click to send us an email. We'd love to hear from you!   Montreal    514-342-9494

MS  EXCEL - REMOVE FILE BLOAT AND STOP PRINTING OF BLANK PAGES

Courtesy of
DJH Training & Application Solutions Inc.

Is your Excel file painfully slow to open and/or work with?  Or perhaps Excel insists on printing a blank page even though there isn't one?

When you save a workbook, Excel only stores the part of that worksheet that contains data or formatting. Problems can arise when Excel thinks empty cells still contain data or formatting even if they no longer do. As a result, the file size is much larger than necessary. It may also result in printing of blank pages when you print a worksheet.

To avoid this, locate the last used cell according to Excel, and then reset that cell. Here is how:

Step 1. Locate the last cell used by holding down Ctrl + End. If this cell falls far beyond your actual used range, you have a problem. No worries, though, as this can easily be resolved by continuing with the steps below. You may want to check your file size before performing the steps below to compare it to the size afterwards.

Step 2. Reset the last cell by selecting the column to the right of the last column used, holding down Ctrl + Shift + Right Arrow and then clicking the Clear button on the Home tab > Editing group and selecting Clear All. Repeat for rows by selecting the row under the last row that contains data, holding down Ctrl + Shift + Arrow Down and again clicking the Clear All option.

Step 3. Close the file, making sure to keep the changes. Re-open the file and re-check the last cell used with Ctrl + End. The file size often will decrease as well, so check that.

Step 4. If the file is still slow to open and the file size has not decreased significantly, click the File tab > Save As and select Excel Binary Worksbook as the file type. This is a compressed file type that can contain macros. Other than decreasing the file size and increasing the speed, you will notice no difference between a binary file and regular Excel Workbook file. Check the file size again. Most of the time, this will decrease significantly.



More Newsletter Articles

© 2019 DJH Training & Application Solutions Inc.

WOULD YOU LIKE TO USE THIS ARTICLE IN YOUR NEWSLETTER, EZINE OR WEB SITE? You can, as long as you include this complete blurb with it: An entrepreneur at heart, Deborah J. Sparks established DJH Training & Application Solutions Inc. over 25 years ago, realizing her dream of creating a company known for providing high quality computer software training, application development and support and exercising her passion for teaching. To learn more and to register for DJH's free newsletter, Innovations, please visit www.djhsolutions.ca.