How to create multiple frozen rows on a worksheet

[NickieFrausto]

I have the following data and would like to be able to freeze the different section title rows so the user can easily scroll through the data instead of the whole document. 04.22.2016-12.39.03 - NickieDay's library

Is this possible?

Thank you

Nickie

 

[RickXL]

Hi and welcome to the MrExcel Message Board.

The short answer is that I don't think you can freeze multiple sections.

However, what you could do is create a UserForm and add three or four ListBoxes. The data in the ListBoxes can then be scrolled individually.

The easy way to identify the data in the worksheet is to make each set of data a Table. Just put your cursor in one and hit Ctrl + T and accept the default settings. You should end up with tables called: Table1, Table2 etc.
Note: Try this on a copy first because it changes the formatting colours.

In the ListBox settings select:

1. ColumnCount and insert the right number.
2. ColumnHeads = True
3. RowSource = Table1

Change the Table name for the later ListBoxes (Table2, Table3 etc).

You will probably need a Button to call up the UserForm.
You may need another UserForm if you want to edit the data from there.

I got a basic demo up and running in about five minutes but it might not be what you are looking for.

Regards,