How to temporarily hide rows and columns in Excel 2013

Excel 2013 has a feature that allows temporary users to hide one or more rows / columns in an Excel spreadsheet. This feature is very useful in case you only want to print a part of the spreadsheet but do not want to delete other excess rows and columns.

Instructions on how to temporarily hide and make appear again in one or more rows / columns in the Microsoft Excel 2013 spreadsheet.

Excel 2013 has a feature that allows temporary users to hide one or more rows / columns in an Excel spreadsheet. This feature is very useful in case you only want to print a part of the spreadsheet but do not want to delete other excess rows and columns.

Note: Cells in hidden rows and columns are still included in the table calculations.

Hide one or more rows

Select the rows you want to hide.

Picture 1 of How to temporarily hide rows and columns in Excel 2013

Right-click on one of the selected row titles, select 'Hide' from the menu (menu) that appears.

Picture 2 of How to temporarily hide rows and columns in Excel 2013

The selected rows will be pressed, including the row title.

Note that rows 3 and 4 in the picture below are hidden. Separating between rows 2 and 5 (where hidden rows are located) is a bold line. When you perform other operations on the spreadsheet, this bold line will disappear. However, you can identify locations of hidden rows by viewing which row titles are missing.

Picture 3 of How to temporarily hide rows and columns in Excel 2013

To reappear a row, you must select the row above and the row below the hidden rows. In this case, row 2 and row 5. Then right-click on the title of the selected row, press 'Unhide' from the menu that appears.

Picture 4 of How to temporarily hide rows and columns in Excel 2013

Hidden rows will reappear and be marked with the surrounding rows.

Picture 5 of How to temporarily hide rows and columns in Excel 2013

Hide one or more columns

You can also easily hide one or more columns. Select the columns you want to hide, right-click one of the column headers, select 'Hide' from the menu that appears.

Picture 6 of How to temporarily hide rows and columns in Excel 2013

The selected columns will disappear with the column header. The position of the pressed column is marked with a bold line.

Picture 7 of How to temporarily hide rows and columns in Excel 2013

To reappear hidden columns, like with hidden rows, select the columns on the left and right of the hidden columns, right-click one of the column headers, select 'Unhide' from the menu appear.

Picture 8 of How to temporarily hide rows and columns in Excel 2013

Hidden columns will reappear and be marked with the columns on the left and right of it.

Picture 9 of How to temporarily hide rows and columns in Excel 2013

Update 25 May 2019
Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile