Sometimes, you may want to hide all of the text inside a cell when using an Excel workbook. This is handy if you are doing things like measured works. It allows you to have a few columns adding up to a total where 0’s produce a red cell and 1’s produce a green cell. The final column can then be a total and go green when you have filled all of the other cells in with a 1.
To hide the text inside the cells, just highlight the cells you want to affect, select “formatting” and then choose custom. In the custom box, type ;;; (that’s 3 x semi-colons).