In Excel when I want shortcut to go to last entry

  • Thread starter Thread starter Barry Evans
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing position of last used cell 4
Data Entry Cells 2
Excel Cannot delete empty cells/rows 4
Office 2007 "go to special" shortcut function 5
Go to last non-empty cell in column 8
Different "end" on different sheets 2
last entry in a range? 2
Trying to run excel vba code when cell value changes from empty to entered value. 1

Back
Top