Shrink and expand a number of columns/rows

G

Guest

Hi,

There is a functionality that I would like to use in Exccel but don't know
how/where to find it.

I know you can expand and "shrink" information in your worksheet by
introducing a function that will allow you to click in a "+" simbol to expand
the information in that category or "-" simbol to shrink it.

Lets say you have the year divided in 52 seeks (Week1, 2, 3...) and then
inside each week, all the weekdays listed with relevant informastion to you.
If you only want to see the totals by week instead of every single day in the
year, you can split the information in 52 weeks (each week with their own "+"
simbol) and then when you press the "+" simbold you acces the information for
each day.

Does anyone know how to do this??? I am using Excel 2002

Thanks

Jav
 

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

Top