Pin Me

Hiding Values in Excel 2013 Cells

written by: •edited by: Tricia Goss•updated: 2/26/2016

Some data is necessary for functions and tools, but is distracting on an otherwise clean worksheet. To keep your sheet neat, hide the data using the Format Cells feature. While they won’t appear in the cells, you can still verify the values by selecting the cells and looking in the Formula Bar.

  • slide 1 of 8

    1. Select the cells that contain the data you want to hide.


  • slide 2 of 8
     

    2. Right-click anywhere in the selected range and click Format Cells from the pop-up menu.

  • slide 3 of 8
     

    3. Click the Number tab and select Custom from the Category list.

  • slide 4 of 8
     

    4. Enter ;;; (that’s three semicolons) in the Type field and click OK.

  • slide 5 of 8
     

    5. View the original data to see that it’s hidden on the sheet.

  • slide 6 of 8
     

    This method not only hides the data on the sheet, but also on printouts, so you’re ensured a clean output.

    Note that you can still view the values in selected cells by looking in the Formula Bar. To also hide the formula in the Formula Bar, check Hidden in the Format Cells’ Protection tab and click Protect Sheet in the main Review tab’s Changes group.

  • slide 7 of 8
     

    Leave the defaults as they are, but you can optionally enter a password to prevent others from disabling protection. Click OK to protect the spreadsheet.

  • slide 8 of 8