How to unhide the formula bar in excel

Microsoft Excel 2013 and Excel 2010 displays the formula details in Formula bar. In case if your excel does not show the Formula bar then you can unhide the formula bar using the View menu.

To unhide the formula bar in Excel 2010 and Excel 2013

  • Navigate to the View menu and then to the Show section.
  • Under Show section, tick the check box with label as Formula Bar.

image

Now Excel would start displaying the Formula bar below the Office menus.



Meet the Author

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

14 comments… add one

  • Sherrie Slaughter Oct 1, 2011, 6:26 pm

    I am running Excel 2010. My formula bar is gone, and instead the name bar goes across the sheet. Under View, Formula Bar is checked.

  • Rem Aug 6, 2012, 3:16 pm

    How do I set Excel 2010 so that the formula bar is always visible?

  • ron Aug 17, 2012, 12:17 am

    How do i set the formula bar so it is aways visible when I open Excel 2010, and do not need to unhide it each time.

  • Gary Hanagami Sep 12, 2012, 12:22 am

    Thank you for this tip; somehow I must have unchecked the Formula Bar box and it has been driving me crazy for the last couple of days!

  • Renjith Oct 8, 2012, 11:45 pm

    Thank you for the info

  • dary Oct 26, 2012, 11:28 pm

    This is helpful. thanks for the tip.

  • PD Jan 28, 2013, 5:05 pm

    Got it .. thank you.. its v quick

  • dejan Aug 10, 2013, 1:34 am

    moguli se podaci iz jednog exsela prebacivati u drugi,ako moye kako

  • Teresa Dec 17, 2013, 8:12 pm

    I’m using Excel 2010. The first few characters are invisible in my formula bar. For instance – the cell says “Groceries”. The formula bar shows “ceries”. I unchecked and rechecked the formula bar box under view/show. Any ideas?

  • Ravi Shankar Dec 17, 2013, 8:37 pm

    are you using dual monitors by any chance?

    Regards
    Ravi

  • Teresa Dec 17, 2013, 10:09 pm

    Yes, I am using dual monitors. Is that the problem? Any fix?

  • Ravi Shankar Dec 17, 2013, 10:17 pm

    Check out the below link about formula bar issue with dual monitor. See update from WindsurferLA on analog and digital issue. Hope this helps.

    http://www.pcreview.co.uk/forums/hidden-characters-formula-bar-excel-2007-a-t3670026.html

  • Teresa Dec 17, 2013, 10:49 pm

    Thank you Ravi! Appreciate your time!

  • Sandeep Gaba Jan 9, 2014, 3:38 pm

    Gr8… Thanks

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.