Do you ever get reams of paper printing at the end of your worksheet?   I have been asked about this a few times, even if users have deleted their empty rows that they no longer use, when they hit CTRL+END to get to the bottom of their sheet there are still lots of blank cells.

It’s easy to rectify this:-

 

 

 

 

 

First, you need to delete all rows below your data (CTRL+SHIFT+DOWN ARROW) and all columns to the right of your data  (CTRL+SHIFT+RIGHT ARROW)  to ensure there is no formatting left behind.

If you hit CTRL+END at this point will still bring you to your previous last used cell.  So you need to save your workbook, and your last used cell will be exactly where it should be.

Pressing CTRL+END now will take you to the ‘real’ end of your data.  Give it a try and save some trees!!.

Want More Excel Tips?

Try the Excel Formula Crash Course.   If you use Excel to do data analysis, reporting, day to day tracking or project management then this is the right course for you. If you struggle with formulas or not sure which formula to use for any given occasion, then this is the perfect course for you. There are than 40 different formulas with 100s of examples in this course.

Here are the topics of the course

After completing the course myself, I can recommend it personally.  Just click on the link above or here to sign up or find out more.