Freeze Panes for Select Rows and Columns

February 15, 2002 - by Juan Pablo Gonzalez

Roy asks:

Can you freeze rows and columns at the same time? Say for instance you have the following scenario:

	A	B	C	D	E
1		FName	MName	LNAme	Address
2	Paid
3	Paid By
4	Date

Can you freeze this heading going across and down at the same time where only the data scrolls. Which ever direction I scroll I will lose one set of the heading. They both will not stay on the screen all the time. NO ONE ELSE CAN FIGURE IT OUT.

Select B2, and go to Window, Freeze Panes... Row 1 and Column A should be frozen