View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer bpeltzer is offline
external usenet poster
 
Posts: 171
Default how do I keep cell (after I put data in it) from going down automa

From the menu bar, Tools / Options, select the Edit tab and deselect 'Move
selection after Enter' (note you can also choose to move in another
direction).

"bojoco" wrote:

I want to put data in both down and sideways. By default after I put data in
a cell, the next cell DOWN is always highlighted. How can I get it to remain
where it is, rather than automatically go down.