+ Reply to Thread
Results 1 to 5 of 5

How To Hide Formulas In Excel Sheet

  1. #1
    Registered User
    Join Date
    08-01-2019
    Location
    Saudi Arabia
    MS-Off Ver
    10
    Posts
    1

    Post How To Hide Formulas In Excel Sheet

    I would like to hide formulas in Excel Sheet without lock the worksheet or workbook.

    Please help if anyone can.

    Thanks.

  2. #2
    Registered User
    Join Date
    05-02-2017
    Location
    NoVa, United States
    MS-Off Ver
    2010
    Posts
    96

    Re: How To Hide Formulas In Excel Sheet

    How hidden do you want it? You can always copy and paste values after you run the formulas.

    Aside from that you could open a tab, write all the formulas on that tab. Open another tab in the same workbook and then have that tab reference the values on the hidden tab. That's not *very* hidden, granted.

    Those are what I can think of - someone with a better grasp of excel will probably come along with a better suggestion.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    21,558

    Re: How To Hide Formulas In Excel Sheet

    Possibly using VBA, otherwise, I think you can only do this by protecting the sheet.
    Glenn



  4. #4
    Forum Contributor
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    134

    Re: How To Hide Formulas In Excel Sheet

    and as asked, how hidden do you want it, another option is to hide the formula bar (View, uncheck formula bar). doesn't really do much, but just wanted to put another option because we don't know what the full purpose is.

  5. #5
    Registered User
    Join Date
    09-25-2016
    Location
    rotterdam
    MS-Off Ver
    2014
    Posts
    4

    Re: How To Hide Formulas In Excel Sheet

    Hiding formules you can do this by protection your sheet

    also do right click on that cell formatcells and protection and then cekc the box hide
    This will hide the formules

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1