Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Need to be able to hide and pull-down rows

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    362
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On my spreadsheet i list computer configurations. Each configuration consists of 2 things;

    1.A header line (eg: Dell Poweredge Server, Config#1) - Cell number a2
    2.The individual components that are installed within the Dell Poweredge system (eg:Kingston memory, 18GB HDD, Sony CD, etc - cell numbers a3,a4,a5,a6,etc).

    Each component will have it's own row but, i would like to have the component rows somehow collapse or hide under the main header line until i am ready to pull them out. I need to save space on my spreadsheet and do not need the component rows to show all the time. But, i do need them to be printable when i do pull them out.

    Please advise.

    Thx,
    Noir

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    =ActiveCell.Address
    Posts
    478
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi there,

    A simple solution would be to put a character in column B (or some other column) and then autofilter on that. For example enter a 1 on each of your header rows. If you don't want to see these characters, make the font white and exclude the column from the print area.

    Hope this helps.

    Rgds
    Alex

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    362
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the suggestion Alex, i'll try it.

    Noir

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

    Good one AJ !


    Also, there's "grouping".....

    First : highlight the first range of details rows that you want to hide under your first product

    then from the menus :

    data
    group and outline
    group

    second: repeat this for all your detailed rows under your products

    Excel will insert a [1] and a [2] in your left margin and underneath with show the scope of your new groupings - nothing much looks different at this point, but when you click on the [1] at the top, it consatinas your spreadsheet into just the product headers you are interested in

    a very useful tool : it also works horizontally

    handy for grouping months by quarter if you want to then hide then, or account numbers into balance sheet, income, salary, expense and suspense accounts then hide the detail


    :: Pharma Z - Family drugstore ::

Some videos you may like

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
  •