Set or clear a print area on a worksheet - Microsoft Support
If you frequently print a specific section of your worksheet, you can set a print area for it. That way, when you print your worksheet, only that section will print. You can enlarge the print area by adding adjacent cells.
Print part of a sheet in Excel for Mac - Microsoft Support
Set a print area. Excel saves the print area together with the workbook. Select the cells that you want to print.
Fit to one page in Excel - Microsoft Support
By scaling your worksheet for printing, you can make your data fit to one page. You can shrink your Excel document to fit data on a designated number of pages using the Page Setup option in the Page Layout tab.
Mengatur atau menghapus area cetak pada lembar kerja
Jika Anda sering mencetak bagian tertentu dari lembar kerja, Anda bisa mengatur area cetak untuknya. Dengan begitu, ketika Anda mencetak lembar kerja, hanya bagian itu yang akan dicetak. Anda bisa memperbesar area cetak dengan menambahkan sel yang berdekatan.
Print a worksheet or workbook - Microsoft Support
In Excel for the web, you can either specify an area you want to print or print an entire worksheet. If you select a print area, but decide to change the specified area, here’s how you can preview your changes:
Video: More print options - Microsoft Support
If you are going to frequently print the same cells in a worksheet, you can configure them as the print area for the worksheet, so you don't have to select them every time you want to print. You can also print specific cells in a worksheet by selecting the range of cells you want to print.
Scale the sheet size for printing in Excel for Mac
You can reduce or enlarge the sheet size for printing to fit the page width, or on a specified number of pages. Print a sheet to fit the page width. On the Page Layout tab, select Page Setup.
Print a PivotTable - Microsoft Support
Set a print area If you have more than one PivotTable report on the worksheet, set a print area that includes only the report that you want to print. Click the PivotTable.
Scale a worksheet - Microsoft Support
Use the Print Area command (Page Setup group) to exclude any columns or rows that you don't need to print. For example, if you want to print columns A through F, but not columns G through Z, set the print area to include only columns A through F.
Video: Print a worksheet on a specific number of pages - Microsoft …
You want to print a worksheet on a set number of pages. There are several ways to do this without shrinking the worksheet, possibly making it hard to read. Want more?