HELP -- tables...

mdurukan · Feb 27th, 2002, 06:16 AM

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 · Feb 27th, 2002, 06:24 AM

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

Mudface · Feb 27th, 2002, 06:31 AM

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 · Feb 27th, 2002, 07:37 AM

Quote:

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 · Feb 27th, 2002, 08:15 AM

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

Chris Davison · Feb 27th, 2002, 01:19 PM

Quote:

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

Feb 28th, 2002, 04:24 AM

Quote:

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

Quote:

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 · Feb 28th, 2002, 05:02 AM

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 · Feb 28th, 2002, 07:55 AM

Quote:

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 · Feb 28th, 2002, 07:57 AM

Quote:

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

Quote:

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

Quote:

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...????

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 27th, 2002, 06:16 AM	#1
mdurukan New Member Join Date: Feb 2002 Posts: 10	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 ]

Feb 27th, 2002, 06:24 AM	#2
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	When you say arrows, do you mean auto-shapes?

Feb 27th, 2002, 06:31 AM	#3
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	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.

Feb 27th, 2002, 08:15 AM	#5
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	It's the Group and Outline function, which allows you to show/ hide groups of data either by column or row.

Feb 28th, 2002, 05:02 AM	#8
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	As Chris said, under the 'Data' menu heading on the main toolbar. [ This Message was edited by: Mudface on 2002-02-28 04:07 ]