| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
entering data in a row and then tabbing to the next row
I am using Excel 2003. I would like to enter my data from A-L and then press
tab and be in the next row below to start entering data again. I have my own company and am trying to enter customers contact info. It is inconvenient for me to alway use my mouse to go back to the next row and I know I have set this up before, but can not remember how I did it. Please help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
entering data in a row and then tabbing to the next row
Unlock the cells you want to use, iowselect cols A:L, click on Format, Cells,
Protection, and untick Locked. Protect your worksheet, and untick the option to select locked cells. If you want to rather use <ENTER to move to the next cell, then click on Tools, Options, select the Edit tab, and change Move selection after enter to Right. Once you press <ENTER, or then <TAB in Col L, you will move to col A in the next row. -- HTH Kassie Replace xxx with hotmail "Paradisegems" wrote: I am using Excel 2003. I would like to enter my data from A-L and then press tab and be in the next row below to start entering data again. I have my own company and am trying to enter customers contact info. It is inconvenient for me to alway use my mouse to go back to the next row and I know I have set this up before, but can not remember how I did it. Please help. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
entering data in a row and then tabbing to the next row
Another way..which I use it for setting temporary navigation..
--Suppose you are in Row 10 --Select range A11:L20 (active cell would be A11) --Start entering data and once at L11 it would return to next row ColA If this post helps click Yes --------------- Jacob Skaria "Paradisegems" wrote: I am using Excel 2003. I would like to enter my data from A-L and then press tab and be in the next row below to start entering data again. I have my own company and am trying to enter customers contact info. It is inconvenient for me to alway use my mouse to go back to the next row and I know I have set this up before, but can not remember how I did it. Please help. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
entering data in a row and then tabbing to the next row
Tab your way across then when leaving L1 hit Enter key to drop to A2
Gord Dibben MS Excel MVP On Wed, 2 Sep 2009 18:17:01 -0700, Paradisegems wrote: I am using Excel 2003. I would like to enter my data from A-L and then press tab and be in the next row below to start entering data again. I have my own company and am trying to enter customers contact info. It is inconvenient for me to alway use my mouse to go back to the next row and I know I have set this up before, but can not remember how I did it. Please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| transfering data in another column entering more sorted data | Excel Worksheet Functions | |||
| Entering data | Excel Discussion (Misc queries) | |||
| Entering Data | Excel Discussion (Misc queries) | |||
| Entering Data: is there a way to do this? | Excel Discussion (Misc queries) | |||
| Entering data on template and then data going to a spreadsheet. | Excel Discussion (Misc queries) | |||
Linear Mode
