blank formula bar

By bgrehan ·
After some editing, I noticed that the formula bar in an Excel 2010 workbook no longer displays the formula, although I can still access the formulas by clicking on the cell. Any idea what I might have done and how to undo it?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Maybe you introduced a blank line before your formula?

by GillCooper In reply to blank formula bar

If you click on the cell then move your cursor to the lower edge of the formula bar, the cursor should change to a double-headed vertical arrow. Drag this downwards so that the formula bar now displays multiple lines. Can you see the formula now? If so, you can just clean up the blank line above your formula and all should be good again. (Or simpler still, just delete anything before the "=" in the cell, but resizing the formula bar can be useful in other circumstances too).

Collapse -

Reponse To Answer

by bgrehan In reply to Maybe you introduced a bl ...

Thanks so much; that was helpful!

Related Discussions

Related Forums