Ctrl-Home should take to to the top left cell (usually A1).

But you could also define a name that refers to A1:

Insert|Name|Define
Names in Workbook: Home
(that was the name I used)
Refers to:
=indirect("a1")

Then no matter where I was, I could hit F5, type Home and hit enter--and off to
A1 of the activesheet.





cbh35711 wrote:

I've got a 50 sheet excel document and i want to create names to get me
to A1 on every page, so I don't have to scroll left and right all the
time.
So, here's my problem.
I would like to increase the number of names shown when i click the
drop down box. Right now it shows 7, in Office 2003. I would love to
increase that to show 50, or else I’m not really getting the
functionality I’m looking for.
I think this will take some kind of registry tweak.
Does anyone know how/where I can?

Thanks in advance,

Chris

--
cbh35711
------------------------------------------------------------------------
cbh35711's Profile: http://www.excelforum.com/member.php...o&userid=30276
View this thread: http://www.excelforum.com/showthread...hreadid=501801

--

Dave Peterson