In real work, there are times when you want to hide the rows or columns you don't want to show on the printout of an Excel spreadsheet. Or, after printing, you want to display the previously hidden rows and columns. This article will show you how to hide (Hide) and show (Unhide) column rows in Excel.
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
In case you want to hide each row, you right-click on 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 on 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 want 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 on 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 want to display two hidden rows (row 6 and row 7), left-click on the first 5 rows:
Then, move the mouse down to select additional row 8:
Right click on 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 on selected area »Select Unhide:
And this is the result: