Move Cursor to A1

[Silver]

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?

[garfield-n-odie]

Ctrl+Home

Silver wrote:

> 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?

[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.

>-----Original Message-----
>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?
>.
>

[Don Guillett]

assign a shortcut to this

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

--
Don Guillett
SalesAid Software
[email protected]
"Silver" <[email protected]> wrote in message
news:[email protected]...
> 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?

[wesatbu]

It's so cool during a brain freeze to come here and find a 10 yr old solution that still works.

[miltonp]

Ctrl+Home will take you to A1, but if you have frozen panes you could use Ctrl+G which will open the Go To box and then type A1 in the Reference field and hit Enter.

[Catherine111]

Can also try to use ctrl + home...brings you to A1

[cbenn87]

technically that just moves you to the top of the main unfrozen panes. If you have frozen, say, the first 5 columns and top 2 rows, then it'll take you to F3

Columns A:E are "frozen", as are rows 1:2, so the first unfrozen cell is thus F3 rather than A1.

This might be a schmidge pedantic, but I thought it was worth pointing out.