Floating rows / freezing panes

joshhargs

New Member
Joined
Oct 9, 2017
Messages
3
Hello there everyone,

I have a sheet that is going to be an order form, it contains product codes, barcodes, product descriptions, prices, RRPs etc, with a lot of different products with a lot of different headings for each category etc. I would like the headers of each category to float on the row just below the frozen panes i already have at the top containing the info headings when scrolling down, until the next header is reached, at which point the header for the new section you're just about to scroll through will replace the one from the previous section. (Is everyone still with me here?)

I've tried selecting multiple rows and freezing the panes but that seems to select the highest up header and freeze that one only. Please note i do know what the freeze panes functionality is, i already have a couple frozen and that's not exactly what i'm after, essentially i want certain rows to be frozen at the top depending on which rows are visible to the user.

Could something like a looping macro be used to continuously unfreeze and freeze panes depending on which row is at the top of the page?
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Watch MrExcel Video

Forum statistics

Threads
1,122,530
Messages
5,596,699
Members
414,088
Latest member
rodriboraun

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top