Hide and unhide rows and columns in Excel

When dealing with a data-heavy spreadsheet, sometimes its helpful to hide or unhide rows and columns to better see the information needed.

Excel makes it easy to do this by allowing the user to hide the unwanted columns.

The following passage demonstrates to hide and unhide columns.

1.Select the columns or rows to be hidden. We can select multiple columns or rows.

2.The rows or columns, if adjacent cane be selected by pressing "Shift" key.

We also type in the row or column identifier in the name box to the left of the formula field, so if you want to hide the second row, for example, type B2.

3.In the Home tab under the Cells group, click Format > Hide and Unhide > Hide Rows or Hide Columns.

4.Or Right click on the Excel worksheet in the column or row you want to hide and click hide.

excel hide and unhide rows and columns

The corresponding column is hidden.

To Unhide, Right click the thin double line indicating a hidden row or column and click Unhide.

 

You can find similar Excel Questions and Answer hereunder

1) I have 2 sets of lists from 2 different reports - how can I select the cells with differences?

2) Split string into multiple columns in Excel

3) How can I show summary reports with Totals only hiding all the rows containing the details?

4) I have a column header Title that is big - I cannot increase the size of column. In Excel, how can I somehow fit the Title retaining the existing column width?

5) I have a table where inputs have to come from various users. In Excel, how can I highlight a row automatically that does not have input so that I can follow up with the concerned?

6) How can I set Page orientation, Zoom % , Title Rows and footer using VBA?

7) How to delete rows with Excel VBA

8) Autofill a b c d aa ab in Excel

9) How can I hide Formula Bar and Headings using VBA?

10) How can I hide a sheet completely from users (the sheet should not even appear in Unhide dialog box)?

 

Here the previous and next chapter