How to hide columns and hide rows in Excel 2016, 2013, 2010
You are trying to hide columns and hide rows in Excel but you do not know how to hide columns and hide rows quickly. So, please refer to the following article to know how to hide columns and hide rows in Excel 2016, 2013, 2010.
How to hide columns and hide rows in Excel 2016, 2013, 2010 Picture 1
The following article will share to you how to hide columns, hide rows, show hidden columns, show hidden rows in Excel 2016, 2013, 2010, invite you to track.
How to hide columns in Excel
Step 1: First you select the column to hide.
You choose one or more columns you want to hide, if you want to hide many non-adjacent columns, hold down Ctrl and select the non-adjacent columns to be hidden.
How to hide columns and hide rows in Excel 2016, 2013, 2010 Picture 2
Step 2: Right-click the selected column header and select Hide to hide the selected column.
How to hide columns and hide rows in Excel 2016, 2013, 2010 Picture 3
So you've hidden the column, the double line between the two columns means that position has hidden the column.
How to hide columns and hide rows in Excel 2016, 2013, 2010 Picture 4
How to show columns (unhide columns) in Excel
Step 1: To unhide columns in excel, first select the columns adjacent to the hidden columns.
How to hide columns and hide rows in Excel 2016, 2013, 2010 Picture 5
Step 2 : Next, right-click on the selected column header and select Unhide to unhide the column.
How to hide columns and hide rows in Excel 2016, 2013, 2010 Picture 6
So you've successfully unhidden column.
How to hide columns and hide rows in Excel 2016, 2013, 2010 Picture 7
How to hide rows in Excel
Step 1: First you need to select the rows to hide.
Note: You can select one or more consecutive rows to hide, if you want to select non-adjacent rows, hold down Ctrl and select the hidden row .
How to hide columns and hide rows in Excel 2016, 2013, 2010 Picture 8
Step 2: Next, right-click on the heading of the selected rows to hide and then select Hide to hide.
How to hide columns and hide rows in Excel 2016, 2013, 2010 Picture 9
How to unhide rows in Excel
Step 1: To show hidden rows you select the row before and after the hidden rows.
How to hide columns and hide rows in Excel 2016, 2013, 2010 Picture 10
Step 2 : Next, right-click on the row header and select Unhide to unhide the row.
How to hide columns and hide rows in Excel 2016, 2013, 2010 Picture 11
Above the article has shown you how to hide columns, hide rows along with the visible columns, hidden rows in Excel 2016, 2013, 2010. Hopefully through this article, you will be able to easily hide / show rows. and columns in Excel. Good luck!
You should read it
- How to use Group to hide, show rows and columns in Excel 2007, 2010, 2013, 2016, 2019
- 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
- How to add columns, delete columns, add rows, delete rows in Word 2007, 2010, 2013, 2016
- Types of data hiding in Excel - Hide pictures, graphs, rows, columns
- How to fix column and header rows in Excel 2007, 2010, 2013, 2016
- Hide and display columns and rows in Excel
- How to hide and show the rows and columns in Excel is extremely simple.
- How to Hide Rows in Excel
- How to freeze, hide rows and columns in Google Sheets
- How to convert columns into rows and rows into columns in Excel
- How to fix column and header rows in Excel 2016
May be interested
How to make Slide beautiful and professional
How to create PDF files from Word, Excel, Powerpoint files simply and quickly
How to print two sides of paper in Word, PDF, Excel when using the printer does not support 2-sided printing
Shortcuts in Word need to know
How to print A5 size paper in Word
How to fix the printer error does not receive the print job effectively