Wednesday, November 30, 2016

Excel Tip - Viewing a Worksheet

I have worked as an IT trainer for over 12 years. During those years I conducted a lot of classroom training, but I also did a lot of one-on-one. Here is one of my stories.

I often had what I would call “open project days.” My office had a conference table that could seat 4 people comfortably. 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.

Go to the View tab - Freeze Panes.

No comments:

Post a Comment