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
 

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

Back
Top