How to get to last column in a worksheet in XP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I just want to jump to the last occupied column in a row in a worksheet. It
used to be that you hit "end-enter" to go to the last column, but that
doesn't seem to work anymore. You can hit "home" and go to the FIRST column
in the row, but how the heck do you get to the LAST column in a row? I tried
to set up a "Go To" kind of bookmark but that didn't work well. Is the only
way to get to the last column to tab-tab-tab-tab-tab over? It didn't used to
be that way!
 
End + ENTER takes me to the last used column in the same row.

Excel 97, 2002 and 2003.

CTRL + End returns last column, last row in used range.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Ribbon Display Options askew?? 6
hit enter in any column and go to next row in first column 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Countif wrong in last row or two 3
find last row in column 1
VBA - retrieve data on last create named range from previous inserted named range 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel VBA 1

Back
Top