Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop the cell from becoming a drop down box when editing
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop the cell from becoming a drop down box when edit
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. -- Thanks, Andy R "Gary''s Student" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop the cell from becoming a drop down box when editing
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 On Fri, 2 Mar 2007 07:38:20 -0800, 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Editing in a cell | New Users to Excel | |||
How do you stop excel from editing your cell? | New Users to Excel | |||
how do you stop editing the text in a created button | Excel Discussion (Misc queries) | |||
Cell Editing | New Users to Excel | |||
Formulas stop calculating at random times when editing a few spreadsheets. | Excel Discussion (Misc queries) |