In Excel when I want shortcut to go to last entry

B

Barry Evans

mUsed to be if I hit ctrl end, it would go to the last cell I entered
something in, now goes to the very end of the document where I have entered
nothing, how do I easily get to last cell I entered something in
thanks
 
G

Gord Dibben

Excel has a habit of overestimating the used range after data has been
cleared from rows and columns.

Go to end of actual data.

Then SHIFT + End + downarrow to select all.

Edit>Delete>Entire Rows.

Do same for columns to the right of your data.

NOW>>>>>>>Save the workbook to see changes.


Gord Dibben MS Excel MVP

On Thu, 11 Sep 2008 17:14:01 -0700, Barry Evans <Barry
 
Top