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.
04-05-2018, 06:16 AM
Similar Threads
Freeze top row and column in the same sheet.
Windows 10 
Office 2016
Threaded Mode