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

i think ctrl key is pressed while u press home key...



On Apr 9, 11:43*am, johny <jo...@discussions.microsoft.com> wrote:
> 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

Are you sure that you have not pressed the Ctrl button before pressing Home?

"johny" wrote:

> 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

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

johny wrote:
>
> 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

--

Dave Peterson