ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel auto learning (https://www.excelbanter.com/excel-discussion-misc-queries/119270-excel-auto-learning.html)

KGMBA

Excel auto learning
 
Is it my imagination, or when entering data in colums does Excel "auto-learn"
what you are going to do next? It was nice when entering data into 3 colums
that after the final colum, I would hit enter and the cursor would
automatically go to the next row/colum that I would start entering the data
in. All the sudden, Excel does not do this anymore...did I somehow undo
something or do I have to set this function up?

Jim Thomlinson

Excel auto learning
 
When entering data the Tab key will move you one cell to the right. If you
hit the tablkey 3 times then it will move you 3 cells to the right. Here is
the neat thing. If you now it enter it will drop down a row and move you back
the 3 or for columns to the left (however many tabs you hit)... Perhaps that
is what you are thinking of...
--
HTH...

Jim Thomlinson


"KGMBA" wrote:

Is it my imagination, or when entering data in colums does Excel "auto-learn"
what you are going to do next? It was nice when entering data into 3 colums
that after the final colum, I would hit enter and the cursor would
automatically go to the next row/colum that I would start entering the data
in. All the sudden, Excel does not do this anymore...did I somehow undo
something or do I have to set this function up?



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

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