Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Edgar,
Try this. Select all the cells that you need to enter info into starting with the SECOND cell and holding down CTRL as you select and select the FIRST cell last. With the cells still selected, click in the Name Box and name that selection of cell, (perhaps a name pertinent to the info that is to be entered) now hit Enter. To begin entering your data, click on the drop down arrow at the name box and select the name. All the cells will be highlighted and the number 1 cell will be the edit cell (white while all the rest are blue). Enter the 1st cell data and either hit Enter or Tab. Enter the next cell data and continue. To get out of the named range loop, hit Home or click anywhere on the sheet or select the next named range You may have several cells in the named range and be aware there seems to be a limit of about 20 to 30 for each named range. If that's a problem just add another named range and name it pertinent to the info to entered in that group of cells. HTH Regards, Howard "Edgar" wrote in message ... I want to use the TAB key everytime I want to jump to the next cell. Does anybody know how to do this? My form is a fill in form so I want to hit the TAB key to go to the next one. I have having to use my mouse to move to the next cell. Let me know, thank You. -- Computer Tech |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Jump to cell based on cell results created by calendar control too | Excel Discussion (Misc queries) | |||
need to jump down 4 cells, gather data, jump another 4 | Excel Programming | |||
HOW TO JUMP TO THE LAST CELL IN A ROW? | Excel Discussion (Misc queries) | |||
Cell jump | Excel Programming | |||
How do I double click a cell and jump to cell's referenced cell | Excel Discussion (Misc queries) |