Hide and display columns and rows in Excel
In the process of working with excel, you want to hide a certain row or column because of job requirements. The following article details how to display or hide columns and rows in excel.
1. Hide columns
For example, to hide the Layer column:
Hide and display columns and rows in Excel Picture 1
Step 1: Select the column you want to hide -> Right-click and select Hide .
Hide and display columns and rows in Excel Picture 2
After selecting Hide the selected column has been hidden and replaced with vertical lines darker than the other lines.
Hide and display columns and rows in Excel Picture 3
2. Show columns
In the above example, the Layer column has been hidden. Now you want to display the Layer column as follows:
Step 1: Select the left and right columns of the hidden column -> Right-click and choose Unhide :
Hide and display columns and rows in Excel Picture 4
The Layer column is shown with darker lines.
Hide and display columns and rows in Excel Picture 5
3. How to hide rows
For example, want to hide the row in the 2nd order:
Hide and display columns and rows in Excel Picture 6
Step 1: Select the rows to hide -> Right-click and choose Hide :
Hide and display columns and rows in Excel Picture 7
The row has been hidden and replaced with a line that is bolder than the other lines.
Hide and display columns and rows in Excel Picture 8
4. Show hidden rows
In the above example, I have hidden the row in the 2nd order, the following will display the second row again.
Step 1: Select rows above and below rows that have been hidden -> Right-click and choose Unhide :
Hide and display columns and rows in Excel Picture 9
The hidden row is displayed and is replaced with a bold line other lines.
Above is how to display and hide rows and columns hope you apply them often.
Good luck!
You should read it
- How to convert columns into rows and rows into columns in Excel
- How to temporarily hide rows and columns in Excel 2013
- Complete tutorial of Excel 2016 (Part 6): Change the size of columns, rows and cells
- Types of data hiding in Excel - Hide pictures, graphs, rows, columns
- How to hide and show the rows and columns in Excel is extremely simple.
- How to use Group to hide, show rows and columns in Excel 2007, 2010, 2013, 2016, 2019
- How to Hide Rows in Excel
- How to hide columns and hide rows in Excel 2016, 2013, 2010
- How to move rows and columns in Excel
- The easiest way to Hide rows in Excel
- How to freeze, hide rows and columns in Google Sheets
- MS Excel 2007 - Lesson 10: Modify columns, rows and cells