By previewing your worksheet before printing, you can avoid unexpected outcomes and wasted paper. Moreover, many errors can be avoided by viewing the worksheet before printing it. As a result, before printing your final worksheet, this short tutorial will show you what modifications can be done to set print preview in Excel.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
6 Options to Set Print Preview in Excel
In the following sections, we will describe the 6 options available in the Print option. We’ll go over how to use each of the print preview features in Excel. To open the Print option, go to the File tab and select the Print option. The available option will then appear on the right side of the screen. Learn it and put it to better use.
1. Choose Printing Area by Print Preview
First of all, you have to select which area of your worksheet you want to get printed.
1.1 Print Active sheets
The first choice is to print the sheet that is currently active. Follow the steps below to print the currently active sheet serially, page by page.
Step 1:
- Select the first option Print Active sheets.
Step 2:
- Check the print preview in the right-side window.
Step 3:
- Choose the page you want to print from your active sheet.
Read More: [Fixed!] Print Preview Not Available in Excel
1.2 Print Entire Workbook
Follow the simple instructions below to print your full workbook.
Step 1:
- Firstly, select the Print Entire Workbook
Step 2:
- Get the print preview as shown in the image.
Read More: Excel VBA to Display Print Preview for Multiple Sheets
1.3 Print Selection
If you only want to print a portion of your workbook. Take the actions given below.
Step 1:
- First of all, select the portion.
Step 2:
- Get your print preview.
Read More: How to Set Print Area in Excel (5 Methods)
2. Apply Printing Serial by Print Preview
You’ll need this point if you need to print multiple copies. It’s your decision which serial you want your printing to be printed in.
2.1 Collated Print
Collated refers to the serial page 1, page 2, page 3.
Steps:
- Just select the Collated
Read More: Excel VBA: Print Preview for Selected Range (5 Examples)
2.2 Uncollated Print
Uncollated refers to the page serial as page 1, page 1, page 1, then the second page of your copy.
Steps:
- Simply, select the Uncollated
Read More: How to Adjust Print Settings in Excel (8 Suitable Tricks)
3. Set Printing Orientation by Print Preview
For printing Horizontally or Vertically, you can choose the printing orientation.
3.1 Portrait Orientation
Follow the steps to receive your print with a vertical orientation.
Step 1:
- Select the Portrait Orientation
Step 2:
- Then, you will get the print preview as the image below.
3.2 Landscape Orientation
To print in horizontal orientation, follow the steps.
Steps:
- Firstly, select the Landscape Orientation and then get your print preview.
Read More: How to Print Landscape in Excel (3 Easy Methods)
Similar Readings
- Center the Print Area in Excel (4 Ways)
- How to Print Full Page in Excel (4 Simple Ways)
- [Fixed!] Print Preview in Excel Doesn’t Match Document
- How to Delete Blank Pages in Print Preview in Excel (4 Easy Ways)
4. Select Page Size by Print Preview
In addition, you can choose the print preview according to your paper size. For example, if you need to print for paper A4 size follow the steps.
Step 1:
- Simply, select the A4 option for your paper size.
Step 2:
- Finally, you will obtain a print preview as shown in the below screenshot.
Read More: How to Print Excel Sheet in A4 Size (4 Ways)
5. Apply Margins by Print Preview
To add margins in printing, follow the easy steps.
Step 1:
- To add the by-default Normal Margin select the Normal
Step 2:
- Then, a print preview will be shown.
Step 3:
- To apply a wide margin, choose the Wide
Step 4:
- Finally, a print preview with a wide margin will appear.
Step 5:
- To apply a Narrow margin, select the Narrow
Step 6:
- As illustrated in the screenshot below, a print preview with a Narrow margin will appear.
Related Content: How to Print Excel Sheet with Lines (3 Easy Ways)
6. Apply Scaling
6.1 Fit sheet on One Page
Moreover, you can apply the Scaling in print preview. The No Scaling option will be selected by default. To apply the Scaling, follow the steps.
Step 1:
- To fit your entire current sheet on one page, select the Fit Sheet on One Page
Step 2:
- Then, check your print preview like this.
Read More: [Fixed!] Print Preview in Excel Does Not Show All Pages
6.2 Fit All Columns in One Page
To accommodate all columns on one sheet, follow the procedure below.
Step 1:
- Firstly, select the Fit All Columns on One Page
Step 2:
- Therefore, you can check your print preview.
6.3 Fit All Rows in One Page
Follow the steps below to fit all of the rows on one sheet.
Step 1:
- To fit all rows in one sheet, select the Fit All Rows on One Page
Step 2:
- Finally, get your print preview.
Read More: Excel VBA: Print UserForm to Fit on a Page (2 Methods)
Conclusion
To recap, I hope this post has demonstrated how to use Excel’s print preview feature. Look over the practice book and put what you’ve learned to use. We are willing to reimburse programs like this because of your support.
If you have any questions, please do not hesitate to contact us. Please let me know what you think in the comments section below.
Experts from ExcelDemy Team will react to your questions as soon as possible.