Episode 772 - Landscape Page Numbers

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!

Episode 690 - Page Setup

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!

Episode 354 - Page 3 of 12

Are you frustrated that as you print each worksheet in a workbook, the page numbers constantly start over at page 1? Use Group mode to have your page numbers appear correctly when printing many sheets. Episode 354 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!