+ Reply to Thread
Results 1 to 6 of 6

How to hide formular in excel file

  1. #1
    Forum Contributor
    Join Date
    02-11-2016
    Location
    tanzania
    MS-Off Ver
    2007
    Posts
    319

    How to hide formular in excel file

    Hi guys
    i have data with formulars in my excel file
    but i want to hide formulars stil file to works as normal while i put data

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: How to hide formular in excel file

    Read here:

    https://support.office.com/en-us/art...9-0C1B77A5356F
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Contributor
    Join Date
    01-06-2015
    Location
    Huntsville, AL
    MS-Off Ver
    Office 365
    Posts
    185

    Re: How to hide formular in excel file

    Select the cells you want to hide the formulas in. Right click and go to "Format Cells". Click on "Protection". Click "Locked" & "Hidden". Protect your worksheet. Version 10 is under "Review" Tab.

  4. #4
    Forum Contributor
    Join Date
    02-11-2016
    Location
    tanzania
    MS-Off Ver
    2007
    Posts
    319

    Re: How to hide formular in excel file

    It does'nt work
    sorry can you attacha sample file with hiden formular

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: How to hide formular in excel file

    Did you read the article and/or follow the on-screen instructions regarding sheet protection? File attached.
    Attached Files Attached Files

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: How to hide formular in excel file

    Aplogies for the delay, but my www access is terribly poor at the moment.

+ 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. Hide formular in different cell
    By issa.o in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-06-2016, 11:41 PM
  2. Complicated formular. Formular, remove text if available
    By TheTrooper1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-02-2014, 12:39 PM
  3. [SOLVED] Replacing a date formular result with another formular
    By stpeter in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-06-2013, 06:27 PM
  4. [SOLVED] Hide text/value in the formular bar
    By sarinky in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-23-2013, 03:45 AM
  5. Hide file menu ribbon excel 2010
    By DavidMorrison in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2010, 05:19 PM
  6. How to hide formula in an excel file
    By endz0926 in forum Excel General
    Replies: 6
    Last Post: 08-06-2009, 06:14 AM
  7. How to hide Sheet tab Bar & status Bar for a excel file
    By Vikky in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-17-2006, 04:35 AM

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