Hide Data in Selected Cells

Is easy to hide rows or columns by using hide or unhide feature in excel.

Have you ever tried to hide selected cells only? Maybe you used white font to make it invisible or font color equal to your background color.

Easy trick to hide values in selected cells is by changing the cell format function.

1. Choose the cells and go to Home → Font → Open Format Cells → Number Tab → Custom → Type ;;; → Click OK
2. Alternatively, select cells → right click → Format Cells... → Number → Custom → Type ;;; → OK