Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    388
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Is it possible to hide the formula in a particular cell or cells and not the rest of the work sheet?

    Thank you

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Yes, if you protect the sheet and check the Hidden property for that cell on the Protection tab in the Format Cells dialog.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    388
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I followed your instruction but it protects all cells and makes them read only. I only wanted certain cells (formula) hidden on the formula bar. The rest of the worksheet I would like to have the capability of input. Thanks


  4. #4
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    The default property for all cells is that they are locked when protection is applied.
    I would modify the normal cell style to be unlocked. This will change the default behaviour.
    Then find your specific cells containing formulas and hide them as Rory suggested.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  5. #5
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by rory View Post
    Yes, if you protect the sheet and check the Hidden property for that cell on the Protection tab in the Format Cells dialog.

    Another way would be to have the formulas on another hidden and protected sheet and just have references to it (=HiddenSheet!A1) in the cells you can see.

  6. #6
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    388
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I'm sorry, I don't think I was clear. I want a cell's contents not to show in the formula bar. I want all the other cells to be viewed in formula bar and also written on. Is this possible. It appears when I hide the contents of a cell in the formula bar, all the cells are read only.

    Thanks

  7. #7
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by MNN View Post
    I'm sorry, I don't think I was clear. I want a cell's contents not to show in the formula bar. I want all the other cells to be viewed in formula bar and also written on. Is this possible. It appears when I hide the contents of a cell in the formula bar, all the cells are read only.

    Thanks
    Select the whole sheet.
    Go to Format | Cells
    Select the Protection Tab and untick the Locked tickbox
    OK
    Select the cell(s) you want to hide
    Go to Format | Cells
    Tick the Hidden tickbox (and the Locked tickbox too if you want)
    OK
    Now go into Tools | Protection and protect the sheet.
    OK

    I think this is what you wanted - the reason you had a problem is that the default setting is that cells are locked on a protected sheet.

  8. #8
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    388
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I cannot get this. I want to hide certain cell in the formula bar. in fact three different columns with two colums in between each of the hidden columns but i want to have all the other cell accessable to key numbers on except for these 3 formula colums of cells. what am i doing wrong?

  9. #9
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by MNN View Post
    I cannot get this. I want to hide certain cell in the formula bar. in fact three different columns with two colums in between each of the hidden columns but i want to have all the other cell accessable to key numbers on except for these 3 formula colums of cells. what am i doing wrong?
    What you need to do is this -
    Select the whole sheet.
    Go to Format | Cells
    Select the Protection Tab and untick the Locked tickbox
    OK
    Select the columns you want to hide
    Go to Format | Cells
    Tick the Hidden tickbox (and the Locked tickbox too if you want)
    OK
    Now go into Tools | Protection and protect the sheet.
    OK

    What are you getting ? Can you post an example?

Posting Permissions

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