ExcelBanter - How do I hide multiple rows under one row IN EXCEL?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I hide multiple rows under one row IN EXCEL? (https://www.excelbanter.com/excel-worksheet-functions/263286-how-do-i-hide-multiple-rows-under-one-row-excel.html)

steven

How do I hide multiple rows under one row IN EXCEL?

Ho do I hide multiple rows under one row in excel ?
How do I see agan multiple rows hidden under one rwo ?

trip_to_tokyo[_3_]

How do I hide multiple rows under one row IN EXCEL?

EXCEL 2007

Click rows 4, 5 and 6 so that they are highlighted.

Right click / Hide.

TO UNHIDE

Click rows 3 to 7 to highlight them.

Right click / unhide.

If my comments have helped please hit Yes.

Thanks.

Ashish Mathur[_2_]

How do I hide multiple rows under one row IN EXCEL?

Hi,

Select the cells which you want to Group and then press Alt+Shift+Right
arrow. Now select the rows. When you want to ungroup, select the plus
symbol at the left

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"STEVEN" wrote in message
...
Ho do I hide multiple rows under one row in excel ?
How do I see agan multiple rows hidden under one rwo ?

bala_vb

Quote:

Originally Posted by trip_to_tokyo[_3_] (Post 951921)

A method playing with heights of the rows:

Select rows 4 to 7 and right click, give row height equal to 0.1
now rows 4 to 7 are not visible (just hidden)

Next time to unhide them (to make visible)
follow the same procedure, select rows from 3 to 7 and right click, give row height equal to 15. (now they are visible).

PS: in this scenario, unhide wont work.

All times are GMT +1. The time now is 06:15 AM.