Hiding rows and columns in Excel

• How to hide
• How to show

Sometimes it can be very useful to hide some columns or rows in Excel.

How to hide

To hide a column, follow these steps:

1. Select a column.
2. Right-click on it and click Hide.

Result:

Note: To hide a row, select it, right-click on it and press command Hide (Hide). Everything is exactly the same as with the column.

How to show

To display a column, do the following:

1. Select the columns on either side of the hidden column.
2. Right click and then click unhide (Show).

Result:

Note: To show a row, select the rows on either side of the hidden row, right-click, and click Command unhide (Show).