Tag Archives: spreadsheets

Microsoft Excel – Hide all text in a cell but leave the formatting

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).

Share this post:
read more