![how to adjust margins in pages 2015 how to adjust margins in pages 2015](https://support.content.office.net/en-us/media/16d4f055-7940-4da2-aa51-bb2483959651.png)
Then hold down Ctrl while you click the tabs of the other sheets that you want to select. To select two or more non-adjacent sheetsĬlick the tab for the first sheet. Then hold down Shift and click the tab for the last sheet that you want to select. If you don't see the tab that you want, click the tab scrolling buttons to display the tab, and then click the tab.Ĭlick the tab for the first sheet. Select the worksheet or worksheets that you want to print.Ĭlick the tab for the sheet that you want to print. In the Page Setup dialog box, click the Default button, and then click Yes. To change the default margins, click Margins after you select a new margin, and then click Custom Margins. Top and bottom page margins can be used for things such as headers, footers, and page numbers.įollow the steps below to set page margins: Click Margins, click Custom Margins, and then in the Top, Bottom, Left, and Right boxes, enter new values for the margins. Page margins are the blank spaces between your data and the edges of the printed page. To get started on a document in Pages, you can choose what kind of document you want to create, change margins, change how your text looks, and add page numbers and other content to headers and footers.
![how to adjust margins in pages 2015 how to adjust margins in pages 2015](https://i.ytimg.com/vi/W8rIJST42Qw/maxresdefault.jpg)
To better align an Excel worksheet on a printed page, you can change margins, specify custom margins, or center the worksheet-either horizontally or vertically on the page. Excel for the web Set up your document in Pages on iPhone, iPad, or Mac. In the Print area, you can select preferences, including if you want the gridlines to appear on your printed worksheet.Tip: Although Excel for the web doesn't support setting page margins, it does offer some Page Setup options on the Page Layout tab. This row will print at the top of every page. You could also type $1:$2 to print rows one and two at the top of every page.įor columns that you want to appear on the left of every page, type, for example, $A:$C to print columns A through C on the left of every page in the Columns to repeat at left box. In the Print titles section, you'll set the row that you want to set as a title. If it's row 1, you would type $1:$1. This would print all cells in columns A and B, and rows one through ten. In the Print area box, select the range of cells that you wish to print. For example: A1: B10. Page Setup is a text link at the bottom of your print options, as circled in red below:Ĭlick on Page Setup, then click on the Sheet tab in the dialogue box. To do this, click on the File tab, then Print. Selecting the print area simply means that you will define the parts of the spreadsheets and workbooks that you want to print. If you do not wish to print an entire workbook or an entire spreadsheet, you'll need to do this. As you can see below, the active worksheet takes up more of the screen and is easier to read, although you may have to scroll down or up to see the entire page. This shows you the active worksheet as it appears at 100% magnification.
![how to adjust margins in pages 2015 how to adjust margins in pages 2015](https://help.apple.com/assets/609C618CA267BE60B64DC908/609C618FA267BE60B64DC932/en_US/ee4a02496e6395c30ef2d03853ebf276.png)
![how to adjust margins in pages 2015 how to adjust margins in pages 2015](https://www.thoughtco.com/thmb/nVa8HUZ-c3xp3QRnBvTnkJOIgGE=/987x555/smart/filters:no_upscale()/001-setting-margins-columns-guides-adobe-indesign-1078497-6771638fbc124aa0bf23df3ef441d855.jpg)
The next icon is Zoom to Page (highlighted). The first icon (from left to right) is the Show Margins icon. When you click this, Excel will show you the margins in Print Preview as you have them set: Now, let's look at the right side of the Print screen – or the print preview. In the right bottom corner, you'll see these two icons:
How to adjust margins in pages 2015 full size#
Next, decide if you want to print in Portrait (the shortest side of the paper is horizontal) or Landscape (the longer side of the paper is horizontal) orientation.įinally, select Paper Size, Margins, and if you want to print the worksheets at their full size or scale them down to smaller sizes to fit easier on paper. Do you want the printer to print 10 copies of Sheet1 first, followed by 10 pages of Sheet 2? Or would you prefer to print Sheet1, Sheet2, then Sheet1, Sheet2, etc., until all copies have been printed? For example, let's say you print 10 copies each of Sheet1 and Sheet2. Under Collated, you can select how you want multiple copies to print. Print Selection to print just the cells that you have selected. Print Entire Workbook to print all worksheets in the workbook. Print Active Sheets to print the worksheet that is currently active (or being displayed) in Excel. Under Print Active Sheets select what parts of your workbook that you want to print. This allows you to print all or just portions of your file. You can choose: To prepare your workbook or worksheets for printing, first select your printer in the Printer section on the left. This is what your workbook is going to look like when you print it. On the right hand side, you'll see the print preview. Interested in learning more? Why not take an online Excel 2021 course?