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.
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. You can make that dynamic also by using a similar process for the width.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. The height is defined by the COUNTA function, and we used 9 to define the width, since that is the number of columns in our range. The last two arguments define the size of the range. So, in our example, the reference was cell A1, we went down zero rows and over zero columns, which kept cell A1 as our starting point. The OFFSET function “Returns the reference to a range that is a given number of rows and columns from a given reference”. Let’s take a quick refresher on the OFFSET function. Now, whenever we add or remove items from our data range, the height of the print area will automatically adjust based on the number of items within column “I”. Next, let’s redefine the Print Area item to reference the DynPrint item we just entered: Now we have two items in the Name Manger: How do we create a process that will automatically adjust the height of the range based on the number of rows that contain data? Easy! We’ll set up another item in the Name Manager and use the OFFSET function to dynamically define the height.įirst we are going to create another item in the Name Manager, call it “DynPrint” and insert the following formula in the “Refers to” area:
If I highlight the range I want to print, go to the Page Layout tab and choose Set Print Area, Excel will then define the print range that I want:Īnd notice that Excel has defined that range in the Name Manger:īut if I add or remove rows of data, Excel will still print $A$1:$I$17. If I choose to Print this page, even though I only want to print the 17 rows with data, you can see that Excel wants to print all 51 rows:
Here I have a data range that has a header plus 50 rows for data:
If you get a preview, look for the download arrow in the upper right hand corner. You can download the file here and follow along. In this tutorial we are going to discuss a process using the OFFSET function to automatically adjust your print area as you add or remove rows of data.
Often you may have a data range that you add or remove rows, and you need to keep redefining the print area manually.