Freeze Multiple Row

[zoey2]

Hi I am trying to freeze multiple rows in excel. I select the rows and columns I want to freeze then go to Freeze Panes-> Freeze Panes but it just freezes the first row. How can I freeze multiple rows.

 

[rizwan_planning]

Check the active cell, it should be just below or ahead the rows or column need to be freezes

 

[MrIfOnly]

Let's say you want to freeze rows 1 - 5, and columns A-C: select cell D6 (one over and one down from what you would like to freeze), then select 'Freeze Panes' from the ribbon.

CJ