I believe it is possible to freeze the first column and the top row simultaneously, but I can't find a way to freeze the top pane (4 rows, in my case) and the first column simultaneously. Is this possible?

I believe if you go to View and do Freeze Pane after you select B5, it will freeze the first row, and everything before B5 which would be all the data up to B4

take a look at the attachment for example

Attached Files

freezepane.xlsx (12.0 KB, 9 views)

Yes, I figured that part out, but what I need is the rows up to 5 frozen, but also, simulatneously, for the first column to be frozen.

What I find is that I can only get it to do one at a time. If I freeze the pane and then click freeze first column, it will freeze the first column, but unfreeze the pane.

You select a cell, and then from menu Freeze Panes!

All rows what are above selected cell are freezed;
And all columns what are left at selected cell are freezed!

Obviously you selected A5 instead of B5!

And be sure you have scrolled the page to start (at top and at left), otherwise can happen, that you don't see some freezed columns/rows anymore unless you unfreeze page!

Another issue newbies sometime have is, that they scroll the sheet to start, but forget to select the cell, leaving the cursor active somewhere near AA100. And then can't understand, how they can't to scroll the page at all :-)