Movement of the cursor

  • Thread starter Thread starter tran1728
  • Start date Start date
T

tran1728

Dear All, i need your help pls,

This is really basic but I could not find a thread. I want to control the
movement of the cursor. move direct at A6 after the last row of column A.

Column A
A1 Item
A2 9800
A3 9800
A4 9800
A5 9800

Thanks so muck
 
I'm not sure exactly when you want to move down to the last row. After
typing an entry into a cell in column A?
If that's the case, look at:
Tools --> Options --> [Edit] tab and then check the box next to:
"Move selection after Enter" and then pick "Down" from the direction list.

In Excel 2007/2010 this is in the Advanced group of the options.

If this doesn't solve your problem, please explain a little more about
exactly when you want to go to the bottom of column A.
 
Could you please elaborate..That depends on where the cursor is right now..

If in cell A1; press Ctrl+ DownArrow

If in cell A6; press Ctrl+ UpArrow
 
You are asking for a VBA solution. Check your other post

Cells(Rows.Count, "A").End(xlUp).offset(1).select
 
Back
Top