+ 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
    Forum Contributor
    Join Date
    05-02-2017
    Location
    NoVa, United States
    MS-Off Ver
    2010
    Posts
    114

    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
    It changes constantly, but based in Ireland.
    MS-Off Ver
    New learning curve! Office 365
    Posts
    25,411

    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
    Valued Forum Contributor
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    894

    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)

Similar Threads

  1. VBA to hide all formulas in work sheet
    By siddiq1212 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-18-2013, 03:03 AM
  2. [SOLVED] Need Formulas to Hide Partial Concatenate Data and Help Determining Two Other Formulas
    By Mattdim805 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-13-2013, 04:11 PM
  3. 'Hide rows with formulas but no data' - Sheet Event Code problem
    By OLLY-7 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 09-03-2013, 04:02 AM
  4. [SOLVED] Found A Great VBA Script To Hide Formulas Without Protect Sheet But Still Buggy..
    By resshin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2013, 11:11 AM
  5. hide a sheet with all my formulas
    By myfe in forum Excel General
    Replies: 2
    Last Post: 07-09-2012, 01:21 PM
  6. [SOLVED] Copy data in excel through vba / hide formulas
    By grk_chakri in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-05-2012, 01:09 AM
  7. how can i hide the formulas in excel?
    By raveepoojari in forum Excel General
    Replies: 4
    Last Post: 09-05-2009, 11:15 AM
  8. How do I hide formulas in Excel cells?
    By Rita in forum Excel General
    Replies: 2
    Last Post: 02-15-2005, 06:45 PM

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