Q&A for How to Hide Rows in Excel

Return to Full Article

Coming soon

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 9 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 8 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
Question

If some rows are hidden accidentally but I don't know which ones, is there any key to reveal the whole spreadsheet just in one click?

Community Answer

Select the entire sheet by clicking on the arrow in the upper left corner, then go to Home, and in the cells group, click "Format." Then under "Visibility," point to "Hide/Unhide," and click "Unhide Rows" or "Unhide 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 1 Helpful 2