Ever wondered why your Excel Spreadsheet has so much empty space at the end and to the right? Or why is your workbook so big on disk?
Press Ctrl-End in on that spreadsheet in Excel and you will be taken to the very end of the sheet as Excel sees it. This can often be some random spot about 200 rows down from where your report ends. In the newer versions of Excel, this can be a big problem because you might be at row 1,000,000. This is bad, (perhaps even slightly evil!). Why? It can be a hassle when printing or saving as a PDF because the data you want to print is very small on the page, the file size can be massive and performance of Excel and your PC will be slow.
So how do you fix this issue?
And that's it! Enjoy your smaller and faster Excel workbooks once again.