Hide cell contents by changing the cell format (in Excel)

Hide cell contents by changing the cell format (in Excel)

Useful in situations where you have a small amount of data you want to hide but still want to be able to work with (and you’re not required to hide the entire column or row). And when you print the data as well the cell hided will not be printed.

Step 1 – Select the cell or cells you want to hide. In this example, cell C3 to C6 is selected.

Step 2 – Select the option Format Cells or click Ctrl + 1 

Step 3 – The Format Cells options will appear; select Custom

Step 4 – Type a three semi-colon marks (;) under Type

Step 5 – Select OK

See below, Cell C3 to C6 will appear as hidden (and hidden for printing) but included in the formulas.