ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   move between unlocked cells on protected sheet (https://www.excelbanter.com/excel-discussion-misc-queries/23788-move-between-unlocked-cells-protected-sheet.html)

ayanna

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??

Dave Peterson

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


All times are GMT +1. The time now is 08:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com