More screen options


show more More screen options provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

More screen options

Included in the Windows group in the View tab are even more commands that help you manage the information that you see in your screen. The one we're going to take a look at now is your Freeze Panes options. We've already viewed how this works in a larger spreadsheet, but let's take a look at how it works when we're in a paned environment. I'm going to select the very first pane here and I'm going to click on cell B2, the Chocolate, because that's where I want to freeze my information. As I select that cell, I go back up to Freeze Panes and I have three choices; I could freeze the pane that would freeze the top row and the first column, I could just freeze the top row, or I could freeze just the first column. I'm going to freeze both, the first column and the first row by selecting the very first choice here.

And you'll see that I have frozen it because there's a line now up underneath the first row as well as in the first column. And as I use my scr...

More screen options
Video duration: 5m 40s 5h 13m Beginner

Viewers:

More screen options provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...