How to Hide Rows in Excel

PDF download Download Article
PDF download Download Article

Hiding rows and columns you don't need can make your Excel spreadsheet much easier to read, especially if it's large. Hidden rows don't clutter up your sheet, but still affect formulas. You can easily Hide and Unhide rows in any version of Excel by following this guide.

Quick Guide: Hiding Rows in Excel

To hide rows, use your mouse to select the rows you want to hide, right-click (or control-click) the selection, and click "Hide". To unhide the rows, highlight the rows above and below the hidden cells, right-click the selection, and click "Unhide".

Method 1
Method 1 of 2:

Hiding a Selection of Rows

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c5\/Hide-Rows-in-Excel-Step-1-Version-4.jpg\/v4-460px-Hide-Rows-in-Excel-Step-1-Version-4.jpg","bigUrl":"\/images\/thumb\/c\/c5\/Hide-Rows-in-Excel-Step-1-Version-4.jpg\/aid1693532-v4-728px-Hide-Rows-in-Excel-Step-1-Version-4.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You can hold the Ctrl key to select multiple rows.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6a\/Hide-Rows-in-Excel-Step-2-Version-4.jpg\/v4-460px-Hide-Rows-in-Excel-Step-2-Version-4.jpg","bigUrl":"\/images\/thumb\/6\/6a\/Hide-Rows-in-Excel-Step-2-Version-4.jpg\/aid1693532-v4-728px-Hide-Rows-in-Excel-Step-2-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Select “Hide”. The rows will be hidden from the spreadsheet.
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/09\/Hide-Rows-in-Excel-Step-3-Version-4.jpg\/v4-460px-Hide-Rows-in-Excel-Step-3-Version-4.jpg","bigUrl":"\/images\/thumb\/0\/09\/Hide-Rows-in-Excel-Step-3-Version-4.jpg\/aid1693532-v4-728px-Hide-Rows-in-Excel-Step-3-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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.
    • Right-click within the highlighted area.
    • Select “Unhide”.
    4. Advertisement
Method 2
Method 2 of 2:

Hiding Grouped Rows

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9b\/Hide-Rows-in-Excel-Step-4-Version-3.jpg\/v4-460px-Hide-Rows-in-Excel-Step-4-Version-3.jpg","bigUrl":"\/images\/thumb\/9\/9b\/Hide-Rows-in-Excel-Step-4-Version-3.jpg\/aid1693532-v4-728px-Hide-Rows-in-Excel-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    With Excel 2013, you can group/ungroup rows so that you can easily hide and unhide them.
    • Highlight the rows you want to group together and click "Data" tab.
    • Click "Group" button in the "Outline" Group.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/ed\/Hide-Rows-in-Excel-Step-5-Version-4.jpg\/v4-460px-Hide-Rows-in-Excel-Step-5-Version-4.jpg","bigUrl":"\/images\/thumb\/e\/ed\/Hide-Rows-in-Excel-Step-5-Version-4.jpg\/aid1693532-v4-728px-Hide-Rows-in-Excel-Step-5-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1e\/Hide-Rows-in-Excel-Step-6-Version-4.jpg\/v4-460px-Hide-Rows-in-Excel-Step-6-Version-4.jpg","bigUrl":"\/images\/thumb\/1\/1e\/Hide-Rows-in-Excel-Step-6-Version-4.jpg\/aid1693532-v4-728px-Hide-Rows-in-Excel-Step-6-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Click (+) box if you want to unhide the rows.
    4. Advertisement

Community Q&A

Search
Add New Question
  • Question
    What if the hidden rows were 123 in Excel?
    Community Answer
    Just select the cell or cells, then go to Home, and in Cells group, click Format. Then under Visibility, point to Hide\Unhide, and then click Hide Rows or Hide Columns. This will hide the Rows or Columns of the selected cell or cells.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 7 Helpful 11
  • Question
    How do I hide non-consecutive rows containing a specific word in a given column?
    Community Answer
    Highlight the entire spreadsheet. Go to Data then click on Filter. This will add a drop-down box in the header of each column. Click on the drop-down box in the column where the specified words you want to hide is located. De-select all of the items you wish to hide, and click OK.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 7 Helpful 9
  • Question
    What is the purpose of hiding rows?
    Community Answer
    Hiding rows you don’t need can make your Excel spreadsheet much easier to read, especially if it’s large. For example, if you want to input data that is used for multiple formulas, a hidden row will still contain that information but will not be shown.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 3 Helpful 5
See more answers
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      Easy AutoFilter Basics for Beginners
      How to Group and Outline Excel Data: Easily Collapse Rows of Info
      How to
      Organize Your Comic Collection with Excel
      How to
      Recover a Corrupt Excel File
      How to Merge Cells in Microsoft Excel: A Quick Guide
      Easily Create a Drop-Down List in Microsoft Excel: Setup & Customization
      How to Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Unprotect an Excel Sheet
      How to Create a Graph in Excel
      How to Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Link Sheets in Excel
      How to
      Make a Spreadsheet in Excel
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      Advertisement

      About This Article

      Article Summary X

      1. Select rows to hide.
      2. Right-click the highlighted area.
      3. Click Hide .

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 259,752 times.

      Is this article up to date?

      Advertisement