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

Contents

HOW TO PRINT A SHEET IN FIXED NUMBER OF PAGES

INTRODUCTION

After the report is ready, we try to print the reports.

The report printing can be a headache in EXCEL SHEET , if we are not familiar with the different options available to set the print for EXCEL SHEET.

We already have discussed many different options of printing in the tutorial. [www.gyankosh.net/exceltricks]

In this article we’ll specifically discuss how to print a report in fixed number of pages.

 

 

PRINT A REPORT IN FIXED NUMBER OF PAGES PERFECTLY

SCENARIO

Suppose , we have a big report spread over rows and columns.
Now , we know that setting the print is a cumbersome job in Excel as we need to set the width of cells, hide row or columns and do a lot of things to set the print as per our requirement.

FOLLOW THE STEPS TO PRINT A REPORT IN FIXED NUMBER OF PAGES

  • Select the data if a portion is to be printed, otherwise don’t select.
  • Go to FILE MENU.
  • Go to PRINT OPTION.
  • Choose the printer.
  • Choose the ACTIVE SELECTION [If selection is made otherwise no need to change the default option]
  • Choose the collation option.
  • Choose the number of copies.
 
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 CUSTOM SCALING OPTION.

The following dialog box will open.

PRINT A SHEET IN FIXED NUMBER OF PAGES
EXCEL: CHOOSE CUSTOM SCALING OPTIONS

 

  • Go to the option FIT TO as shown in the picture above.
  • It has the statement as  FIT TO …..A….. PAGES WIDE BY………B………TALL.
  • A is the number of pages you want the width to be. Suppose the report is very wide and it’ll fit in 2 pages , we can choose 2 for that .
  • B is the number of pages you want the length to be. i.e. in how many pages the complete report should be printed in the length.
  • So if we chose 2 for A and 5 for B i.e. report is 2 pages wide and 5 pages tall, total 10 pages will be printed.
AGAIN TAKE CARE ABOUT THE FONT, IF THE TEXT IS READABLE OR NOT and SET THE NUMBER OF PAGES ACCORDING TO THAT ONLY.
OUTPUT OF PRINTING FIXED NUMBER OF PAGES IN EXCEL
EXCEL: OUTPUT OF THE PRINTOUT.[10 PAGES ARE TO BE PRINTED]

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]