You are printing a multi-sheet workbook which is mostly portrait. In the middle, one worksheet needs to be landscape. You would like the page number to appear at the bottom of the portrait page like all of the other page numbers in the document. Episode 772 will show you the steps required to make this happen.
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!
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!
Transcript of the video:
Hey. Welcome back to the MrExcel netcast. I'm Bill Jelen.
Here's a question that came in during one of my seminars.
Let’s say that you have many worksheets in a workbook and you're going to print all these out into a nice report, but, right in the middle, you have one sheet that is landscape instead of portrait, and the page number on the landscape sheet ends up along the right edge of the document instead of at the bottom where it should be.
We have a great trick for this but it means not using the regular page numbering on this particular page.
First thing I want to do is figure out how many rows would fit on the page, and so I go into PRINT PREVIEW and I see that, sure enough, our data doesn't fill all the way down to the bottom.
Now, because I've used the FIT TO 1 PAGE WIDE BY 1 PAGE TALL, I'll never get to see where that bottom page break actually should be, but, a great trick, once you've done a print preview, you can click on ADJUST TO, and this number that used to be a 100 now shows exactly the right number.
96% will cause these columns which go across to fit to the page, and now, when I look at the document, I can see that row 39 is the last row.
So, here's our trick.
I'm going to insert a new tiny column A, use a column width of maybe 2, and then here, in cell A1, I'm going to put the right page number, so maybe page 7 of 12, and I'll select from A1 all the way down to the last row on the sheet -- so, that’s A39 -- and go into FORMAT, CELLS.
On the ALIGNMENT tab, I'm going to say that I want to MERGE CELLS.
I'm going to change the orientation to –90 and then choose CENTER for both HORIZONTAL and VERTICAL.
Click OK.
Now you'll see the page number appears there.
We also want to go, FILE, PAGE SETUP, and adjust the bottom margin to 0, so that way that page number fits down there where it should appear and match all the other page numbers.
Click OK.
Now, when we do a PRINT PREVIEW, you'll see that the page number will appear just like any other portrait page with a page number at the bottom.
Well, there you have it.
Great tip.
Thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
Here's a question that came in during one of my seminars.
Let’s say that you have many worksheets in a workbook and you're going to print all these out into a nice report, but, right in the middle, you have one sheet that is landscape instead of portrait, and the page number on the landscape sheet ends up along the right edge of the document instead of at the bottom where it should be.
We have a great trick for this but it means not using the regular page numbering on this particular page.
First thing I want to do is figure out how many rows would fit on the page, and so I go into PRINT PREVIEW and I see that, sure enough, our data doesn't fill all the way down to the bottom.
Now, because I've used the FIT TO 1 PAGE WIDE BY 1 PAGE TALL, I'll never get to see where that bottom page break actually should be, but, a great trick, once you've done a print preview, you can click on ADJUST TO, and this number that used to be a 100 now shows exactly the right number.
96% will cause these columns which go across to fit to the page, and now, when I look at the document, I can see that row 39 is the last row.
So, here's our trick.
I'm going to insert a new tiny column A, use a column width of maybe 2, and then here, in cell A1, I'm going to put the right page number, so maybe page 7 of 12, and I'll select from A1 all the way down to the last row on the sheet -- so, that’s A39 -- and go into FORMAT, CELLS.
On the ALIGNMENT tab, I'm going to say that I want to MERGE CELLS.
I'm going to change the orientation to –90 and then choose CENTER for both HORIZONTAL and VERTICAL.
Click OK.
Now you'll see the page number appears there.
We also want to go, FILE, PAGE SETUP, and adjust the bottom margin to 0, so that way that page number fits down there where it should appear and match all the other page numbers.
Click OK.
Now, when we do a PRINT PREVIEW, you'll see that the page number will appear just like any other portrait page with a page number at the bottom.
Well, there you have it.
Great tip.
Thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
