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

S

STEVEN

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

trip_to_tokyo

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.
 
A

Ashish Mathur

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tracked changes by multiple people modified to one 0
Excel --> Word 4
Hide columns based on row values 2
Embed the same Excel multiple times 0
Function in Excel to count and list number of entries of text valuesin a row. 2
Integrating information from Word to Excel (not mail merge) 1
12 columns by 8 rows to one row 1
Need Help with a VBA subroutine 0

Top