ULearnOffice.com

Navigation

Previous
Next
Homepage
FAQ
What's new
Sitemap

Topics

Introduction
Basic commands
Presentation
Page layout and printing
Functions
Copy, Paste and
relative and absolute references

Charts (graphics)
Macro commands
Analysis tools
Comments
Data list
Pivot table
Exercise: creating a model
Quiz

Tutorials

Word
Excel

Excel 2007/2010/2013
PowerPoint
Access

Others

Demonstration files
Texte en français

Contact

By e-mail
Join our Newsletter

Excel - Page setup and printing

Introduction
Page layout
Printing area
Printing
Page break
View page breaks

Introduction

Excel allows you to print your document as well as to add additional page layout options to your presentation. You can add a header or footer to a page, change the margins as well as several other options. This page shows you how to set-up your printout as well as the options for printing. You'll then be able to improve the presentation of your file on paper.

Page setup

The options of the page layout exist to improve the presentation of your document on paper. You can change the margins of sheets, add the headers, the footers and several other options that will be discussed below.

*From the File menu, select the Page setup option.

 

Under the Page tab, in the section Orientation, Excel asks you for the orientation of the pages to print.

In the scaling sections, you can manually change the size of your spreadsheet by reducing or increasing it. This is very practical when all the columns of you're worksheet should be on one page only. You can also ask Excel to find automatically the best size to enter your document on to X pages in widths and Y pages in height. At any time, you can look at the printout before printing by pressing the review button. You can also change the type of paper (letter size, legal, newspaper ...) as well as the quality of the printing. For printing in the computer lab, be sure that the paper size is always " US Letter ". The last option allows you to choose the page number that will begin the printout. For example, the first page of your printout could be numbered page 5 and so on.

 

Under the Margins tab, you can determine the margins, the width between the border of the page and your text, for the file as well as those for the header and the footer of the page. You can also choose to center horizontally and vertically your worksheet on the page. You can also determine the place for the header and the footer for the worksheet your about to print. The outline in the middle of the window gives you an idea of the effect of these choices on the paper.

Under the Header/Footer tab, you can determine what will be in the header and the footer of each of the pages of the printout. If you don't want a header or a footer, select the first option, "none", from the list of the predetermined options.

Personalize the header and footer.

It's sometimes useful to add a header or a footer to a document. It helps to identify the document and what it's supposed to represent. For example, a header with the title "Monthly revenues and expenses for May 2006" says it all. The next exercise consists in writing the name of the document, your name, as well as the date and the hour of the printout.

*Under the Header/Footer tab, press the Custom Header button.

The options to personalize the header will appear as above. They are the same options as for the page footer. In the middle of the window, there is a series of buttons. They are the options most often used. The section at the bottom is separated into three boxes. The left box will contain the text that will be written on the left side of the page. The box in the middle will contain the text that will be in the middle of the header and so on.

*Click in the left box.
*Press the button to insert the name of the file.
*Click in the box of the middle.
*Write your first name and name.
*Click in the box of the right-hand side.
*Write: Date: and press the andbuttons.

The current date and time and the time of the printout will appear on the right side of the header.

*Press the Enter key.

You can write many rows in a header or footer. The next part consists of adding the page number and the total of pages in your printout.

*Write Page and press the button.
*Write of and press the button.
*Press the OK button.
*Press the Preview button
*Press the zoom button to better see the header.

The result should look like this.

The last exercise demonstrated how you can use the options by adding text and/or combining them to give a better results. It's also possible to write as many rows as you need in the header or footer.

*Press the Close button to return to the page layout options.
*Click on the Sheet tab.

Under the Sheet tab, in the print area section you can determine what range of cells will be printed in the printing area box. You can determine the area you want to print. Instead of printing all the contents of a worksheet, you can choose to print only a part of it.

The titles boxes are very practicalin a worksheet. Often, you use the first rows and the first columns in a worksheet to write the important titles such as: income, charges, gross profit,etc, the months,etc. These titles will not print on the second page or the following pages unless you force Excel to make it so. The option Print titles will reprint the selected rows and columns on to every page. Be careful, not to put these rows and columns in the printing area. Otherwise, they are going to be printed twice on the first page of your printout.

