Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
have excel go to defined cells when pressing enter
How can I have excel go to defined cells when pressing ENTER after entering
info in a cell (from cell Aa1 input info press Enter and go to H16 to input info in that cell press ENTER go to A45 and so on) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
have excel go to defined cells when pressing enter
You could use Format | Cells | [Protection] and Lock all cells then go back
and choose the ones you want to get to in this manner and then Unlock them. Protect the worksheet (Tools | Protection | Protect Sheet) with the option to permit selecting locked cells turned off. As they use [Tab] or [Enter] they will move from one unlocked cell to the next without stopping in between. "rrg" wrote: How can I have excel go to defined cells when pressing ENTER after entering info in a cell (from cell Aa1 input info press Enter and go to H16 to input info in that cell press ENTER go to A45 and so on) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
have excel go to defined cells when pressing enter
Thank You
That could work I was looking for a way to jump to cells not in any order just defined Start @ A3 then jump to A15 back to B6 maybe to H7 to A4 to B17 to A5 so on "JLatham" wrote: You could use Format | Cells | [Protection] and Lock all cells then go back and choose the ones you want to get to in this manner and then Unlock them. Protect the worksheet (Tools | Protection | Protect Sheet) with the option to permit selecting locked cells turned off. As they use [Tab] or [Enter] they will move from one unlocked cell to the next without stopping in between. "rrg" wrote: How can I have excel go to defined cells when pressing ENTER after entering info in a cell (from cell Aa1 input info press Enter and go to H16 to input info in that cell press ENTER go to A45 and so on) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
have excel go to defined cells when pressing enter
You can use a named range to "jump" through in any order you design.
Select SECOND cell then CTRL + click on each succeeding cell in sequence, ending up with the cell you want to start at. InsertName Define........give your range a name and OK. In namebox select the name and the cells will be highlighted in the order you want. Just type and hit ENTER key to go to next cell. Note: there are limitations on the number of cells in a range. See Bob Phillips' site for more help on this. http://www.xldynamic.com/source/xld.xlFAQ0008.html There is a VBA method if you choose. Post back for that. Gord Dibben MS Excel MVP On Wed, 14 Mar 2007 06:36:30 -0700, rrg wrote: Thank You That could work I was looking for a way to jump to cells not in any order just defined Start @ A3 then jump to A15 back to B6 maybe to H7 to A4 to B17 to A5 so on "JLatham" wrote: You could use Format | Cells | [Protection] and Lock all cells then go back and choose the ones you want to get to in this manner and then Unlock them. Protect the worksheet (Tools | Protection | Protect Sheet) with the option to permit selecting locked cells turned off. As they use [Tab] or [Enter] they will move from one unlocked cell to the next without stopping in between. "rrg" wrote: How can I have excel go to defined cells when pressing ENTER after entering info in a cell (from cell Aa1 input info press Enter and go to H16 to input info in that cell press ENTER go to A45 and so on) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
have excel go to defined cells when pressing enter
thats it!!!!!!!
Thank you "Gord Dibben" wrote: You can use a named range to "jump" through in any order you design. Select SECOND cell then CTRL + click on each succeeding cell in sequence, ending up with the cell you want to start at. InsertName Define........give your range a name and OK. In namebox select the name and the cells will be highlighted in the order you want. Just type and hit ENTER key to go to next cell. Note: there are limitations on the number of cells in a range. See Bob Phillips' site for more help on this. http://www.xldynamic.com/source/xld.xlFAQ0008.html There is a VBA method if you choose. Post back for that. Gord Dibben MS Excel MVP On Wed, 14 Mar 2007 06:36:30 -0700, rrg wrote: Thank You That could work I was looking for a way to jump to cells not in any order just defined Start @ A3 then jump to A15 back to B6 maybe to H7 to A4 to B17 to A5 so on "JLatham" wrote: You could use Format | Cells | [Protection] and Lock all cells then go back and choose the ones you want to get to in this manner and then Unlock them. Protect the worksheet (Tools | Protection | Protect Sheet) with the option to permit selecting locked cells turned off. As they use [Tab] or [Enter] they will move from one unlocked cell to the next without stopping in between. "rrg" wrote: How can I have excel go to defined cells when pressing ENTER after entering info in a cell (from cell Aa1 input info press Enter and go to H16 to input info in that cell press ENTER go to A45 and so on) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
WYA Converts to WAY after pressing enter ket | Excel Discussion (Misc queries) | |||
Pressing Enter Key | Setting up and Configuration of Excel | |||
Pressing Enter/Tab to go next question in a form | Setting up and Configuration of Excel | |||
How do I follow a hyperlink by just pressing "enter"? | Excel Discussion (Misc queries) | |||
select the first cell in the next row down after pressing enter o. | Setting up and Configuration of Excel |