ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   F2 error: New data disappears when hit enter (https://www.excelbanter.com/excel-worksheet-functions/121170-f2-error-new-data-disappears-when-hit-enter.html)

Will123

F2 error: New data disappears when hit enter
 
Occasionally when I add new info to a cell using F2 the extra lines of type
show up when I hit F2 key then disappear when I hit enter like there is an
invisible page break not allowing extra data beyond it, but can see it when
hit F2.- puzzling? Excel 2002.

John Bundy

F2 error: New data disappears when hit enter
 
Sounds like you have something in the cell next to it, when the adjacent cell
has data the first cell is cut off, F2 shows the data as typed, then is
reformated as to not write over the other data. Expanding the column width
should solve your problem

"Will123" wrote:

Occasionally when I add new info to a cell using F2 the extra lines of type
show up when I hit F2 key then disappear when I hit enter like there is an
invisible page break not allowing extra data beyond it, but can see it when
hit F2.- puzzling? Excel 2002.



All times are GMT +1. The time now is 11:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com