How to hide Excel rows and columns and worksheets

How to hide Excel rows and columns and worksheets

1, start Excel 2013 and open the worksheet, on the Start tab, in the Cells group, click the Format button, select the Hide and Unhide option in the Open Drop-down list, and select the Hide Columns option in the open cascading list, as shown in Figure 1. The column that contains the current cell is hidden, as shown in Figure 2.

Figure 1 Selecting the Hide Columns option

Figure 2 The column that contains the current cell is hidden

2, click the Format button, select the "Hide and unhide" option in the Open Drop-down list, and select the "Hide sheet" option in the open cascading list, as shown in Figure 3. At this point, the current worksheet is hidden, as shown in Figure 4.

Figure 3 Selecting the Hide sheet option

Figure 4 The current worksheet is hidden

3, after hiding the worksheet, click the Format button, in the Open Drop-down list, select the Hide and Unhide option, select the Unhide sheet option in the Open cascading list to open the Unhide dialog box, and in the Unhide Sheet list box, select the worksheet you want to unhide, as shown in Figure 5, Then click the OK button to close the dialog box, and the hidden sheet will appear.

Figure 5 Unhide dialog box

Attention

Press the "ctrl+9" key to hide the row of the selected cell, and press the "ctrl+0" key to hide the column that contains the selected cell. Pressing the "ctrl+shift+9" key or the "ctrl+shift+0" key will enable you to unhide the row or column. In addition, selecting the Unhide rows and Unhide columns commands in the open "hide and unhide" Cascading list will enable you to unhide the rows.