Move Cursor to A1

G

Guest

I wish to use shortcut keys to move cursor to A1, especially when setting
print area.
When I use "ALT+Home" the cursor moves to the first cell of the row. How do
I opt for the cursor to go to A1?
 
A

akk

Ctrl+Home would take you to cell A1 except when you have
the freeze panes on in which case it would take you to the
first row first column cell after the freeze pane.
 
D

Don Guillett

assign a shortcut to this

Sub gotoa1()
Application.Goto Range("a1")
End Sub
 

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

Oversensitive touchpad on modern laptops 0
show row number in one fixed cell in reference to your cursor pos. 5
how do I get the cursor to move to cell A1 when I press home key 2
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
The Relative Macro 6
Automatically go to another cell 1
Several questions about move cursor 1
Up,Down,Left,Right stopped working 2

Top