MrExcel's Learn Excel #690 - Page Setup

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 Feb 19, 2009.
Can you specify rows to repeat at the bottom? Can you specify columns to repeat at the right? Can you have a dynamic page number in the "rows to repeat at top" area? If you are asking these questions, I think you need to investigate the Page Setup Header/Footer tab. It will solve most of these questions. Episode 690 shows you how.

This blog is the video 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!
maxresdefault.jpg


Transcript of the video:
Hey Welome bak to the MrExcel netcast. I'm Bill Jelen.
A couple of questions sent in today about the page set up.
We're going to "File" "Page Setup", and we say that we want to have a certain rows to repeat at top for example, rows 1 through 3 Someone said well, hey can we always have certain rows repeat at the bottom or certain columns repeat at right. No. Excel will only let you repeat at the top and the left.
And then the second question said well in my "Rows to repeat a top", I have a page number, how do I make that dynamically change on each page and I think we're trying to use the wrong thing here. If we go into "File" "Page Setup" Let's go to the Header/Footer tab and in the "Custom Header" we can choose that we want to see page, you know, whatever page 1 2 3 4 5 and that shows up in the header, and then we don't need to have that showing up over here in cell A1, we can actually get rid of that.
So we can get rid of it here and then when we look in "Page Break Preview" There is page 1 and then page 2.
Now ofcourse we have a header and we have a footer.
So you can actually have something repeat at the bottom of every page.
Don't have any good way to repeat columns at the right of each page, but by using header and footer, we can certainly use the top and the bottom and it'll be a dynamic page number that will change from page to page to page.
You know so many times in excel there's many different ways to do things and it appears that using that area to print the top rows to repeat at top might be a good way to put a page number in.
But when you get right down to it. There's another way The header and footer which are you know actually better in this particular case. I hope that helps.
Thanks to you for stopping by. I'll see you next time for another net cast from MrExcel.
 

Forum statistics

Threads
1,213,561
Messages
6,114,317
Members
448,564
Latest member
ED38

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
Back
Top