How do I print multiple rows on one page in Excel?
|
You can print multiple print areas on a single page in Excel by following these steps: Show
Note: You can have up to four non-contiguous ranges of cells as your print area on a worksheet. If you try to add a fifth range, Microsoft Office Excel prompts you to delete one of the existing print areas before adding the new one. If your worksheet has more than one page, and you want each page to have its own separate print area, follow these steps:
How do I print long rows on one page in Excel?Click the Page Layout tab on the ribbon. In the Scale to Fit group, in the Width box, select 1 page, and in the Height box, select Automatic. Columns will now appear on one page, but the rows may extend to more than one page. To print your worksheet on a single page, choose 1 page in the Height box.
How do I print multiple print areas in Excel on one page?Set one or more print areas. On the worksheet, select the cells that you want to define as the print area. Tip: To set multiple print areas, hold down the Ctrl key and click the areas you want to print. ... . On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.. How do I print 10 rows per page in Excel?Print row or column titles on every page. Click the sheet.. On the Page Layout tab, in the Page Setup group, click Page Setup.. Under Print Titles, click in Rows to repeat at top or Columns to repeat at left and select the column or row that contains the titles you want to repeat.. Click OK.. On the File menu, click Print.. How do I print multiple rows?Printing Selected Rows Or Columns On Every Page of an Excel.... Click the Page Layout tab on the ribbon.. Click the Print Titles button in the Page Setup section of the ribbon.. To get rows from your spreadsheet to appear at the top of every printed page, click in the Rows to repeat at top box.. |
