Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / May 2008

Tip: Looking for answers? Try searching our database.

Navigation problems

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
P D Sterling - 14 May 2008 01:36 GMT
This is embarrassing to write, because I am the go-to guy in our office
for almost everything, and I have something I can't solve myself.

At home, I have Excel 2002, but at the office, I have Excel 2003. For
some unknown reason, I am having problems navigating my spreadsheets.

I am an old, old DOS veteran, who is used to keyboard shortcuts, and in
one, I am entering a series of values, with the cursor set to jump to
the right after each {enter}. At the last, I expect to hit {home} and go
to Column A.

Unfortunately, in this application, {home} seems to mean "go to upper
left hand corner of spreadsheet," and by trial and error, I find that
{control}{home} takes me to Column A. It is exactly the opposite at home
on Excel 2002.

Am I nuts? Is this a feature? Can it be changed? Any advice would be
gratefully appreciated.

regards,
P D Sterling
Jim Cone - 14 May 2008 01:44 GMT
P D Sterling,

Go to Tools | Options | Transition (tab)
Uncheck "Transition navigation keys"
Signature

Jim Cone
Portland, Oregon  USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"P D Sterling" <pdsterling@hotmail.com>
wrote in message
This is embarrassing to write, because I am the go-to guy in our office
for almost everything, and I have something I can't solve myself.
At home, I have Excel 2002, but at the office, I have Excel 2003. For
some unknown reason, I am having problems navigating my spreadsheets.
I am an old, old DOS veteran, who is used to keyboard shortcuts, and in
one, I am entering a series of values, with the cursor set to jump to
the right after each {enter}. At the last, I expect to hit {home} and go
to Column A.

Unfortunately, in this application, {home} seems to mean "go to upper
left hand corner of spreadsheet," and by trial and error, I find that
{control}{home} takes me to Column A. It is exactly the opposite at home
on Excel 2002.

Am I nuts? Is this a feature? Can it be changed? Any advice would be
gratefully appreciated.
regards,
P D Sterling

P D Sterling - 18 May 2008 22:08 GMT
>  
> P D Sterling,
>
> Go to Tools | Options | Transition (tab)
> Uncheck "Transition navigation keys"

wow - that seems so simple - note: I hate taking over computers from
other people - there always seems to be so much to re-customize. many
thanks for posting!

Signature

Regards,

P D Sterling
New York, Texas & Texas, New York

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.