Home

Cell content partially disappears on entering the cell.

%3CLINGO-SUB%20id%3D%22lingo-sub-564717%22%20slang%3D%22en-US%22%3ECell%20content%20partially%20disappears%20on%20entering%20the%20cell.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-564717%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20experimenting%20a%20very%20strange%20and%20highly%20inconvenient%20issue%20with%20Excel%202010%3A%3C%2FP%3E%3CP%3Eupon%20a%20double%20click%20on%20a%20cell%20in%20a%20spreadsheet%20most%20of%20its%20content%20disappears%20from%20both%20cell%20and%20fx%20view.%3C%2FP%3E%3CP%3EOn%20entering%20the%20cell%20either%20from%20navigating%20with%20a%20keyboard%20or%20clicking%20with%20a%20mouse%2C%20the%20beginning%20of%20the%20content%20is%20not%20shown%20in%20the%20%3CSTRONG%3E%3CEM%3Efx%3C%2FEM%3E%3C%2FSTRONG%3E%20line%20(while%20still%20seen%20in%20the%20cell%20itself).%3C%2FP%3E%3CP%3EI%20have%20created%20a%20brand%20new%20spreadsheet%20and%20the%20problem%20is%20seen%20from%20the%20get-go.%3C%2FP%3E%3CP%3EHere%20is%20the%20original%20table%2C%20no%20cells%20are%20selected%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20368px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F113196i7987B4AE3ABEF649%2Fimage-dimensions%2F368x216%3Fv%3D1.0%22%20width%3D%22368%22%20height%3D%22216%22%20alt%3D%22original.JPG%22%20title%3D%22original.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThen%20I%20click%20on%20B2%2C%20part%20of%20the%20text%20becomes%20invisible%20in%20both%20cell%20and%20the%20fx%20line%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20384px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F113197i15667A199B9BA0C6%2Fimage-dimensions%2F384x226%3Fv%3D1.0%22%20width%3D%22384%22%20height%3D%22226%22%20alt%3D%22cell_B3_selected.JPG%22%20title%3D%22cell_B3_selected.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ESame%20problem%20is%20seen%20whatever%20cell%20I%20navigate%20to%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20404px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F113198iB4BEFE09F1B09AE3%2Fimage-dimensions%2F404x237%3Fv%3D1.0%22%20width%3D%22404%22%20height%3D%22237%22%20alt%3D%22cell_C2_selected.JPG%22%20title%3D%22cell_C2_selected.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Eor%20double-click%20on%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F113199i6F849C2E194F8BBF%2Fimage-dimensions%2F400x233%3Fv%3D1.0%22%20width%3D%22400%22%20height%3D%22233%22%20alt%3D%22cell_A1_selected.JPG%22%20title%3D%22cell_A1_selected.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20simply%20means%20I%20cannot%20edit%20first%20part%20of%20the%20text%2C%20as%20there%20is%20no%20content%20shown.%3C%2FP%3E%3CP%3EHow%20can%20this%20be%20fixed%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3EElena.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-564717%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-564760%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20content%20partially%20disappears%20on%20entering%20the%20cell.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-564760%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F341634%22%20target%3D%22_blank%22%3E%40ElenaSm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHi%20Elena%20-%20may%20you%20share%20your%20sample%20workbook%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-564782%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20content%20partially%20disappears%20on%20entering%20the%20cell.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-564782%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bhere%20we%20go.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-564783%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20content%20partially%20disappears%20on%20entering%20the%20cell.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-564783%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F341634%22%20target%3D%22_blank%22%3E%40ElenaSm%3C%2FA%3E%26nbsp%3Bthank%20you%2C%20will%20check%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-564771%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20content%20partially%20disappears%20on%20entering%20the%20cell.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-564771%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bsure%2C%26nbsp%3BI%20just%20discarded%20it%2C%20but%20I'll%20create%20a%20new%20one%20in%20a%20sec.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-564934%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20content%20partially%20disappears%20on%20entering%20the%20cell.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-564934%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F341634%22%20target%3D%22_blank%22%3E%40ElenaSm%3C%2FA%3E%26nbsp%3B%2C%20my%20guess%20was%20wrong%2C%20I'm%20not%20able%20to%20reproduce.%20Try%20to%20do%20the%20same%20in%20safe%20mode%20(Win%2BR%20and%20excel%20%2Fsafe).%20If%20the%20same%20it's%20worth%20to%20repair%20the%20office.%3C%2FP%3E%3C%2FLINGO-BODY%3E
ElenaSm
New Contributor

Good day,

 

I am experimenting a very strange and highly inconvenient issue with Excel 2010:

upon a double click on a cell in a spreadsheet most of its content disappears from both cell and fx view.

On entering the cell either from navigating with a keyboard or clicking with a mouse, the beginning of the content is not shown in the fx line (while still seen in the cell itself).

I have created a brand new spreadsheet and the problem is seen from the get-go.

Here is the original table, no cells are selected:

original.JPG

Then I click on B2, part of the text becomes invisible in both cell and the fx line:

cell_B3_selected.JPG

Same problem is seen whatever cell I navigate to
cell_C2_selected.JPG

or double-click on:

cell_A1_selected.JPG

This simply means I cannot edit first part of the text, as there is no content shown.

How can this be fixed??

 

Thank you,

Elena.

5 Replies

@ElenaSm 

 

Hi Elena - may you share your sample workbook?

@Sergei Baklan sure, I just discarded it, but I'll create a new one in a sec.

 

@ElenaSm thank you, will check

@ElenaSm , my guess was wrong, I'm not able to reproduce. Try to do the same in safe mode (Win+R and excel /safe). If the same it's worth to repair the office.

Related Conversations