Resetting last used cell

Do you ever get reams of paper printing at the end of your worksheet?  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.

So now when you print, it will print only the data section of your file and no blank rows.

Leave a Reply

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

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 Youtube