Results 1 to 2 of 2

Thread: How To Protect Hide Formula In Excel

  1. #1
    Senior Member
    Join Date
    Mar 2013
    Posts
    107
    Rep Power
    12

    How To Protect Hide Formula In Excel

    Hi

    I have a formula in cell C13 in which i would like to protect only this cell in the spreadsheet.Can this be done or can i make the formula invisible so no-one see it?

    Thanks

    Paul
    Excel 2010

  2. #2
    Member
    Join Date
    Nov 2011
    Posts
    41
    Rep Power
    0
    Hi Paul,

    Plz follow these steps.

    1: Right Click on the cell choose format Cell-> Select Protection Tab->Select Hidden Option->ok
    2: Protect the Sheet

    This will hide the formulea on the sheet only result of the formula will be shown there

    Regards
    Prince

Similar Threads

  1. How To Lock Or Protect Cell Using Data Validation
    By mahmoud-lee in forum Excel Help
    Replies: 4
    Last Post: 06-06-2013, 01:57 AM
  2. VBA To Hide And Unhide Rows
    By paul_pearson in forum Excel Help
    Replies: 10
    Last Post: 05-08-2013, 03:14 AM
  3. Replies: 1
    Last Post: 06-26-2012, 08:17 PM
  4. Hide/Unhide Columns with Listbox
    By obed_cruz in forum Excel Help
    Replies: 2
    Last Post: 05-28-2011, 07:26 PM
  5. Hide Ribbon and Formula Bar
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 04-21-2011, 07:03 PM

Posting Permissions

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