Freeze Columns and Rows in Excel

My years working as an IT trainer, I’ve helped with many issues. One of the most common had to do with data entry and knowing what heading (column) the data was being added to.  

My office had a conference table that could seat 4 people comfortably. I often had what I would call “open project days.” Anyone could come in on those days and work on their Excel project and I was there to answer any questions. Sometimes people just used this to get away from their desks, but I never went through one of those days without being of some assistance. It usually did not happen in the form of a question, but rather an exclamation of frustration.
Jeanie mumbled “There are so many date columns, I can’t remember what goes where.”
“Do you not have headings?” I questioned, misunderstanding.
“Of course, I have headings, but when I scroll down to enter data, I can’t see my heading,” she responded in a frustrated tone.
“I have a cure for that,” I said as I walked over.

Here is what I showed Jeanie to make her data entry a little easier – Freeze Panes

Freeze panes allows you to lock specific rows and columns so that they will always be visible on screen no matter how far you scroll to the right or down.

From the View Tab – Freeze Panes

From the drop down menu you have three selections: Freeze Panes, Freeze Top Row and Freeze First Column. 

Freeze Top Row and Freeze First Column are just as they say. Row 1 and Column A will freeze. 

With Freeze Panes, you must be aware of what cell you are actively in. Everything above and to the left of the active cell will freeze.

For example, if you want rows 1 and 2 to freeze, you need to actively be in cell A3. 

If you want column A and B and row 1 to freeze, you need to actively be in cell C2. 

Leave a Reply

Your email address will not be published. Required fields are marked *