You also have access to other options:to print the grid on all the pages, to print in black or white or in "draft" mode. It's also possible to print the rows and columns headings (A, B, C, 1 , 2 , 3...) and even your comments.

The printing area

Besides allowing you to print your entire spreadsheet, Excel allows you to print a part of your worksheets. It's however necessary to determine in advance the printing area that you need. There are several ways to carry out this task.

*From the File menu, select the Printing area and Define options.
*Make a range of cells with the area that you need to print.
OR
*From the File menu, select the Page Setup option.
*Select the Sheet tab.
*Click in the Print area box.
*Select the range of cells that you need to print.

While pressing on theCTRL key, you can select several areas to print at the same time. However, every area will be printed on a different page.

Printing

If you press the button, Excel will print all the contents of the worksheet shown on the screen or according to the options that you have chosen in the page layout. You can however control some options for printing. The next part explains these options.

From the File menu, select the Print option.

 

The window offers you several options. In the Printer section, you can choose the type of printer on which your document will be printed. If you work in an office, it may be possible that you have access to more than one printer. For example, you could have access to a laser, ink jet printer or even a color printer.

In the Print range section, you have the options to print your entire document or only some pages of you're file. file. This is very practical when you need to reprint a few pages after a correction.

In the Print what section, Excel offers you to print the block that you selected first, to print the worksheet where the cursor is located or to print all the worksheets of your file that contains a number, text or a formula.

In the Copies section you can choose the number of copies that Excel will print.

Page break

The previous sections showed you how to change the presentation of the document on paper and the options for printing. But what if you wanted a part of the document to always be at the start of a new page? Excel offers you the possibility of putting in page breaks at any place in a worksheet. The next part of this page demonstrates how to use page breaks.

*Place the cursor in the B2 cell.
*From the Insert menu, select the Page break option.

The page break will be placed above and to the left of the active cell. The dotted rows indicate the separation between pages to be printed.

To remove a page break.

*Place the cursor in the cell in the intersection of the page breaks. For the exercise, place the cursor in the B3 cell.
*From the Insert menu, select the option Delete Page Break.

In that box, the vertical page break will be deleted but not the horizontal page break. The B3 cell was only tied to the vertical page break. Any cell in the B column, apart from B2, would be able to delete the vertical page break. The B2 cell could erase both vertical and horizontal page breaks.

*Place the cursor in the B2 cell and delete the horizontal page break.

To insert only a vertical page break.

*Click on the letter of the column that you want to insert the page break. For the exercise, select the B column.
*From the Insert menu, select the Page break option.

The page break will be placed on the left-hand side of the selected column.

*Delete the page break.

To insert a horizontal page break.

*Click on the number of the row that you want to insert the page break. For the exercise, select row 2 by pressing on the grey box with the number 2.
*From the Insert menu, select the Page break option.

The page break will be placed above the selected row.

*Delete the page break.

Outline of page breaks

The preview of the page breaks option showes you what the document will look like on paper. But before, you must prepare the worksheet by entering some numbers and a page break.

*Enter the number 1 in the A1 cell.
*Enter the number 2 in the B2 cell.
*Enter the number 3 in the C3 cell.
*Enter the number 4 in the D4 cell.
*Enter the number 5 in the E5 cell.
*Enter the number 6 in the F6 cell.
*Place the cursor in the C3 cell.
*From the Insert menu, select the Page break option.
*From the View menu, select the Page break preview option.

Excel gives you a message to inform you that you may move the page breaks to better answer your needs.

*If you don't want to see this message anymore, click in box in the window and press the OK button.

Excel will show you the worksheet by indicating the contents of the pages and where the page breaks will appear. You can move the page break by placing the pointer on them, pressing and holding the left mouse button and moving it around.

*To deactivate the option and return to the normal presentation, of the View menu, select the Normal option.

 

 



This site is hosted by 1&1.com