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!

2013 2010

Jessica Tanner

Update 19 May 2020

You should read it

May be interested

The easiest way to Hide rows in Excel
hiding unnecessary rows and columns will make excel sheets less cluttered, especially with large sheets. hidden rows will not appear, but will still affect the formulas in the worksheet.
How to freeze, hide rows and columns in Google Sheets
freezing or hiding columns or rows in google sheets makes it easier for us to have multi-column data tables.
MS Excel 2007 - Lesson 10: Modify columns, rows and cells
when you open a new blank workbook in excel 2007, cells, columns, and rows are set to default sizes. you can change the size of each cell, column and row, as well as insert new columns, rows and cells if needed.
How to handle cells, columns, rows in a spreadsheet in Excel
the following article will guide you in detail how to handle cells, columns, rows in spreadsheets in excel. 1. change the width of columns, rows and cells in excel. 1.1 resize a row or a column: - hold down the left mouse button for the vertical part of the column and drag the cycle
How to delete rows and columns in Excel with mouse or key
excel is an important and indispensable tool in the work process. however, editing data or deleting rows and columns in excel can be quite complicated for some new users. therefore, to help make work more efficient, we will introduce to readers how to delete rows and columns in excel using the mouse or keys in detail in the article below.
How to quickly Add and Delete rows and columns in Excel
even if you're a careful planner, you'll probably decide that you want to change the layout of your excel spreadsheet.
How to add rows and columns in Excel
how to add rows and columns in excel. the article shows you 3 ways to add rows (rows) or add columns in excel.
How to fix column and header rows in Excel 2016
how to fix columns and headlines in excel 2016. with an excel table with a large number of columns and rows, fixing columns and headlines is a necessary job, you can easily check. investigate and process data without confusion and waste n
Spacing rows and columns in Excel beautifully
spacing rows and columns in excel beautifully. when editing text in excel, you will come across cases where rows or columns of unequal width make your text look bad. after editing is finished, we need to readjust for v
Instructions for coloring alternating rows and columns in Excel
alternating colors in excel is a useful technique to make your spreadsheet more visual. learn how to use conditional formatting in excel 2007 to 2016 to easily distinguish rows and columns.