expandable areas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Excel can I hide a certain number of rows but make them expandable, like
the menu system that is used on the left here? I keep track of tasks and
they are separated into weeks. Each week may have 30 rows and I would like
to collapse them into a single row and be able to easily expanf them back if
needed.

THanks
 
Hi

check out
data / group and outline

select the rows for the weeks under your first task and choose data / group
and outline / group
etc

Cheers
JulieD
 
You must log in or register to reply here.

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

Prevent Collapsing of Pivot Table Rows 2
What determines collapsing of rows? 2
Grouping data and protecting worksheets 5
Excel pivot tables and SSAS 2
Hiding/Expanding rows in Excel? 6
Grouping will not work 1
Contacts keep expanding 3
Excel EXCEL - using a date dependant formula to hide rows 3

Back
Top