Feb 28 2019 08:57 AM
Feb 28 2019 08:57 AM
I just need to freeze the top 3 rows in a spreadsheet. Easy: select the 4th row, click 'Freeze Panes' and choose the 'Freeze rows' option. Except that the option isn't there - the only option offered is to freeze the top row.
I am using Office 365, so my Excel is a current version. And I am working in Normal View. So I don't understand why I cannot freeze multiple rows any more!
Feb 28 2019 09:29 AM
Unfreeze the rows/columns. Then if you want to freeze more than the top and more than the first column, go to the cell below the row you want to freeze and after the column you want to freeze and the select Freezes panes.
Feb 28 2019 01:41 PMSolution
Absolutely brilliant. Thank you so much. I've used Excel for more than 20 years and I'm pretty sure this method is new - or, at least, newish. But it's great to find out there really is a way. Thank you for pointing the way.
Feb 26 2020 08:45 AM
@Tanya Denton That response works fine if you want to freeze rows and columns. But I can't find any way to freeze a specific row, no columns. I use data sheets with headings on the second row and I need them visible when I scroll down. Used to be so easy in old Office. Please help me as this is crucial in my work. thanks!
Feb 08 2021 04:09 AM
I have used excel for well over 40 years and I am advanced in excel and I use to be able to freeze what ever columns and rows I wanted and with my office 365 I have not been able to....I really think this needs a 2nd look at fixing the problem. My 365 will ONLY freeze the 1st row and that is a real problem for me. Can you take a 2nd look please.
Thank you, Patty
Jul 14 2021 06:12 PM - edited Jul 14 2021 06:19 PM
I was having major problems too, but I just worked it out! @aaaaccountingnet. You only need to select one cell below the row and after the columns eg. I want A-C columns to stay, and 1-2 rows to stay. I first of all Unfreeze everything, then select D3 and Freeze frame. This worked thank goodness!
Aug 18 2021 06:58 AM