1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Excell how do I hide/protect columns

Discussion in 'Other PC Software' started by warpy55, 2009/12/07.

  1. 2009/12/07
    warpy55

    warpy55 Well-Known Member Thread Starter

    Joined:
    2007/06/16
    Messages:
    88
    Likes Received:
    2
    Hi, within excell how do I hide certain rows or columns and password protect them so I can re-open later. I need to send a list out to suppliers and have them put in information into un-locked cells but I wish to hide some rows and columns first. Is there any freeware out there that will do it???
     
  2. 2009/12/08
    Steve R Jones

    Steve R Jones SuperGeek Staff

    Joined:
    2001/12/30
    Messages:
    12,317
    Likes Received:
    252
    I clicked on HELP within Excel and searched for "Hide Cells "

    Display or hide all values in a cell
    Select the cells that contain hidden values or values you want to hide.
    On the Format menu, click Cells, and then click the Number tab.
    Do one of the following:
    Display hidden values in a cell

    In the Category list, click General to apply the default number format.

    To redisplay a date, a time, or values that have a specific number format, select the appropriate date, time, or number format on the Number tab.

    Hide all values in a cell

    In the Category list, click Custom.
    In the Type box, select the existing codes and press BACKSPACE.
    In the Type box, type ;;; (three semicolons).
     

  3. to hide this advert.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.