Excel "Freezing" multiple rows in Excel (not the typical)


Joined
Aug 5, 2010
Messages
2
Reaction score
0
*Don't Disregard*

Now, I generally consider myself somewhat excel savvy and completely understand the concept of freezing panes or using the split panels. However, the other day I came across a spreadsheet that allowed for multiple headings to be "frozen" as you scrolled down the page. It reminded me of how the iPhone's contact screen works and as you scroll down alphabetically you retain the "A" heading for all of the A contacts, and as you keep scrolling the "B" heading once you reach contacts which start with the letter B. [See images attached]

Now I imagine this is not referred to as "freezing" panes any more, but I could not figure out to configure my spreadsheets to work in this manner. Any thoughts?

Thanks!
 

Attachments

  • IMG_0716.PNG
    IMG_0716.PNG
    29.1 KB · Views: 328
  • IMG_0717.PNG
    IMG_0717.PNG
    30.4 KB · Views: 346
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top