One of my Excel files takes a great deal of time to open. The file does not contain very much information and I am wondering why I need to wait so long for it to open. Can you let me know if there is something I can do to make it open as fast as my other files?

You may be surprised to know that the file is larger than you think. At some point you may have hit a key that took you to the very last page that is available in your worksheet or at least half way.

Depending on the version of Excel you are using, the worksheet could contain 65,536 rows and 256 columns. If your cursor jumped to the bottom of the worksheet and you tapped one of the keys, Excel thinks that this point is the end of your worksheet even if most of the rows and columns are empty. This action has caused the file to open very slowly because it needs to load all the rows and columns contained in your worksheet.

To correct this: Hold down the CTRL key on your keyboard and click the END key. This will bring you to the last page and last line of your document. Now delete all the empty lines by highlighting them from the left side of your Excel sheet. (Click into the one of the line numbers on the left of your worksheet, hold down your left mouse and pull upward; each line will highlight as you pull) Finally hit the DELETE key and SAVE your document.

If you would like more help with this and other features please visit this page.

Posted in: Microsoft Excel