|
Freeze Panes in Excel
So you’ve got this “monster” spreadsheet in Microsoft Excel that you are using for your gradebook(s) for your overloaded classes, right? In fact, it’s so huge that by the time you scroll down to find a student, you can’t tell what’s what anymore because your column heading labels (“Test 1,” “Test 2,” “Essay 1,” etc.) have “disappeared” at the top. So you keep scrolling up and down and up and down and trying to hold your finger on the screen in just the right place so you can find the cell you’re looking for. (All the while leaving greasy fingerprints on your computer screen!) Well, what you need is “Freeze Panes.” It’s a way to lock a portion of rows of your spreadsheet so that they don’t move, even when you scroll down the page. That way, you always see your column headings no matter how far down you scroll. Here’s how it works… Freeze Panes If you have a large worksheet with column and row headings, those headings will disappear as the worksheet is scrolled. By using the Freeze Panes feature, the headings can be visible at all times.
Freeze Panes has been added to row 1 in the image below. Notice that the row numbers skip from 1 to 4. As the worksheet is scrolled, row 1 will remain stationary while the remaining rows will move.
Someone
asked: “Now how do you get the frozen frame to print at the top of
each page with a multi page spreadsheet?”
James Smith |
