When I enter a formula the cell above is automatically 'blocked' from view

%3CLINGO-SUB%20id%3D%22lingo-sub-1034105%22%20slang%3D%22en-US%22%3EWhen%20I%20enter%20a%20formula%20the%20cell%20above%20is%20automatically%20'blocked'%20from%20view%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1034105%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everybody!%3CBR%20%2F%3E%3CBR%20%2F%3ENew%20user%20here%20%3CLI-EMOJI%20id%3D%22lia_winking-face%22%20title%3D%22%3Awinking_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20I%20am%20studying%20excel%20and%20I%20noticed%20that%20on%20my%20version%20(the%20latest%20I%20believe%2C%20registered%20and%20downloaded%20a%20few%20days%20ago)%2C%20when%20I%20enter%20a%20formula%2C%20the%20cell%20above%20is%20immediately%20whitened%20out.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20can%20solve%20this%20for%20a%20specific%20cell%20if%20I%20go%20to%20cell%20formatting%20and%20choose%20'distributed'%20for%20vertical%20(even%20though%20I%20am%20not%20quite%20sure%20what%20the%20other%20options%20are%20etc%20at%20this%20point)%20%2C%20but%20the%20issue%20still%20remains%20by%20default.%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20there%20any%20way%20to%20resolve%20this%20permamently%20%3F%3CBR%20%2F%3EThank%20You%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1034105%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1035383%22%20slang%3D%22en-US%22%3ERe%3A%20When%20I%20enter%20a%20formula%20the%20cell%20above%20is%20automatically%20'blocked'%20from%20view%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1035383%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F467512%22%20target%3D%22_blank%22%3E%40Bunin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20sounds%20unusual%2C%20could%20you%20post%20a%20screenshot%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1492347%22%20slang%3D%22en-US%22%3ERe%3A%20When%20I%20enter%20a%20formula%20the%20cell%20above%20is%20automatically%20'blocked'%20from%20view%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1492347%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3BHere%20is%20a%20partial%20screenshot%20of%20what%20the%20original%20poster%20is%20talking%20about.%20I%20can't%20click%20on%20the%20field%20above%20the%20field%20where%20I%20have%20started%20the%20formula.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1492381%22%20slang%3D%22en-US%22%3ERe%3A%20When%20I%20enter%20a%20formula%20the%20cell%20above%20is%20automatically%20'blocked'%20from%20view%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1492381%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F711399%22%20target%3D%22_blank%22%3E%40WuLaw%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAfter%20%3CSTRONG%3E%3D%3C%2FSTRONG%3E%20you%20may%20use%20arrow%20keys%20to%20select%20navigate%20to%20the%20cell.%20If%20you%20prefer%20the%20mouse%20then%20increase%20the%20row%20height.%20Or%20on%20ribbon%20Home-%26gt%3BFormat-%26gt%3BAutofit%20row%20height%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1492400%22%20slang%3D%22en-US%22%3ERe%3A%20When%20I%20enter%20a%20formula%20the%20cell%20above%20is%20automatically%20'blocked'%20from%20view%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1492400%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F711399%22%20target%3D%22_blank%22%3E%40WuLaw%3C%2FA%3E%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F467512%22%20target%3D%22_blank%22%3E%40Bunin%3C%2FA%3E%26nbsp%3B%20i%20only%20get%20this%20behavior%20when%20the%20row%20height%20isn't%20tall%20enough%20for%20the%20text%20so%20Excel%20'creates%20more%20room'%20by%20temporarily%20hiding%20the%20cell(s)%20above%20it.%26nbsp%3B%20Does%20it%20still%20happen%20if%20you%20select%20all%20and%20do%20autoheight%20or%20double-click%20a%20horizontal%20line%20between%20row%20numbers%3F%3C%2FP%3E%3CP%3EEDIT%3A%20a)%20i%20see%20Sergei%20replied%20with%20very%20similar%20comment%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20b)%20you%20can%20also%20change%20to%20a%20smaller%20font%20size%20that%20will%20fit%20that%20row%20height.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1493428%22%20slang%3D%22en-US%22%3ERe%3A%20When%20I%20enter%20a%20formula%20the%20cell%20above%20is%20automatically%20'blocked'%20from%20view%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1493428%22%20slang%3D%22en-US%22%3E%3CP%3EAh%20yes%2C%20that%20is%20annoying.%26nbsp%3B%20Normally%20I%20end%20up%20just%20editing%20%2F%20writing%20the%20formula%20in%20the%20formula%20bar%20instead%20when%20that%20happens%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello everybody!

New user here

So I am studying excel and I noticed that on my version (the latest I believe, registered and downloaded a few days ago), when I enter a formula, the cell above is immediately whitened out.


I can solve this for a specific cell if I go to cell formatting and choose 'distributed' for vertical (even though I am not quite sure what the other options are etc at this point) , but the issue still remains by default.

Is there any way to resolve this permamently ?
Thank You

5 Replies
Highlighted

@Bunin 

 

That sounds unusual, could you post a screenshot please?

Highlighted

@Wyn Hopkins Here is a partial screenshot of what the original poster is talking about. I can't click on the field above the field where I have started the formula.

Highlighted

@WuLaw 

After = you may use arrow keys to select navigate to the cell. If you prefer the mouse then increase the row height. Or on ribbon Home->Format->Autofit row height

Highlighted

@WuLaw  @Bunin  i only get this behavior when the row height isn't tall enough for the text so Excel 'creates more room' by temporarily hiding the cell(s) above it.  Does it still happen if you select all and do autoheight or double-click a horizontal line between row numbers?

EDIT: a) i see Sergei replied with very similar comment

        b) you can also change to a smaller font size that will fit that row height.

Highlighted

Ah yes, that is annoying.  Normally I end up just editing / writing the formula in the formula bar instead when that happens