PDA

Click to See Complete Forum and Search --> : [RESOLVED] Scrolling through unlocked cells in Excel


krtxmrtz
Jun 25th, 2006, 03:38 AM
In the attached image the sheet is protected so that only the unlocked blue cells can be selected. If I have selected cell B2 and then keep typing "right arrow" then I will be scrolling through the entire allowed range, i.e. B2 -> C2 -> B3 -> B4 -> C4 -> B5 -> B2...
Is it possible somehow to do the same by hitting the Enter key? This scrolls only through the cells in the B column.

westconn1
Jun 25th, 2006, 04:11 AM
tools> opions> edit> move selection after enter

pete

krtxmrtz
Jun 25th, 2006, 07:49 AM
tools> opions> edit> move selection after enter

pete
Thanks, I'm learning one little trick every day.