ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Tab key movement & Formulas (https://www.excelbanter.com/excel-discussion-misc-queries/185840-tab-key-movement-formulas.html)

Tim

Tab key movement & Formulas
 
When ever I push my tab key, the cursor moves to the right by one page
instead of one cell. Does anyone know how to correct this problem?

In addition, whenever I enter a formula in a cell and try to click on
another cell as part of that formula, it will automatically unhide or ungroup
all the rows/columns in the spreadsheet.

Tom Hutchins

Tab key movement & Formulas
 
To correct the Tab problem: Tools Options. On the Transition tab, uncheck
'Transition navigation keys'.

Hope this helps,

Hutch

"Tim" wrote:

When ever I push my tab key, the cursor moves to the right by one page
instead of one cell. Does anyone know how to correct this problem?

In addition, whenever I enter a formula in a cell and try to click on
another cell as part of that formula, it will automatically unhide or ungroup
all the rows/columns in the spreadsheet.



All times are GMT +1. The time now is 03:42 PM.

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