Excel+Cell+Hide+and+Seek

Excel Cell Hide and Seek

Have you ever needed to hide the contents of a single cell? What a phaff it is, well not really if you know how Continue reading:-

• To begin, you'll need to select the cell with the contents that need to be hidden. • Next, you need to get to the Format Cells window. You can do this either through the Format menu, Cells choice, right click and choose Format Cells or with Ctrl + 1. (In Excel 2007, Ctrl + 1 still works and so does the right click trick, but since it doesn't have menus, you'll need to go to the Home ribbon, Cells section on the right side of the ribbon and then hit the Format button, Format Cells choice). • On the Number tab, in the Category column, you need to select Custom. • Then in the Type field, you need to highlight the current selection and type in ;;; (that's three semicolons). •

• Now, just click OK or press Enter.

That is it! You should have been returned to your worksheet where you no longer see the contents of the cell. (You may notice that you can still see the cell contents in the formula bar, but not in the worksheet). If you ever need to display the cell contents again, simply go back into the Format Cells window, select the appropriate category, type in the data and then click OK.  