[RESOLVED] Scrolling through unlocked cells in Excel

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.

tools> opions> edit> move selection after enter

pete

Quote:

---

Originally Posted by westconn1

tools> opions> edit> move selection after enter

pete

---

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