can you help me

J

johny

In excel, let us assume that we are working in excel sheet

i am working in p21 cell ok, if we press home button it has to come position
at a21 but in my excel sheets by default it is moving to a1

Can any one help me
 
D

Dave Peterson

Excel will react differently depending on a switch you can change.

In xl2003 menus:
Tools|Options|Transition Tab
Check or uncheck "Transition navigation keys"

Personally, I'd uncheck all those old lotus 123 settings.

(Uncheck it and the Home key will go to column A of the row with the
activecell.)
 
Top