| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I HAVE SAY INFO ACROSS 10 COLUMNS. HOW TO MAKE THE COL-A CELL ACTIVE WHEN U HIT 'ENTER'
DEAR ALL
For example - data entry is being made and say info is across 10 columns. How to make the cursor/cell active from COL_J to the next row at COL_A when 'ENTER' is pressed. I can make it go only to right or down but not down and 10 cells to the left. I have used macro using ctrl-left arrow etc. But i am sure some better way must be there. Pls adv |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell References | Excel Discussion (Misc queries) | |||
| How do I make it so that the active cell follows the cursor keys? | Excel Discussion (Misc queries) | |||
| How do I make the border of an active cell in Excel darker? | Excel Discussion (Misc queries) | |||
| How do I make someone enter information in a cell | Excel Discussion (Misc queries) | |||
| When sorting info in columns, can I make it insert blank line bet. | Excel Worksheet Functions | |||
Threaded Mode
