Hi, I'm Dawn Bjork, The Software Pro. In this training,
we'll look at how to more easily work with your Excel worksheets by applying
Freeze Panes.
We'll also look at the differences between Freeze Panes and Print Titles.
One of the challenges of larger worksheets is that as you start moving around a
worksheet, for instance, if I move to the bottom,
I lose track of the column headings or the row labels. And,
by the way, this is all pretend information.
So let's look at how Freeze Panes can make it much easier for you to keep that
information on the screen. As an easy reference,
we find this under View and here is Freeze Panes.
Now one solution for a worksheet like this is that I could simply say,
Freeze Top row. If I Freeze Top Row, now, as I move down,
you can see that the rows are changing,
but that top row is frozen or locked on the screen.
However, I still have a problem because as I move to the right,
I no longer am seeing some of the identifying information for
these individuals. To turn off Freeze Panes, repeat View,
Freeze Panes, and here I can Unfreeze.
So you can see that I can also freeze the first column. Well,
let's get a little bit more specific.
What I'd really like to do is have these first three columns
visible on the screen, and I want this top row to be visible.
So if you need to,
orient your worksheets so that this information is visible.
Next, I'll move to the first moving cell. That is,
the way to look at this is to say everything to the left of this location
and above is going to be frozen or locked on the screen.
You'll still have access to the data and you can edit it,
but you're keeping it frozen or locked on the screen.
So the key is how you're positioned. After that,
it's very easy. We return back to View, Freeze Panes,
and choose Freeze Panes. Now,
as I move down, I'll move to the bottom of this column.
I can still see that column heading.
And as I move to the right,
I still see the key references here in these first three
columns so that I know that I'm looking at the right information.
Now, when I press CTRL+HOME,
rather than taking me to the first cell of the worksheet,
it takes me to the first movable cell within the worksheet.
And that's how you create Freeze Panes.
At any time you can return to Freeze Panes and
Unfreeze.
It's helpful to know that Freeze Panes is for the display of your worksheet.
If you want to duplicate this layout for printing, that's Print Titles,
and they don't talk to each other.
So let's look at this from a printing perspective,
I'll move into print and you can see with this,
as I currently navigate through this worksheet,
I've lost the column headings and my row labels.
So how do we create Print Titles?
We find that under Page Layout and here is Print
Titles.
Now I don't have to repeat the same rows and columns that I used for Freeze
Panes, because they're not connected to each other. In this case, however,
I will click into, and in the Sheet tab here,
rows to repeat at top and I'll click into row one.
You'll see that Excel will automatically populate that with this
reference. Columns to repeat at left,
and I don't have to do the columns, but in this case,
I'll highlight from A to C. So these are my Print Titles that
I want to repeat on every page,
whether I'm printing to a physical printer or perhaps to a PDF.
Let's go ahead and look at the print preview page one looks the same,
but now here's page two. The column labels are visible.
And as I continue,
I now have that reference to the first three columns so that I know
that I am accurately looking at the right row of information.
Try Freeze Panes to lock in the display and Print Titles when
you want to repeat the rows and/or the columns for
printing. Now,
you've seen how to save ime and effort in Excel by applying Freeze Panes and
working with Print Titles.
For more tips on being productive with Microsoft Excel,
or to sign up for my tips newsletter, visit TheSoftwarePro.com/Excel.
If this training was helpful,
please like this video and subscribe to this channel. This is Dawn Bjork,
The Software Pro. Thanks for watching.
[Upbeat music]