Daily tips for using Microsoft Excel.

Friday, February 15, 2002

Roy asks "Can you freeze rows and columns at the same time. Say for instance you
have the following scenario:

Cell B1 Fname
Cell C1 Mname
Cell D1 Lname
Cell E1 Address

Cell A2 Paid
Cell A3 Paid By
Cell A4 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