HomeApplicationOffice information

How to Hide Rows in Excel

Method 1 of 2:

Hiding a Selection of Rows

  1. How to Hide Rows in Excel Picture 1
    Use the row selector to highlight the rows you wish to hide. You can hold the Ctrl key to select multiple rows.
  2. How to Hide Rows in Excel Picture 2
    Right-click within the highlighted area. Select 'Hide'. The rows will be hidden from the spreadsheet.
  3. How to Hide Rows in Excel Picture 3
    Unhide the rows. To unhide the rows, use the row selector to highlight the rows above and below the hidden rows. For example, select Row 4 and Row 8 if Rows 5-7 are hidden.
    1. Right-click within the highlighted area.
    2. Select 'Unhide'.
Method 2 of 2:

Hiding Grouped Rows

  1. How to Hide Rows in Excel Picture 4
    Create a group of rows. With Excel 2013, you can group/ungroup rows so that you can easily hide and unhide them.
    1. Highlight the rows you want to group together and click "Data" tab.
    2. Click "Group" button in the "Outline" Group.
  2. How to Hide Rows in Excel Picture 5
    Hide the group. A line and a box with a (-) minus sign appears next to those rows. Click the box to hide the "grouped" rows. Once the rows are hidden the small box will display a (+) plus sign.
  3. How to Hide Rows in Excel Picture 6
    Unhide the rows. Click (+) box if you want to unhide the rows.
4 ★ | 1 Vote
clickgroupunhide

You should read it

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

Office information