How To Print Excel On Multiple Pages. You may want to print multiple pages of your excel worksheet on a single piece of paper. You can accomplish this by following these steps:
This will split the image into multiple pages. Display the page layout tab of the ribbon. In the print multiple selection wizard, click finish button.
It Will Open A List Of Options, From Where You Can Choose The Option That You Need.
To set multiple print areas in your sheet, hold ctrl as you select each group of cells. This will split the image into multiple pages. There are two things to remember in this approach:
After You Finish Selecting The Title Rows Or Columns, Click The Collapse Dialog Button Again To Return To The Dialog Box.
In the print multiple selection wizard, click finish button. Select the print option or press ctrl + p from the keyboard. On the worksheet that you want to print, in the page layout tab, click print titles, in the page setup group.
You Will See Two Reference Inputs Under The Print Titles Section.
To do this, hold the control key and then click on the tab where you have the sheet name. Display the page layout tab of the ribbon. In the page setup group, click on the dialog box launcher.
As A Result, Two Sheets Will Be Printed On One Page.
Convert your image into a pdf file. Here, we selected cells a1. To print only some of the worksheets, hold down the ctrl key and.
In The Print Multiple Selection Wizard, Click Button To Select And Add The Range That You Want To Print Into The Ranges To Print List Box One By One, (You Can Select The Ranges From One Worksheet Or Multiple Worksheets ), Click Button Can Remove The Ranges You Don’t Need, See Screenshot:
You can find the link at the end of the settings section. These labels are also known as print titles. Select the sheets you want to print.