View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default How do I stop the cell from becoming a drop down box when editing

Two things:

1. make sure the cell has no Data Validation
3. make sure the cell contains no ALT-ENTERs
--
Gary''s Student
gsnu200708


"Andy R" wrote:

I was using excel yesterday and somehow changed a setting so that when I
double click in a cell to edit it, it now looks like it drops down over the
cell below. The text ends up in the correct box, but I would like to see if
anyone knows how to make this stop. I want it to go back to the default.
--
Thanks,
Andy R