Why does my Excel spreadsheet look different in print preview?

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.

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.

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

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.

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.

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.

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.

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

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.

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.