#EXCEL FOR MAC PAGE SETUP VS PRINT SETUP HOW TO#
#EXCEL FOR MAC PAGE SETUP VS PRINT SETUP SERIES#

While pressing on theCTRL key, you can select The range of cells that you need to print. The File menu, select the Page Setup option. The File menu, select the Printing area and Define options.Ī range of cells with the area that you need to print. There are several ways to carry out this task. It's however necessary to determine in advance To print the rows and columns headings (A, B, C, 1, 2, 3.) and even yourīesides allowing you to print your entire spreadsheet, Excel allows you to To print in black or white or in 'draft' mode. You also have access to other options:to print the grid on all the pages, To be printed twice on the first page of your printout. To put these rows and columns in the printing area. The option Print titles will reprint the selected rows and columns on to every page. Page or the following pages unless you force Excel to make it so. These titles will not print on the second Often, you use the first rows and theįirst columns in a worksheet to write the important titles such as: income,Ĭharges, gross profit,etc, the months,etc. The titles boxes are very practicalin a worksheet. Instead of printing all the contents of a worksheet, you can choose You can determine the area you want to print. Under the Sheet tab, in the print area section you can determine what range of cells will be printed The Close button to return to the page layout options. Many rows as you need in the header or footer. The last exercise demonstrated how you can use the options by adding text and/or combining them to give a better results. The zoom button to better see the header. The next part consists ofĪdding the page number and the total of pages in your printout. You can write many rows in a header or footer. The current date and time and the time of the printout will appear on the right Will be in the middle of the header and so on. The box in the middle will contain the text that The left box will contain the text that will be written on

#EXCEL FOR MAC PAGE SETUP VS PRINT SETUP SERIES#

In the middle of the window, there is a series The options to personalize the header will appear as above. The Header/Footer tab, press the Custom Header button. The next exercise consists in writing the name of the document, your name,Īs well as the date and the hour of the printout. With the title ' Monthly revenues and expenses for May 2006' says itĪll. Identify the document and what it's supposed to represent. To add a header or a footer to a document. Or a footer, select the first option, 'none', from the list of the Under the Header/Footer tab, you can determine what will be in the headerĪnd the footer of each of the pages of the printout. In the middle of the window gives you an idea of the effect of these choices You can also determine the placeįor the header and the footer for the worksheet your about to print. You can also choose to center horizontallyĪnd vertically your worksheet on the page. The border of the page and your text, for the file as well as those for the Under the Margins tab, you can determine the margins, the width between For example, the first page of your printout could

The last option allows you to choose the page number For printing in the computer lab, be sure that the paper size The type of paper (letter size, legal, newspaper. The printout before printing by pressing the review button. On to X pages in widths and Y pages in height. You can also ask Excel to find automatically the best size to enter your document This is very practical when all the columns of you're worksheet should be on one page only. In the scaling sections, you can manuallyĬhange the size of your spreadsheet by reducing or increasing it. Under the Page tab, in the section Orientation, Excel asks you for the orientation of the pages to print. The File menu, select the Page setup option. You can change the margins of sheets, add the headers, the footers and several other options that will be discussed below.

The options of the page layout exist to improve the presentation of your document on paper. You'll then be able to improve the presentation of your file on paper.

#EXCEL FOR MAC PAGE SETUP VS PRINT SETUP HOW TO#

This page shows you how to set-up your printout as well as the options for printing. You can add a header or footer to a page, change the margins as well as several other options. Microsoft Excel - Page layout and printingĮxcel allows you to print your document as well as to add additional page layout options to your presentation.

Excel for mac page setup vs print setup