| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hitting Enter to Move Cursor to the Next Entry Cell
I want to be able to limit the where the cursor will go next. Is there a way
to press enter and move the cursor, instead of one cell over or under but, to another location within the sheet without having to actually click on that cell? For Example cursor is in cell C3, then when I hit enter it moves to cell F15. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hitting Enter to Move Cursor to the Next Entry Cell
Hi Cisnerax
Protect the sheet, and only allow selection of unprotected cells. If only cells C3 and F15 is unprotected, hitting Enter will move the cursor between these two cells. Obviously, if more cells are unprotected, the cursor will move between those cells as well. hth "Cisnerax" wrote: I want to be able to limit the where the cursor will go next. Is there a way to press enter and move the cursor, instead of one cell over or under but, to another location within the sheet without having to actually click on that cell? For Example cursor is in cell C3, then when I hit enter it moves to cell F15. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hitting Enter to Move Cursor to the Next Entry Cell
Thank you sooooo much that made all the difference
"Kassie" wrote: Hi Cisnerax Protect the sheet, and only allow selection of unprotected cells. If only cells C3 and F15 is unprotected, hitting Enter will move the cursor between these two cells. Obviously, if more cells are unprotected, the cursor will move between those cells as well. hth "Cisnerax" wrote: I want to be able to limit the where the cursor will go next. Is there a way to press enter and move the cursor, instead of one cell over or under but, to another location within the sheet without having to actually click on that cell? For Example cursor is in cell C3, then when I hit enter it moves to cell F15. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hitting Enter to Move Cursor to the Next Entry Cell
:-)
"Cisnerax" wrote: Thank you sooooo much that made all the difference "Kassie" wrote: Hi Cisnerax Protect the sheet, and only allow selection of unprotected cells. If only cells C3 and F15 is unprotected, hitting Enter will move the cursor between these two cells. Obviously, if more cells are unprotected, the cursor will move between those cells as well. hth "Cisnerax" wrote: I want to be able to limit the where the cursor will go next. Is there a way to press enter and move the cursor, instead of one cell over or under but, to another location within the sheet without having to actually click on that cell? For Example cursor is in cell C3, then when I hit enter it moves to cell F15. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop next cell being selected on Enter | Excel Discussion (Misc queries) | |||
| how do I format a cell reference to move as source changes | Excel Worksheet Functions | |||
| How can I create a new line in a cell in Excel by hitting enter? | Excel Discussion (Misc queries) | |||
| must press enter 2x to move cell focus | Excel Discussion (Misc queries) | |||
| how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
Linear Mode
