How to Set Print Preview in Excel (6 Options)

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.

Choose Printing Area by Print Preview in Excel

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.

Choose Area

Step 2:

  • Check the print preview in the right-side window.

Choose Printing Area by Print Preview in Excel

Step 3:

  • Choose the page you want to print from your active sheet.

Choose Printing Area by Print Preview in Excel

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

Choose Printing Area by Print Preview in Excel

Step 2:

  • Get the print preview as shown in the image.

Choose Printing Area by Print Preview in Excel

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.

Choose Printing Area by Print Preview in Excel

Step 2:

  • Get your print preview.

Apply Printing Serial by Print Preview in Excel

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

Apply Printing Serial by Print Preview in Excel

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

Apply Printing Serial by Print Preview in Excel

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

Set Printing Orientation by Print Preview in Excel

Step 2:

  • Then, you will get the print preview as the image below.

Set Printing Orientation by Print Preview in Excel

3.2 Landscape Orientation

To print in horizontal orientation, follow the steps.

Steps:

  • Firstly, select the Landscape Orientation and then get your print preview.

Set Printing Orientation by Print Preview in Excel

Read More: How to Print Landscape in Excel (3 Easy Methods)


Similar Readings


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.

Select Page Size by Print Preview in Excel

Step 2:

  • Finally, you will obtain a print preview as shown in the below screenshot.

Select Page Size by Print Preview in Excel

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

Apply Margins by Print Preview in Excel

Step 2:

  • Then, a print preview will be shown.

Apply Margins by Print Preview in Excel

Step 3:

  • To apply a wide margin, choose the Wide

Apply Margins by Print Preview in Excel

Step 4:

  • Finally, a print preview with a wide margin will appear.

Apply Margins by Print Preview in Excel

Step 5:

  • To apply a Narrow margin, select the Narrow

Apply Margins by Print Preview in Excel

Step 6:

  • As illustrated in the screenshot below, a print preview with a Narrow margin will appear.

Apply Margins by Print Preview in Excel

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.

Apply Scaling

Step 1:

  • To fit your entire current sheet on one page, select the Fit Sheet on One Page

Apply Scaling

Step 2:

  • Then, check your print preview like this.

Apply Scaling

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

Apply Scaling

Step 2:

  • Therefore, you can check your print preview.

Apply Scaling

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

Apply Scaling

Step 2:

  • Finally, get your print preview.

Apply Scaling

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.


Related Articles

Bhubon Costa

Bhubon Costa

Myself, Bhubon Costa, an engineer, is currently employed with Exceldemy as an Excel & VBA Content Developer. I appreciate solving analytical difficulties, finding practical answers, and, for the most part, I enjoy taking on new tasks. I write articles on Exceldemy about various ways to get out of Microsoft Excel's stuck conditions. My passion is to leave my mark on the world through my work and to have an impact on the community who benefit from it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo