How to hide and show the rows and columns in Excel is extremely simple.
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:
You should read it
- Types of data hiding in Excel - Hide pictures, graphs, rows, columns
- How to temporarily hide rows and columns in Excel 2013
- Hide and display columns and rows in Excel
- How to Hide Rows in Excel
- How to hide columns and hide rows in Excel 2016, 2013, 2010
- Complete tutorial of Excel 2016 (Part 6): Change the size of columns, rows and cells
- How to convert columns into rows and rows into columns in Excel
- How to use Group to hide, show rows and columns in Excel 2007, 2010, 2013, 2016, 2019
- How to hide and hide sheets in Excel and show them again
- How to freeze, hide rows and columns in Google Sheets
- How to move rows and columns in Excel
- Ways to hide data on Excel
Maybe you are interested
How to use pictures as Excel chart columns
Instructions for quickly aligning Excel printed pages, printing to fit the paper, without losing columns
Excel - Convert columns to rows in Excel
How to delete rows and columns in Excel with mouse or key
Instructions on how to break columns in Word simply and quickly
Column order in Excel is reversed, why and how to handle it?