You can also select one row or column, hold Shift, and select another one. The easiest way to hide specific rows and columns is by holding down the Control key to select them one by one. Hide and Unhide Rows and Columns Using Ctrl and Shift The formatted cells should show no data, but once selected, you should be able to see their values in the Formula Bar. Click on the “OK” button to save the changes.Change its type in the “Type” section from “General” to “ ” (three semicolons).In its “Category” section to the left, move from “General” to “Custom.” In the “Format Cells” window that appears, the “Number” tab will already be selected.Right-click on one of the selected cells and choose “Format Cells…”.This method works for single cells, multiple cells, and entire rows and columns. 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. Read on to master the principles of cell hiding. You can hide rows, columns, or even hide certain cells’ data and still be able to use them in formulas. Actually, there are many ways to hide a cell.