"Don't Fear The Spreadsheet" - Freeze Panes in Excel: Podcast #1565

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Jun 26, 2012 .
Freeze Panes: What is it? It makes no sense. Today Bill looks at the Freeze Panes function of Excel and discusses its uses, what you can do and what you cannot do. Also, in Episode #1565, Bill shows us how to use the Print Dialogue in Excel to Repeat Header Rows and more.

"Don't Fear The Spreadsheet: A Beginner's Guide To Overcoming Excel's Frustrations" by Tyler Nash, Kevin Jones, Tom Urtis and Bill Jelen Don't Fear the Spreadsheet

"This Book Makes Excel For Dummies™ Look Like It Was Written For Rocket Scientists!"
maxresdefault.jpg


Transcript of the video:
Bill Jelen: Welcome back to the Don’t Fear the Spreadsheet Podcast.
This is Episode #3: Excel Freeze Panes.
Alright, well hey, this is the Don’t Fear the Spreadsheet Podcast, I’m Bill Jelen from MrExcel.
Today’s question: Tyler.
Tyler: Freeze panes?
What are panes and why would I want to make them cold?
Bill Jelen: Hey, Tyler.
Alright, what a funny name for a really useful, useful thing.
So, we have a long, long report here, alright?
And there’s headings at the top and you don’t want to have to repeat these headings every screen full of data so we can tell what’s going on.
So, freeze panes lets us solve that.
And now, to use freeze panes, we have to go to the very first cell that’s not going to be locked, alright?
So in this case, it’s probably cell A4.
Then we come here to the View tab, Freeze Panes, Freeze Panes – Now everything above that will become locked.
Everything to the left of that, which in this case is nothing, will become locked.
So now as I scroll down, you see I get to see these headings all the time.
Because, hey, wait a second.
Well now, I don’t need to see XYZ Company Sales Report.
That is not going to help.
So let me Unfreeze Panes and now I’m going to very carefully – I’m going to use the scroll, just scroll down so that way I can see row 3, I can’t see rows 1 and 2.
And then I’ll Freeze Panes from here and now I scroll down.
This solves the problem.
Of course now, the big issue is going to come when we decide later to print, Ctrl+P, those headings do not repeat.
So doing freeze panes does not help at all with the print- printing out.
You want to come here to Page Layout, Print Titles and specify that rows, 1:3, are going to repeat- be repeated at the top of every page.
Freeze pane, great when you’re just looking at the spreadsheet.
Print Titles is doing the same thing when you’re going to print the spreadsheet.
Tyler: Thanks for stopping by.
We’ll see you next episode.
Check out, Don’t Fear the Spreadsheet.
This book made itself for dummies, look like it was written for rocket scientists.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,359
Messages
5,641,647
Members
417,229
Latest member
BODYCOTE

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top