The easiest way to Hide rows in Excel

Select and hide multiple rows

The easiest way to Hide rows in Excel Picture 1

Use the selection cursor to highlight the rows that you want to hide. You can hold down the Ctrl key to select multiple rows.

The easiest way to Hide rows in Excel Picture 2

Right click on the highlighted area. Select 'Hide'. The selected rows are hidden from the sheet.

The easiest way to Hide rows in Excel Picture 3

Unhide the rows. To do this, use the selection cursor to highlight the rows above and below the hidden row. For example, you would select row 4 and row 8 if rows 5-7 are hidden.

Right click on the highlighted area.

Select 'Unhide'.

Hide merged rows

The easiest way to Hide rows in Excel Picture 4

Consolidate goods. With Excel 2013, you can merge/unmerge rows to easily hide and unhide them.

Highlight the rows you want to merge and click the "Data" tab.

Click the "Group" option in the "Outline" option group.

The easiest way to Hide rows in Excel Picture 5

Hide merged rows. You should see a line and a box with a minus sign (-) inside appear next to the merged rows. Click the box to hide the merged rows. Once hidden, a plus sign (+) will be displayed in the box.

The easiest way to Hide rows in Excel Picture 6

Unhide merged rows. If you want to unhide these rows, just click in the box with the plus sign (+).

3.5 ★ | 2 Vote

May be interested

  • How to convert columns into rows and rows into columns in ExcelHow to convert columns into rows and rows into columns in Excel
    you need to convert excel columns into rows or convert data in excel rows into columns, if retraining takes a lot of time, just a trick that network administrator instructs below, you can turn the rows into columns or columns into rows extremely easy.
  • 8 How to delete blank rows in ExcelHow to delete blank rows in Excel8 How to delete blank rows in ExcelHow to delete blank rows in Excel
    empty rows of data can be a major annoyance. here are 8 ways to delete blank rows in excel. how to delete blank lines in excel
  • How to Add Rows in Excel Using FormulasHow to Add Rows in Excel Using Formulas
    if you're looking for a quick way to add blank rows to an excel spreadsheet, you'll be surprised to learn that there's no excel function or formula that can do this. however, you can write a macro (a command that executes a certain job script) to instantly add a certain number of rows to the specified location. today's tipsmake will show you how to write a simple macro to add new rows to an excel spreadsheet. besides, the article also shows how to add existing formulas to new rows in the spreadsheet.
  • How to hide and hide sheets in Excel and show them againHow to hide and hide sheets in Excel and show them again
    hide sheets in excel makes excel spreadsheets easier to see, and more to work on content on a sheet.
  • How to move rows and columns in ExcelHow to move rows and columns in Excel
    how to move rows and columns in excel. when you edit documents on excel columns and rows it may be during that process that you want to rearrange the order and position of the columns and rows. if you do not know how, you can follow the following method of tipsmake.com.
  • How to freeze, hide rows and columns in Google SheetsHow 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.
  • How to quickly Add and Delete rows and columns in ExcelHow 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 delete rows and columns in Excel with mouse or keyHow 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.
  • MS Excel 2007 - Lesson 10: Modify columns, rows and cellsMS 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 ExcelHow 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