How to Hide and Show the Rows and Columns in Excel Is

1. Hide (Hide) Column Rows in Excel

A. Hide Rows in Excel

For example, you have a spreadsheet like this:

And you need to hide the 6th and 7th rows away.

+ Hide 1 row in Excel

If you may need to hide each row, you right-click the row to hide (item 1) »Select Hide (item 2).

Once there, you will see the 6th row will be hidden as shown below:

+ Hide multiple rows at once in Excel

First, left-click and hold the left mouse button on the first row to hide in Excel worksheet:

Next, you move the mouse down to select additional rows to hide. After selecting, release the left mouse button:

Right-click the selected rows »Select Hide to hide those rows at the same time:

Here is the worksheet after hiding 2 rows (Row 6 + 7):

B. Hide Columns in Excel Spreadsheets

Suppose the table has 5 columns: No. (column A), Full name (column B), Age (column C), Occupation (column D), Interests (column E) as shown below:

Now, you may need to hide the Age column and the Interests column. We will do the following:

+ Hide 1 column in Excel

First, we will hide column C containing the Age column first by right-clicking on column C »Select Hide.

And here is the result after hiding column C containing the Age column:

Do the same to hide the Occupation column (column D).

+ Hide multiple columns at once in Excel

First, left-click and hold the left mouse button on the first column to hide in the Excel spreadsheet. In this case, column C is the first column:

Next, move your mouse to the right to select additional columns to hide. After selecting, release the left mouse button:

Next, right click the selected area »Select Hide

And here is the result after hiding the Age (column C) and Occupation (column D) columns at the same time:

2. Display Hidden Column Rows in Excel

A. Show Hidden Rows in Excel

Example of your original spreadsheet:

After performing the operation hide 2 rows 6 and 7

Now, if you may need to display two hidden rows (row 6 and row 7), left-click the first 5 rows:

Then, move the mouse down to select additional row 8:

Right click the selected area »Select Unhide:

And the hidden rows are displayed:

B. Show Hidden Columns in Excel

Initially we have the following Excel spreadsheet:

After hiding the Age column (column C) and Occupation column (column D), the remaining worksheet:

Now, we will show the hidden columns C and D again by holding down the left mouse button on column B, then moving the mouse to the right to select additional column E. Then release the left mouse button:

Right click selected area »Select Unhide:

And this is the result:

social shareand social share