Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() When entering an amount in lets say cell A5 I want to goto B15 after I hit enter. Is this possible -- Beantown20 |
#2
![]() |
|||
|
|||
![]()
Hi,
Select the cells in the order in which you want to navigate and then go thje name box on the top left corner and give it some name. Next when you want to navigate through those specific cells type the name inthe name box and those cells get highlighted. You can then move to those cells by hitting enter ot tab Regards, Ashish Mathur "Beantown20" wrote: When entering an amount in lets say cell A5 I want to goto B15 after I hit enter. Is this possible -- Beantown20 |
#3
![]() |
|||
|
|||
![]() ok stupid question. How do i go about selecting the cells. Do I put comas between the cells which does highlight them (=+B4,B6,B8,B10) but I get a value error in that cell. Sounds very simple when you explain it so I am probibly making this harder than it is. Any help would be greatly appreciated. Bean Ashish Mathur Wrote: Hi, Select the cells in the order in which you want to navigate and then go thje name box on the top left corner and give it some name. Next when you want to navigate through those specific cells type the name inthe name box and those cells get highlighted. You can then move to those cells by hitting enter ot tab Regards, Ashish Mathur "Beantown20" wrote: When entering an amount in lets say cell A5 I want to goto B15 after I hit enter. Is this possible -- Beantown20 -- Beantown20 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Another rounding issue | Excel Worksheet Functions | |||
Sorting Issue (Mixde Fields) | Excel Discussion (Misc queries) | |||
An issue when sorting in excel PivotTable | Excel Discussion (Misc queries) | |||
New Excel Comment Box Issue | Excel Discussion (Misc queries) | |||
Shared File & Freeze panes issue | Excel Discussion (Misc queries) |