Hide or Show Rows in Excel

Hide or Show Rows in MS Excel

To hide important or un-necessary information in a row, follow the steps below:

1. Select the desired rows(s) range using Rows Headers

Select the desired rows

2. Right click on the selection and select Hide from the Context Menu

hide

3. This will hide the select row(s)

hide the select row

To Unhide the hidden row(s), follow the steps below:

1. Select the rows above and below the hidden range

below the hidden range

2. Right click on the selection and select Unhide from the Context Menu

unhide

3. This will unhide the hidden row(s) within the selected range

unhide the hidden row