Share this page
Excel - Page setup and printing
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.
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.
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.
in the left box.
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.
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 is also possible to write as many rows as you need in the header or footer.
the Close button to return to the page layout options.
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.
Besides allowing you to print your entire spreadsheet, Excel allows you to print a part of your worksheets. It is however necessary to determine in advance the printing area that you need. There are several ways to carry out this task.
the File menu, select the Printing area and Define options.
While pressing on the Ctrl key, you can select several areas to print at the same time. However, every area will be printed on a different page.
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.
In the Copies section you can choose the number of copies that Excel will print.
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.
the cursor in the B2 cell.
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.
the cursor in the cell in the intersection of the page breaks. For the exercise,
place the cursor in the B3 cell.
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.
on the letter of the column that you want to insert the page break. For the
exercise, select the B column.
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.
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.
The page break will be placed above the selected row.
Delete the page break.
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.
the number 1 in the A1 cell.
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.