Software

Ask something
Question Locked

blank formula bar

0 helpful
3 replies

by bgrehan

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?
Thanks
Barb

3 replies

by gillcooper

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).

by bgrehan

Thanks so much; that was helpful!
Barb

This discussion is closed to new replies.