Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Please can you advise the official channel as we would be delighted to use
that and send a sample worksheet that illustrates the issue. "Jim Rech" wrote: I don't care for this characteristic either but fyi it is not a bug in MS parlance. A bug is something that behaves differently than the design. This does not. Btw, this newsgroup is not an official channel to Microsoft so it's not an effective way to request a patch. -- Jim "Synectica" wrote in message ... In the Excel applications we build for others it is useful to have the cell selection remain on the cell after the data in it is modified. This is done by unchecking "Move Selection after Enter" on the "Edit" tab of the "Options" dialogue. However, when protecting the worksheet to allow selection of unlocked cells only, the cell selection then ignores the Edit tab setting and moves in the default direction after Enter. If worksheet protection is modified to also allow selection of locked cells, then the cell selection will obey the Edit setting and not move after Enter. This is surely a bug in Excel... It is very frustrating as either we must allow the selection move to other unlocked cells after Enter, or permit selection of locked cells - neither of which is really satisfactory. Can Microsoft please fix this and send us a patch? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
How can I create a new line in a cell in Excel by hitting enter? | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
enter data in cell then run macro automatically | Excel Discussion (Misc queries) | |||
Can you enter a formula in a cell that auto-inputs calculations a. | Excel Worksheet Functions |