I. Overview
Some cells are only used for intermediate operation and do not need to be displayed. You want to hide the value of the cell and hide a row and a column as a whole.
There are three ways to achieve that.
II. Set directly to hide rows and columns
Right click the row or column label to hide, select row height or column width in the pop-up menu, set it to 0, or right-click to hide directly.
III. Hide rows and columns by setting row height and column width to 0
Sometimes we need to show the rows and columns when we meet the conditions, otherwise we can hide the rows and columns by setting the row height and column width in the conditional formatting.
Right click cell > conditional formatting, add condition, and click to select the attribute to be changed. The drop-down button will pop up. Select the column width or row height, which is 0 by default.
If the current value is 0 or the column width is 0 when it is empty, the setting of the condition property is as follows:
len($$$) = 0 means the current value is empty.
$$$ = 0 means the current value is equal to 0.
Note1: Select row height or column width, the figrue is just for instruction.
Note2: when setting column width formula, you need to click "add" after setting to have effect
IV. Unhide
You must select the previous row and the next row of the hidden row, the previous column and the next column of the hidden column at the same time, and then right-click to select unhide to display the hidden row or column.
