ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I set home to A1 instead of K1? (https://www.excelbanter.com/excel-discussion-misc-queries/261795-how-do-i-set-home-a1-instead-k1.html)

Julie D[_2_]

How do I set home to A1 instead of K1?
 
If I press the home key on an existing spreadsheet, it goes to K1 instead of
to A1. Is there a way I can fix this? If not, do I have another possible
problem on that spreadsheet?

JLatham

How do I set home to A1 instead of K1?
 
I suspect that you have the window 'frozen' at column K. In pre-2007 Excel
menu:
Window -- Unfreeze Panes
Excel 2007: [View] tab, Window Group, in the Freeze Panes pull-down, choose
Unfreeze Panes


"Julie D" wrote:

If I press the home key on an existing spreadsheet, it goes to K1 instead of
to A1. Is there a way I can fix this? If not, do I have another possible
problem on that spreadsheet?


Gord Dibben

How do I set home to A1 instead of K1?
 
That is Excel default.

Use CTRL + Home

OR use Transition Navigation Keys under Lotus Transition settings.


Gord

On Sun, 18 Apr 2010 17:06:01 -0700, Julie D <Julie
wrote:

If I press the home key on an existing spreadsheet, it goes to K1 instead of
to A1. Is there a way I can fix this? If not, do I have another possible
problem on that spreadsheet?




All times are GMT +1. The time now is 05:33 PM.

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