Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
F2 edit cells - new info disappears when I hit enter
Excel 2002 : when I add new data to an existing cell the original lines of
data are okay, but the new data typed in only shows up when I hit F2 and disappears when I hit enter - like an invisible page break. thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
F2 edit cells - new info disappears when I hit enter
"Will123" wrote: Excel 2002 : when I add new data to an existing cell the original lines of data are okay, but the new data typed in only shows up when I hit F2 and disappears when I hit enter - like an invisible page break. thanks Excel will normally not display any cell content that overlaps another non-empty cell. What you have done is exceeded the width of the displayable area for the cell you are looking at. You can make the cell wider, make the font narrower, or clear the content from the adjacent cell where you would expect to see the original cell's content. Pressing F2 opens a cell for editing and that overrides the restrictions on the normal display properties. B+ HALinNY |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I enter info in Excel and have it display as an '*'? | Excel Discussion (Misc queries) | |||
How to use macro to edit data in Excel cells | Excel Discussion (Misc queries) | |||
edit comments in locked cells | Excel Worksheet Functions | |||
In Excel 2000, Cannot edit cells in worksheet created in 2003? | Excel Discussion (Misc queries) | |||
paste info into merged cells | Setting up and Configuration of Excel |