 |
 |
| About MrExcel |
| Consulting Services |
| Learn Excel Resources |
| Challenge of the Month |
| MrExcel Seminars |
| MrExcel Store |
| Podcast |
| Search |
| Media |
| Contact |
| Home |
 |
The tip in this show is from Learn Excel 97-2007 From MrExcel.
(Click the book for more details)
Brianna Mcivor, Bill Jelen, and Leo Laporte on the set of The Lab with Leo
Excel 2007 introduces a new way to visualize your worksheet before you print it. See the actual white space, margins, headers, and footers right in the worksheet.
Check back in May 2008 to view my segment here.
Page Layout ViewExcel 2007 adds the new Page Layout View. To access this view, use the icon in the lower right of the Excel window:
In this mode, you can see the worksheet as it will print. You will see white space, headers, footers, etc.
To edit a header or footer, click in one of the 6 zones on each page, In the image above, the mouse pointer is above the right header.
When you are editing a header, you have a new Ribbon tab for Header & Footer Tools Design. This tab provides brand new settings for Excel 2007 such as having a
different heading for the first page or different for odd and even pages.
Tip: To have an ampersand appear in a header, use two ampersands!
To the right of the Page Layout icon, a new zoom slider lets you quickly adjust the zoom. If you zoom to 10%, you can see dozens of pages at once:
I really hope to give away 5 million copies of the book, so please send your co-workers and friends to
leobook.html.
MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.