Question

  • Creator
    Topic
  • #3937745

    How to Hide and Unhide the Formula Bar in Excel?

    by ayusnakkudu ·

    The Formula Bar is visible in Excel by default and will allow users to view and enter formulas in an active cell in the spreadsheet.

    I do not wish to see the formula bar on the top of the spreadsheet, how can i take it off?

You are posting a reply to: How to Hide and Unhide the Formula Bar in Excel?

The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our Community FAQs for details. All submitted content is subject to our Terms of Use.

All Answers

  • Author
    Replies
    • #3940215

      RE:

      by jibrinbitrus1 ·

      In reply to How to Hide and Unhide the Formula Bar in Excel?

      carry out the following actions below in order, to Hide and UnHide formula bar in Microsoft Excel:

      1. Launch Excel
      2.Click the View tab
      3.Uncheck the checkbox for the Formula Bar in the Show group.
      4.The Formula Bar will disappear
      5,Check the checkbox to unhide the Formula Bar
      6.Launch Excel.

      [i]Spam link removed by moderator.[/i]

    • #3942644

      Spreadsheet

      by davibrons ·

      In reply to How to Hide and Unhide the Formula Bar in Excel?

      Open the spreadsheet and click the File menu.

      Then select Excel Options and go to the Advanced tab. Then go to the Display section.

      Uncheck Show Formula Bar and click OK
      https://img-23.ccm2.net/qdDV9jRPL6ModGDwdpHyyozckxA=/500x/010da5bdbf8f47b9809d6d5b80e8820f/ccm-faq/hina4Txp-ex11-s-.png

    • #3968069

      Hide and Unhide the Formula Bar in Excel

      by wilsonhenry13463 ·

      In reply to How to Hide and Unhide the Formula Bar in Excel?

      Click Options to activate the Excel Options
      In the Excel Options dialog, activate the Advanced option.
      Scroll down to Display
      Check or uncheck the Show Formula bar option depending on your preferences.
      Click the OK button to apply your changes.

    • #3968628

      Reply To: How to Hide and Unhide the Formula Bar in Excel?

      by ready.09whippet ·

      In reply to How to Hide and Unhide the Formula Bar in Excel?

      Often when doing ctrl alt v quickly I miss a key and it causes my formula bar to disappear. It’s got to the stage where it happens a few times a day and is really annoying to go and get it back.

      Is there a specific short cut that I’m doing to hide it and is there a way to disable this?

    • #3969689

      Reply To: How to Hide and Unhide the Formula Bar in Excel?

      by pumper05sanity ·

      In reply to How to Hide and Unhide the Formula Bar in Excel?

      Hide Formulas In Protected Worksheet

      I am sure that there are some projects where we did lots of research to create complex formulas, calculation and we do not want to show those amazing tricks which we created by ourselves but people can read your formulas in “Formula Bar” even if you have protected the sheet

      Though you can hide Formula Bar but still you can hide formulas without hiding the Formula Bar:

      Select the Cells, Range which is formula driven cells/range.

      Right Click on the Selected Ranges and click on Format Cells

      Go to Protect Tab and Check the box “Hidden” and click “Ok”. It will hide the formulas

      Now when you protect the worksheet, it will hide all the formulas where you have ticked this box

Viewing 4 reply threads