Results 1 to 10 of 10
  1. #1
    3 Star Lounger
    Join Date
    Dec 2009
    Posts
    212
    Thanks
    36
    Thanked 0 Times in 0 Posts

    "freeze" ?? block of cells

    I have a spreadsheet with headers A1:E1 and corresponding data A2:E2 to A50:E50.
    I have a block of cells H2:K2 to H9:k9 [bordered & yellow] that holds calculations for this data. To keep the headers visible as I scroll down to latter entries, I froze the pane at row 2. When I scroll down, the headers remain but the block of cells [H2:K2 to H9:k9] move up and disappear. How can I keep them visible as I scroll as if to have them float in space or dissociate them with the row numbers or make the row numbers variable?
    Sample attached.
    Attached Files Attached Files

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Is it just me, or is your sample a blank file?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    3 Star Lounger
    Join Date
    Dec 2009
    Posts
    212
    Thanks
    36
    Thanked 0 Times in 0 Posts
    Rory,
    It is not you, it is me. I think I may have sent file before saving it and that may be the reason for blank file.
    New file attached.
    Attached Files Attached Files

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    I can think of three options, none of which I think are exactly what you want:
    1. Open a new window onto the worksheet and tile it next to your existing one.
    2. Use a userform with an image of your cells (or if you are on 2003 or earlier, use the OWC spreadsheet control)
    3. Use the built-in watch window from the Formula Auditing toolabr to watch the cells of interest (they appear line by line rather than as a grid though).
    Regards,
    Rory

    Microsoft MVP - Excel

  5. The Following User Says Thank You to rory For This Useful Post:

    skipro (2011-03-22)

  6. #5
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    In addition to the other suggestions, you could use the camera to show an image of the calculation block in a stretched Row 1
    (as per here)
    Attached Files Attached Files

  7. The Following User Says Thank You to Gfamily For This Useful Post:

    skipro (2011-03-22)

  8. #6
    4 Star Lounger pccoyle's Avatar
    Join Date
    Apr 2001
    Location
    Auckland, Auckland, New Zealand
    Posts
    535
    Thanks
    3
    Thanked 2 Times in 2 Posts
    You could say start your data in Row 11, and freeze the panes on Row 12 - this will then keep the yellow block visible.
    Paul Coyle
    Approach love and cooking with reckless abandon

  9. The Following User Says Thank You to pccoyle For This Useful Post:

    skipro (2011-03-22)

  10. #7
    New Lounger
    Join Date
    Mar 2011
    Posts
    20
    Thanks
    1
    Thanked 1 Time in 1 Post
    I Like the camera option. here's a save of the "split" window option.Copy of sample.xls

  11. The Following User Says Thank You to gumintwork For This Useful Post:

    skipro (2011-03-22)

  12. #8
    3 Star Lounger
    Join Date
    Dec 2009
    Posts
    212
    Thanks
    36
    Thanked 0 Times in 0 Posts
    Thank you to all who replied. You have given me options.

  13. #9
    3 Star Lounger
    Join Date
    Dec 2009
    Posts
    212
    Thanks
    36
    Thanked 0 Times in 0 Posts
    Can this be done horizontal, not vertically. Can the block be "frozen" to the right of the data, instead of above the data? Can I have a [separate] scroll that slides only the data to the left. I tried using "split" but could not get it to give me a separate vertical scroll, only additional horizontal scrolls.

  14. #10
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Nope - see my original post.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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