HELP -- tables...
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: HELP -- tables...

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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 ]

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  4. #4
    New Member
    Join Date
    Feb 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 !!!!!

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  7. #7
    Guest

    Default

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

  8. #8
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    As Chris said, under the 'Data' menu heading on the main toolbar.

    [ This Message was edited by: Mudface on 2002-02-28 04:07 ]

  9. #9
    New Member
    Join Date
    Feb 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  10. #10
    New Member
    Join Date
    Feb 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com