PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO PRINT A LONG REPORT IN EXCEL IN JUST 1 MINUTE

INTRODUCTION

The printing procedure of the EXCEL sheets is simple as well as complex. It is very tricky sometimes to get the exact print, as we want.

We already learnt a few tricks like to print on one page , orientation setting etc. but practically, we’ll print on one page when a report is not very big.

But it is not always the case.

Many times, the reports are very long and it is a challenge to set these reports for printing. Thanks to EXCEL to introduce very intuitive options to let us print faster.

In this article we’ll learn to print a report in a fixed number of pages in 1 minute.

PRINT A LONG REPORT IN 1 MIN PERFECTLY

SCENARIO 1- VERTICAL REPORT

We have a long report say of 10 pages.

We want to print this.

Obviously , this can’t be printed in one page and we need to set width as well as height of the report to print it properly.

And we consider a case that we can’t remove its rows or columns to make the report printable.

So, follow these steps to print the report fast.

STEPS:

  • If we need to print a portion , select the portion, if not, no n eed for selection.
  • Go to FILE MENU.
  • Go to PRINT OPTION.
  • Make the standard choices such as printer, orientation, collation, number of copies etc. as mentioned in the picture below.
CHOOSE THE PRINT SETTINGS IN EXCEL
EXCEL: CHOOSE APPROPRIATE PRINT SETTINGS

important step

After making the standard selections, we need to go for the main step.

Go to SCALING OPTION and choose FIT ALL COLUMNS ON ONE PAGE.

This option will squeeze all the columns on one page.

Now if the number of columns is large and after squeezing , the text is getting too small, go to the orientation and make it LANDSCAPE.

Even after that if the text is too small, we need to go for a bigger paper or we need to hide unnecessary rows or columns.

FIT ALL COLUMNS IN ONE PAGE FOR PRINTING IN EXCEL
EXCEL: PRINT A LONG REPORT IN EXCEL

 

This option will squeeze all the columns on one page.

Now if the number of columns is large and after squeezing , the text is getting too small, go to the orientation and make it LANDSCAPE.

Even after that if the text is too small, we need to go for a bigger paper or we need to hide unnecessary rows or columns.

PRINT A WIDE REPORT IN 1 MIN PERFECTLY

SCENARIO 1- WIDE REPORT

WIDE report is the one which is horizontal. It has a limited number of rows but many columns.

We want to print this.

Obviously , this can’t be printed in one page and we need to set width as well as height of the report to print it properly.

And we consider a case that we can’t remove its rows or columns to make the report printable.

So, follow these steps to print the report fast.

STEPS:

  • If we need to print a portion , select the portion, if not, no n eed for selection.
  • Go to FILE MENU.
  • Go to PRINT OPTION.
  • Make the standard choices such as printer, orientation, collation, number of copies etc. as mentioned in the picture below.
CHOOSE THE PRINT SETTINGS IN EXCEL
EXCEL: CHOOSE APPROPRIATE PRINT SETTINGS

important step

After making the standard selections, we need to go for the main step.

Go to SCALING OPTION and choose FIT ALL ROWS ON ONE PAGE.

 

FIT ALL COLUMNS IN ONE PAGE FOR PRINTING IN EXCEL
EXCEL: PRINT A LONG REPORT IN EXCEL

 

This option will squeeze all the rows to one page.

Now if the number of columns is large and after squeezing , the text is getting too small, go to the orientation and make it PORTRAIT.

Even after that if the text is too small, we need to go for a bigger paper or we need to hide unnecessary rows or columns.

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]