Freeze Column A and Rows 1:3

[Luke777]

Hi,

Simple as what's in the title. Is freezing Column A AND Rows 1:3 Possible?

I can't seem to get it to work with the usual way of freezing panes and I would very much like to utilize a floating header and side bar

It seems to be possible to freeze them individually or do the thing where the panes are quadrants of the sheet... what I'd like seems very similar to the quadrant pane, only repositioning the cross over point in the middle

Thanks

 

[Peter_SSs]

only repositioning the cross over point in the middle

What exactly do you mean by that?

In what way is selecting cell B4 and then freezing panes not working for you?

 

[Luke777]

What exactly do you mean by that?

In what way is selecting cell B4 and then freezing panes not working for you?

Well now I just feel like an idiot lol

I was selecting the entire rows/columns as needed, and it doesn't work like that apparently.

Totally my fault for misusing the Freeze Panes tool. I feel rather embarrassed at being confounded by something so simple.

Thank you for clearing this up for me though

Think I'm in dire need of a coffee this morning...

 

[Peter_SSs]

You're welcome. Don't worry about it - that's what the extra eyes on the forum are for.