Formulas

How to Set Print Preview in Excel?

Pinterest LinkedIn Tumblr

“PRINT PREVIEW” – The word itself explains the crux of this short tutorial.
Viewing the worksheet previously before printing it can prevent many errors. So, this short tutorial lets you know
what and where the changes could be made before printing your final worksheet.

Following are the steps to set Print Preview

STEP 1 – File>>print.

This displays the first page and below you can find the arrow marks that helps you to navigate to the next and also to the previous pages.

print preview
How to Set Print Preview in Excel? 1

You can also directly change the number by pointing to the page where you need to navigate instead of clicking on the arrow marks as shown below.

How to Set Print Preview in Excel? 2
How to Set Print Preview in Excel? 3

STEP 2 – Select “print active sheets” to print all the sheets that has been numbered below.

How to Set Print Preview in Excel? 4

STEP 3 – In the settings part, you can choose the number of pages to be printed and also you can also set the orientation as potrait or landscape.

How to Set Print Preview in Excel? 5
How to Set Print Preview in Excel? 6

STEP 4 – As a keen Excel user, you must have noticed some columns missing in the first few pages and appearing after certain pages. To overcome this and get it printed in the same page as per assigned in the Excel worksheet, Choose “Fit all columns on one page”.

How to Set Print Preview in Excel? 7

Now, you will be able to see all the columns on the same page and if you notice well, the number of total pages would have also been reduced.

How to Set Print Preview in Excel? 8

STEP 5- Now, choose the margin style. It is nothing but the space left between the page and the beginning. You can chose according to your preference. There are also custom margins where you can specify your dimensions.

How to Set Print Preview in Excel? 9

STEP 6 – Next, choose the page size such as A3, A4, B4, B5 etc….

How to Set Print Preview in Excel? 10

STEP 7 – Then, finally choose the number of copies to be printed. Then, choose collated or uncollated. Collated prints the first set of copy and then the next set of copy. Uncollated makes copy of the first page two times. Then, proceeds page by page.

How to Set Print Preview in Excel? 11

After finishing the modifications, click on the print icon.

To know more about Excel Functions click here.

Follow us on YouTube for more informative video tutorials.

Related Posts

Write A Comment