none
Page set up, show specific rows, as scroll RRS feed

  • Question

  • Good morning all.

    I have a spreadsheet, which is set up with groupings of data.

    The standard set up is to be able to freeze frames, having a row, or group of rows--- typically consecutively numbered--- 

    "rows to repeat at top: $1:$..."

    As I scroll down, I'd like to show the row header of each grouping.

    Eg.,

    rows to repeat at top: .....

    for row grouping, 1- 5, repeat row 1.

    for row grouping 6 - 11, repeat row 6.

    for row grouping 12 - 18, repeat row 12.

    etc.......

    Is this possible? If so, how would I accomplish it? 

    I've done this manually--- selecting each row of interest, and I get back a warning which states the rows must be contiguous, and complete rows. Granted, this is page setup for printing, which is not what I want. I want to freeze-frames, showing those specific groupings, with the row header for each. 

    eg.,

    TYIA.

    Thursday, March 10, 2016 6:20 PM

Answers

  • SDB1,
    Re:  multiple scrolling areas on a worksheet

    You cannot freeze non-contiguous areas on a worksheet, as you found out.

    You can "group" data on a worksheet, which will allow you to hide or show rows below multiple headers.
    In xl2003, find "Group and Outline" on the Data menu (I dont have xl2010 open at the moment).

    You could put multiple ActiveX  dropdown controls on the worksheet; some allow scrolling of the displayed data.
    -or-
    If you have lots of time to experiment (waste) you could review my efforts on custom scrolling areas found here...
    http://blog.contextures.com/archives/2013/04/18/click-to-move-excel-list-items-up-or-down/
    '---
    Jim Cone
    Portland, Oregon USA
    https://goo.gl/IUQUN2
     (Dropbox)

    (free & commercial excel add-ins & workbooks)


    • Marked as answer by David_JunFeng Monday, March 21, 2016 2:19 PM
    • Edited by James Cone Monday, October 31, 2016 3:25 PM
    Friday, March 11, 2016 5:06 AM

All replies

  • SDB1,
    Re:  multiple scrolling areas on a worksheet

    You cannot freeze non-contiguous areas on a worksheet, as you found out.

    You can "group" data on a worksheet, which will allow you to hide or show rows below multiple headers.
    In xl2003, find "Group and Outline" on the Data menu (I dont have xl2010 open at the moment).

    You could put multiple ActiveX  dropdown controls on the worksheet; some allow scrolling of the displayed data.
    -or-
    If you have lots of time to experiment (waste) you could review my efforts on custom scrolling areas found here...
    http://blog.contextures.com/archives/2013/04/18/click-to-move-excel-list-items-up-or-down/
    '---
    Jim Cone
    Portland, Oregon USA
    https://goo.gl/IUQUN2
     (Dropbox)

    (free & commercial excel add-ins & workbooks)


    • Marked as answer by David_JunFeng Monday, March 21, 2016 2:19 PM
    • Edited by James Cone Monday, October 31, 2016 3:25 PM
    Friday, March 11, 2016 5:06 AM
  • SDB1,
    Re:  multiple scrolling areas on a worksheet

    You cannot freeze non-contiguous areas on a worksheet, as you found out.

    You can "group" data on a worksheet, which will allow you to hide or show rows below multiple headers.
    In xl2003, find "Group and Outline" on the Data menu (I dont have xl2010 open at the moment).

    You could put multiple ActiveX  dropdown controls on the worksheet; some allow scrolling of the displayed data.
    -or-
    If you have lots of time to experiment (waste) you could review my efforts on custom scrolling areas found here...
    http://blog.contextures.com/archives/2013/04/18/click-to-move-excel-list-items-up-or-down/

    '---
    Jim Cone
    Portland, Oregon USA
    free & commercial excel add-in programs  (xl97 to xl2010 only)
    http://jmp.sh/K95N3ee

    Hi Jim.

    Long time no "see." 

    Thank you for your response. I will review your webpage, and see what I can find that will allow me to create a solution to my liking. It's more a matter of convenience than necessity, but it was something I'd wanted to see if I could accomplish.

    Have a great day.

    Best.

    Friday, March 11, 2016 5:28 PM
  • Hi, SteveDB1

    Have you resolved your issue?

    Wednesday, March 16, 2016 9:05 AM
  • Hi, SteveDB1

    Have you resolved your issue?


    Hi David.

    Not as I'd liked to have.

    But according to Jim Cone's response, it appears that I'm not able to do this the way that I'd wanted.

    Monday, May 2, 2016 2:53 AM
  • SteveDB1

    re: multiple freeze areas

    You still cannot freeze multiple areas, but...
    I've completely rewritten my 'custom scroll area' workbook.
    (uses a completely different approach - only restriction is no merged cells)
    It might be more suitable for your need.
    '---

    Jim Cone
    Portland, Oregon USA
    https://goo.gl/IUQUN2 (Dropbox)
    (free & commercial excel add-ins & workbooks)

    • Edited by James Cone Monday, October 31, 2016 3:23 PM
    Monday, May 2, 2016 3:10 AM