Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
balles
 
Posts: n/a
Default Shrink and expand a number of columns/rows

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj
 
Posts: n/a
Default Shrink and expand a number of columns/rows

<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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 08:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"