Results 1 to 2 of 2

Thread: How do you get rows to 'hang' below frozen rows at top as I scroll down ?

  1. #1
    Neophyte jeffh's Avatar
    Join Date
    Mar 2019
    Posts
    1
    Articles
    0
    Excel Version
    2016

    How do you get rows to 'hang' below frozen rows at top as I scroll down ?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have Rows 1,2 and 3 frozen, but when I scroll down, I want Rows 33-37, Row 43 and Row 53 to freeze when they reach to top so eventually I have Rows 1,2,3,33-37, 43 and 53 frozen at the top. Then as I scroll up they will automatically unfreeze leaving just Rows 1 to 3 at the top.

  2. #2
    Seeker Heyjoe's Avatar
    Join Date
    Jan 2019
    Posts
    19
    Articles
    0
    Excel Version
    2019
    I don't think this is possible.

    I would hide the rows that you want to hide. Then go to the View menu and insert a custom view. Then create another custom view to unhide the rows.

Tags for this Thread

Posting Permissions

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