Menu
May 09, 2012 I can't print a range of pages from a 102-page Word 2010 mail merged document. Word starts printing all of the pages before I cancel the print job. I have the same problem in both the.doc and docx formats. Doug Robbins - Word MVP dkr[atsymbol]mvps[dot]org. You can specify pages within a section by using s and p with page numbers. For instance, if you want to print pages 2 through 7 of section 4, you would use p2s4-p7s4. You can specify a range of pages across sections in the same manner. To print beginning with page 2 of section 4 and ending with page 5 of section 7 you would use p2s4-p5s7.
Word gives you complete control over how it prints your document. You can either print the entire document or you can print a portion of it. To print only selected pages, follow these steps:
- Choose the Print option from the File menu, or simply press Ctrl+P. Word displays the Print dialog box. (See Figure 1.)
- In the Pages box, indicate the page numbers you want to print.
- Click on OK.
Figure 1. The Print dialog box.
When you specify page numbers, Word allows you quite a bit of flexibility. The following are some general guidelines for specifying page numbers:
![Print Print](/uploads/1/2/5/6/125659081/239958837.png)
- You can specify a single page number.
- You can specify a group of non-sequential pages by separating them by commas, i.e., 4, 8, 19.
- You can specify a sequential range of pages by putting a dash between them. Thus, 4-7 would print pages 4 through 7.
- You can print an entire section by using s. For instance, to print section 5 of your document, you would use s5.
- You can print multiple sections the same as you would print multiple pages. For example, s2, s6 would print sections 2 and 6.
- You can specify pages within a section by using s and p with page numbers. For instance, if you want to print pages 2 through 7 of section 4, you would use p2s4-p7s4.
- You can specify a range of pages across sections in the same manner. To print beginning with page 2 of section 4 and ending with page 5 of section 7 you would use p2s4-p5s7.
Topics Map > Office 365 > Excel
By default, Excel prints worksheets in portrait orientation (taller than wide). You can change the page orientation to landscape on a worksheet-by-worksheet basis.
Change the page orientation- Select the worksheet or worksheets for which you want to change the orientation.
How to select worksheetsTo selectDo thisA single sheetClick the sheet tab.If you don't see the tab that you want, click the tab scrolling buttons to display the tab, and then click the tab.Two or more adjacent sheetsClick the tab for the first sheet. Then hold down Shift while you click the tab for the last sheet that you want to select.Two or more nonadjacent sheetsClick the tab for the first sheet. Then hold down Ctrl while you click the tabs of the other sheets that you want to select.All sheets in a workbookRight-click a sheet tab, and then click Select All Sheets.Tip: When multiple worksheets are selected, [Group] appears in the title bar at the top of the worksheet. To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets. - On the Page Layout tab, in thePage Setupgroup, clickOrientation,and then click Portrait or Landscape.
Note: If you don'w have a printer set up, the Orientation option will appear dimmed and you won't be able to select it. To resolve this, you must set up a printer. The option also appears dimmed when you're editing the contents of a cell. To resolve this, press Enter to accept the changes or Esc to cancel the changes.
Tip:Because you can set page orientation on a worksheet-by-worksheet basis, you might print some workshets in a workbook in one orientation (such as portrait orientation). Simply set the orientation for each worksheet as appropriate, and then Print a worksheet or workbook.
Change the page orientation when you are ready to print
- Select the worksheet, worksheets, or worksheet data that you want to print.
- Click the File tab.
- Click Print or use the keyboard shortcut Ctrl+P for a Windows computer or Cmd+P for a Mac.
- In the Page Orientationdrop-down box, under Settings, click Portrait Orientation or Landscape Orientation.
- When you are ready to print, click Print.
Create a template that uses landscape orientation by default
To save time, you can save a workbook configured to print in landscape orientation as a template. You can then use this template to create other workbooks.
Create the template
- Create a workbook.
- Select the worksheet or worksheets for which you want to change the orientationHow to select worksheetsTo selectDo thisA single sheetClick the sheet tab.If you don't see the tab that you want, click the tab scrolling buttons to display the tab, and then click the tab.Two or more adjacent sheetsClick the tab for the first sheet. Then hold down Shift while you click the tab for the last sheet that you want to select.Two or more nonadjacent sheetsClick the tab for the first sheet. Then hold down Ctrl while you click the tabs of the other sheets that you want to select.All sheets in a workbookRight-click a sheet tab, and then click Select All Sheets.Tip: When multiple worksheets are selected, [Group] appears in the title bar at the top of the worksheet. To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. If no unselected sheet is visible, right-the tab of a selected sheet, and then click Ungroup Sheets.
- On the Page Layout tab, in the Page Setup group, click Orientation, and then clickLandscape.
Note:If you don't have a printer set up, the Orientation option will appear dimmed, and you won't be able to select it. To resolve this, you must set up a printer. The option also appears dimmed when you're editing the contents of a cell. To resolve this, press Enter to accept the changes or Esc to cancel the changes. - Make any other customization that you want to the workbook.
Tip: If you want to customize several worksheets at one time, you can temporarily group the worksheets, make your changes, and then ungroup them. To group the worksheets, right-click any tab at the bottom of the worksheet. On the shortcut menu, click Select All Sheets. In the title bar, you should see the name of the workbook followed by the word [Group]. Then, change the orientation to landscape to make any other customization that you want. To turn off the grouping, right-click any tab, and then click Ungroup Sheets (or just click another worksheet tab). - Click the File tab.
- Click Save As, then select the location where you want to save your worksheet. For example, click Computer (or This PC in Excel 2016), and then click Desktop.
- In the File name box, type the name that you want to use for the template.
- in the Save as type box, click Excel Template (*.xltx),or clickExcel Macro-Enabled Template (*.xltm)if the workbook contains macros that you want to make available in the template.
- Click Save.
The template is automatically saved in the Templates folder.
- Click the File tab.
- Click New.
- Click Personal.
- Click the icon or name of your saved template.
For more information, please visit the Excel help center.
If you have any questions, come by the Help Desk at Hardman & Jacobs Undergraduate Learning Center Room 105, call 646-1840, or email us at [email protected].
Keywords: | microsoft excel print worksheet landscape portraitSuggest keywords | Doc ID: | 74931 |
---|---|---|---|
Owner: | John B. | Group: | New Mexico State University |
Created: | 2017-07-28 10:24 MST | Updated: | 2017-07-28 10:35 MST |
Sites: | New Mexico State University | ||
Feedback: | 10CommentSuggest a new document |