Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
<data<group and outline
check "group" in help "balles" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|