Home |
Search |
Today's Posts |
#1
|
|||
|
|||
move between unlocked cells on protected sheet
The wording on my first question may be confusing...using the TAB key to move
between the unlocked cells on a protected, worksheet, for some reason, when I get to the end of some rows, the cursor returns to the home cell on that row, not to the next row down. Is this because some cells on these rows are merged...if so, how can I keep those cells merged (to have ample space for user to input their data) and still TAB left-to-right-then-down to unprotected cells?? |
#2
|
|||
|
|||
Merged cells cause all kinds of problems. You've found another one.
ayanna wrote: The wording on my first question may be confusing...using the TAB key to move between the unlocked cells on a protected, worksheet, for some reason, when I get to the end of some rows, the cursor returns to the home cell on that row, not to the next row down. Is this because some cells on these rows are merged...if so, how can I keep those cells merged (to have ample space for user to input their data) and still TAB left-to-right-then-down to unprotected cells?? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem trying to move between cells on a protected worksheet. | Excel Discussion (Misc queries) | |||
In a protected sheet how do I get the cursor to only move to unlo. | Excel Discussion (Misc queries) | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Unlock a spinner or scrollbar on a protected sheet | Excel Worksheet Functions | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) |