ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   can you help me (https://www.excelbanter.com/excel-discussion-misc-queries/183012-can-you-help-me.html)

johny

can you help me
 
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

muddan madhu

can you help me
 
i think ctrl key is pressed while u press home key...



On Apr 9, 11:43*am, 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



Leon

can you 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


Dave Peterson

can you 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


All times are GMT +1. The time now is 06:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com