Can I freeze top pane and first column simultaneously?

makaveli80 · #1 04-05-2018, 06:13 AM

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

Dimitri001 · #2 04-05-2018, 06:16 AM

Quote:

Originally Posted by makaveli80

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

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Freeze top row and column in the same sheet.	village	Excel	3	11-26-2016 08:40 AM
unfreeze command not in view freeze pane drop down menu	almart	Excel	1	01-24-2015 11:12 PM
Freeze Pane isn't working properly	ep2002	Excel	1	07-27-2014 06:53 PM
Freeze more than just the top row, or first column	Gary Drumm	Excel	4	07-23-2013 11:34 AM
Possible to freeze both a column and a row?	bryanarn	Excel	2	03-11-2012 09:54 AM