View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
John James
 
Posts: n/a
Default HOw do I use enter to return to the first cell in the next row?


If you have unlocked only your target cells and protect the worksheet
(with "select unlocked cells" only), then the cursors moves the way you
want it to.

There is also a way of achieving a similar result through setting up a
particular type of range name which selects cells in a user-specified
order, but this is more fiddly and less robust.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=529393