View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John James
 
Posts: n/a
Default roll data up from cell


I'm reading this question to be about cursor movement, and that when you
arrow downwards from A20 you arrive at B1.

This can be achieved by unlocking cells A1:B20 (or your desired block)
and then protecting the worksheet, ensuring the "select locked cells"
box is not checked


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