Instructions:

  1. Select the cell or cell range you want to hide

  2. Go to tab "Home"
  3. Click "Format"

  4. Click "Format Cells"

  5. Click "Protection" tab
  6. Click checkbox "Hidden"

If this doesnt work, make sure you have done the following:

Protect worksheet and contents of locked cells

  1. Go to tab "Home"
  2. Click "Format"

  3. Click "Protect sheet"

  4. Enable "Protect worksheet and contents of locked cells"

Related posts:

Excel 2007: Color cells that meet criteria using conditional formatting

Excel 2007: How to find errors in a large sheet

Highlight duplicate rows in excel 2007

Lookup with multiple criteria and display multiple search results using excel formula, part 3

Lookup with multiple criteria and display multiple search results using excel formula