How do I stop the cell from becoming a drop down box when editing

G

Guest

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.
 
G

Guest

Two things:

1. make sure the cell has no Data Validation
3. make sure the cell contains no ALT-ENTERs
 
G

Guest

Garys Student,

Thanks for the info. Neither of these is happening. The problem happens in
any cell I try to edit. I think I changed some kind of default setting.
 
G

Gord Dibben

Andy

Sounds like you have Wrap Text enabled and the text in the cell is wrapping
because of its width.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

remove drop down box from a cell 1
How to delete a drop down box in Excel 2007 1
Drop down / validation / lookup into the same cell 2
in excel when i hit return, the cursor does not drop down 1 cell 2
drop down box 1
Copying a Drop Down Menu 2
Drop Down Box Selection 3
Selecting multiple values from a drop down list box 5

Top