There is a new podcast featuring my Excel tips. Learn about this podcast and also see how to repeat your title rows at the top of each printed page. Episode 969 shows you how.
This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Hey, welcome back to the MrExcel netcast.
I am Bill Jelen.
Basically, we start out with massive amount of data.
How we're going to analyze as well plus file up a pivot table.
Let’s see if we can solve this problem.
Hey, welcome back to the MrExcel netcast.
I am Bill Jelen.
Hey, I have something cool to show you today.
I'm here in the iTunes store.
Click on Podcast and then up here in the search, I want you to type this is all one word OnHomeAndoffice Click Enter, and you're going to see a brand new PODCAST.
This is put out by Itunes.
Pearson is my publisher.
And what you're going to find.
There is several different podcasts of me there.
MrExcel Podcast basically, but they're nice.
They're in high def.
We film these down in Virginia last year, So, if you like the Mr.Excel podcast go ahead and check this out.
I think it's going to come out about once a week although.
There's maybe four or five episodes out there, So, another dose of excel tips each week.
Nice high def podcast.
kind of makes me realize that with my $30 webcam here and..
Anyway, nice nice Podcast check it out.
Okay, so yesterday, We talked about how to make sure that these headings always appear.
But as I reread the question, I started to realize that he might be talking about making these appear on the printed page.
So, that's a completely different issue.
Let's take a look at this.
We have titles up here in row 1 and headings in row 3.
And the person who asked the question, mack 83 said, "I'm typing the headings again and again and again".
And that made me think that he's typing those headings in order to get them to print.
So, if we're trying to make them print on the first row, you know I have to tell you I have this big print titles thing here.
But I'm really so focused on the way we did in Excel 2003.
I always use this tiny little icon.
This icon is called the dialog launcher.
And it's a great way in excel 2007.
Go go back to the old Excel 2003 dialog box.
Here on the fourth tab, the sheet tab, Rows to repeat at top: we can basically just Highlight Rows 1, 2, 3 and if you want to repeat a certain column at the left, highlight Column A and when we click OK..
Now, in the print preview, We will see that it prints rows 1, 2, 3 at the top of every single page.
Certainly no need to go through and reset that print titles.
This is the new way to do it.
I guess that's actually a faster way to get back to the exact same spot that I did.
Want to show off their that the dialogue launchers, these great little icons in the bottom of many groups and the Ribbon.
Great way!
To very quickly get back to the dialog box that you know and love from Excel 2003 Alright!
Hey, I want to thank you for stopping by.
Don't forget to check out the OnHomeAndOffice podcast.
I am Bill Jelen.
We'll see you next time for another netcast from MrExcel.
I am Bill Jelen.
Basically, we start out with massive amount of data.
How we're going to analyze as well plus file up a pivot table.
Let’s see if we can solve this problem.
Hey, welcome back to the MrExcel netcast.
I am Bill Jelen.
Hey, I have something cool to show you today.
I'm here in the iTunes store.
Click on Podcast and then up here in the search, I want you to type this is all one word OnHomeAndoffice Click Enter, and you're going to see a brand new PODCAST.
This is put out by Itunes.
Pearson is my publisher.
And what you're going to find.
There is several different podcasts of me there.
MrExcel Podcast basically, but they're nice.
They're in high def.
We film these down in Virginia last year, So, if you like the Mr.Excel podcast go ahead and check this out.
I think it's going to come out about once a week although.
There's maybe four or five episodes out there, So, another dose of excel tips each week.
Nice high def podcast.
kind of makes me realize that with my $30 webcam here and..
Anyway, nice nice Podcast check it out.
Okay, so yesterday, We talked about how to make sure that these headings always appear.
But as I reread the question, I started to realize that he might be talking about making these appear on the printed page.
So, that's a completely different issue.
Let's take a look at this.
We have titles up here in row 1 and headings in row 3.
And the person who asked the question, mack 83 said, "I'm typing the headings again and again and again".
And that made me think that he's typing those headings in order to get them to print.
So, if we're trying to make them print on the first row, you know I have to tell you I have this big print titles thing here.
But I'm really so focused on the way we did in Excel 2003.
I always use this tiny little icon.
This icon is called the dialog launcher.
And it's a great way in excel 2007.
Go go back to the old Excel 2003 dialog box.
Here on the fourth tab, the sheet tab, Rows to repeat at top: we can basically just Highlight Rows 1, 2, 3 and if you want to repeat a certain column at the left, highlight Column A and when we click OK..
Now, in the print preview, We will see that it prints rows 1, 2, 3 at the top of every single page.
Certainly no need to go through and reset that print titles.
This is the new way to do it.
I guess that's actually a faster way to get back to the exact same spot that I did.
Want to show off their that the dialogue launchers, these great little icons in the bottom of many groups and the Ribbon.
Great way!
To very quickly get back to the dialog box that you know and love from Excel 2003 Alright!
Hey, I want to thank you for stopping by.
Don't forget to check out the OnHomeAndOffice podcast.
I am Bill Jelen.
We'll see you next time for another netcast from MrExcel.
