Topics Search

Excel 2007 Page Layout

Excel 2007 Page Layout
Views: 27
The Excel 2007 Page Layout tab in Excel lets you make changes to the overall page, including margins, colors, printing and views.
Sponsored Links:

More topics

 

Excel 2007 Page Setup

Preview
In the Excel 2007 Page Setup section of the page layout tab the first button is Margins. Click the down arrow to see the default selections. These are the margins that you need to set for printing your document.
 

Excel View Options - Page Layout, Page Break and Normal View

Preview
The Excel View options allow you to view or see the spreadsheet differently. You can adjust the Excel window to suit what you are currently working on by changing the view to match your current task.
 

Excel 2007 Scale to fit

Preview
Excel 2007 Scale to Fit section allows you to adjust how large you want your spreadsheet to be on the printed page. There are 2 ways of working with these features. If you prefer to make changes in a window click the little diagonal arrow in the lower right hand corner. This will open the Page Setup window with the Page tab already selected. You can make changes to the scale of your spreadsheet in the scaling section of this tab.
 

Excel 2007 Setting Up Your Excel Environment

Preview
Before you begin creating spreadsheets in Excel, you may want to set up your Excel environment and become familiar with a few key tasks and features such as how to minimize and maximize the Ribbon, configure the Quick Access toolbar, switch page views, and access your Excel options.
 

Excel 2007 Template

Preview
Templates are predesigned and formatted spreadsheets, the provide consistency of layout's structure and save time and repetition of work. Frequently when working with spreadsheets you want to use the same layout or design.
 

Scale your spreadsheet to fit on one page when printing from Excel

Preview
You can use the Scaling option in Page Setup to set limits on how many pages wide and tall your document should be when you print it. The problem with that is that you can find your page fits onto one page, but becomes too small to read. Not only that, but Excel ignores any manual page breaks you've entered. This lesson explains how you can print your spreadsheet so it automatically scales to be one page wide without forcing the rows into a single page.
 

Excel Printing Workbooks

Preview
When you finish compiling your worksheet, you will probably want to print a hard copy or e-mail a copy to someone else. This tutorial shows you a number of Excel tools you can use to improve your document layout, including headers, footers, page orientation, and margins.
 

Excel 2007 Printing Workbooks

Preview
In Excel, there are many things you can do to prepare your workbook for printing. Many of these tasks make it easier to format the spreadsheet for the printed page.
In this lesson you will learn how to view the spreadsheet in print preview, modify margins, change the page orientation, use the scale to fit feature, use the Print Titles command, insert breaks, and more.
 

Excel 2007 Sheet Options

Preview
This section is Excel 2007 Sheet Options. You click the diagonal arrow at the lower right corner of the sheet Options section to open the Page Set up Window to the Sheet tab. Then you can make the modification in the Print section.
 

How to use Headers and footers in Excel Printouts

Preview
In this video you will learn how to: Add or change the header or footer text in Page Layout view. Add or change the header or footer text in the Page Setup dialog box.