Microsoft Excel is a very popular spreadsheet program because it’s very powerful, yet simple to use. When it comes to tables, there’s hardly anything you can’t do. If you want to hide a certain cell to protect valuable information or to prevent it from distracting you, you can do in no time.
Actually, there are many ways to hide a cell. You can hide rows, columns, or even hide certain cells’ data and still be able to use them in formulas. Read on to master the principles of cell hiding.
Hide Cell Data
If you’d like to hide the data of a single cell, but would prefer the cell to remain visible, you can do this by formatting it.
Select the cell. This method works for single cells, multiple cells, and entire rows and columns.
Right-click on one of the selected cells and choose “Format Cells…”