HELP -- tables...

[mdurukan]

Hi everybody,
I want to hide or unhide columns or rows in my tables by clicking on a button. But i do not want to make it by a macro, i can do it by a macro. But i've received a table fm someone and there was arrows at the columns and at the rows part. And u can hide or unhide the specific rows or columns by clicking those arrows. I do want to learn how he did that. I do not wanna ask to him because he does not like helping people....
thnxs for ur help...
This message was edited by mdurukan on 2002-02-27 05:18

 

[Audiojoe]

When you say arrows, do you mean auto-shapes?

 

[Mudface]

It sounds like he's either used the Autofilter (although I think that's just for columns) or grouped and outlined some of the data. Take a look at the Help files for these subjects.

 

[mdurukan]

On 2002-02-27 05:24, Audiojoe wrote:
When you say arrows, do you mean auto-shapes?

no no,
it is not the auto shapes...
hmmmm it is like a button when u click it it hides some columns or arrows; and after the second click it unhides them. but trust me its not an macro !!!!!

 

[Mudface]

It's the Group and Outline function, which allows you to show/ hide groups of data either by column or row.

 

[Chris Davison]

On 2002-02-27 07:15, Mudface wrote:
It's the Group and Outline function, which allows you to show/ hide groups of data either by column or row.

in cells A1 to A7, enter the following : John, Paul, George, Ringo, Mary, Mungo, Midge

in cells B2 to B7 enter the following : 1,2,3,4,5,6,7

in A8 enter "retros total"

in B8 enter "=sum(b1:b7)

then highlight rows 1 to 7, select "data" then "group and outline" then "group" and it should group that whole block which should look familiar to what you were clicking on before, as Mudface postulated.

It's handy for grouping sections that you may want to hide later on for reporting or aesthetic purposes.

That's vertically : it also works horizontally - handy for hiding individual column months to just show an annual figure.

Hope this makes sense
Chris

 

[Guest]

On 2002-02-27 12:19, Chris Davison wrote:

On 2002-02-27 07:15, Mudface wrote:
It's the Group and Outline function, which allows you to show/ hide groups of data either by column or row.

in cells A1 to A7, enter the following : John, Paul, George, Ringo, Mary, Mungo, Midge

in cells B2 to B7 enter the following : 1,2,3,4,5,6,7

in A8 enter "retros total"

in B8 enter "=sum(b1:b7)

then highlight rows 1 to 7, select "data" then "group and outline" then "group" and it should group that whole block which should look familiar to what you were clicking on before, as Mudface postulated.

It's handy for grouping sections that you may want to hide later on for reporting or aesthetic purposes.

That's vertically : it also works horizontally - handy for hiding individual column months to just show an annual figure.

Hope this makes sense
Chris

sorry but where is the "group and outline" and "group" functions...????

 

[Mudface]

As Chris said, under the 'Data' menu heading on the main toolbar.
This message was edited by Mudface on 2002-02-28 04:07

 

[mdurukan]

On 2002-02-28 04:02, Mudface wrote:
As Chris said, under the 'Data' menu heading on the main toolbar.
This message was edited by Mudface on 2002-02-28 04:07

oh!!!!!!
ok
thnxs a lot
that was the thing i was looking for
THANK U VERY MUCH...

 

[mdurukan]

On 2002-02-28 03:24, Anonymous wrote:

On 2002-02-27 12:19, Chris Davison wrote:

On 2002-02-27 07:15, Mudface wrote:
It's the Group and Outline function, which allows you to show/ hide groups of data either by column or row.

THNXS A LOT FOR UR HELP...
that was the thing i was looking for...

in cells A1 to A7, enter the following : John, Paul, George, Ringo, Mary, Mungo, Midge

in cells B2 to B7 enter the following : 1,2,3,4,5,6,7

in A8 enter "retros total"

in B8 enter "=sum(b1:b7)

then highlight rows 1 to 7, select "data" then "group and outline" then "group" and it should group that whole block which should look familiar to what you were clicking on before, as Mudface postulated.

It's handy for grouping sections that you may want to hide later on for reporting or aesthetic purposes.

That's vertically : it also works horizontally - handy for hiding individual column months to just show an annual figure.

Hope this makes sense
Chris

sorry but where is the "group and outline" and "group" functions...????