Printing Multiple Worksheets on a Single Page
- Choose Print from the File menu. Excel displays the Print dialog box.
- In the Print What area of the dialog box, choose the Entire Workbook option.
- Click the Properties button.
- Set the Pages Per Sheet control to 4.
- Click OK to close the Properties dialog box.
- Click OK to actually print the worksheets.
Considering this, how do I print an entire workbook in the same setting?
Replies (3) îœ
- Press and hold the CTRL button of your keyboard.
- While holding the CTRL button, click all of your worksheets.
- When all of your worksheets are selected, release the CTRL button.
- Go to Page Layout tab.
- From the Page Layout tab, you can now customize your print layout.
Also, how do I set page settings for an entire workbook? To apply page setup attributes to a group of worksheets in a workbook, follow these steps:
- Press CTRL and then click each worksheet tab in the workbook that you want to affect.
- On the File menu, click Page Setup. Note.
- Make the changes that you want in the Page Setup dialog box, and then click OK.
Correspondingly, how do I print the entire workbook not the current sheet?
To print the entire workbook, before you click Print, under Settings, click the arrow next to Print Active Sheets, click Print Entire Workbook. The print preview now shows the first page of the first worksheet, and Excel now tells you it'll print 28 pages.
How do I change the print range of a macro document?
The quickest way to set a constant print range is this:
- Select the part of the worksheet that you want to print.
- On the Page Layout tab, in the Page Setup group, click Print Area > Set Print Area.
