Move Cursor to A1

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?

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?

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

assign a shortcut to this

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

--
Don Guillett
SalesAid Software
donaldb@281.com
"Silver" <Silver@discussions.microsoft.com> wrote in message
news:ECAD67BB-F6F1-4AC9-A052-D45F2B071833@microsoft.com...
> 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?

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

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

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.