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

Contents

HOW TO SET PRINT AREA IN EXCEL?

INTRODUCTION

In this article we’ll learn how we can set the print area in the microsoft Excel.

After we have prepared our reports, most of the time we go for a print. But if you work with Excel , you must have felt that printing the sheet in a proper page is a tricky task many times. So in this article, we’ll learn how we can set the print area in Excel.

“SETTING PRINT AREA” is an option of setting the printing area as per need.

BUTTON LOCATION TO SET PRINT AREA IN EXCEL

The button location for the SETTING PRINT AREA is shown below in the picture.

The button for setting the print area is found under the PAGE LAYOUT TAB under PAGE SET UP section and inside the menu showed by the button named PRINT AREA.

set print area in excel
SETTING PRINT AREA IN EXCEL

The picture shows the different portions shown by different letters.

We have selected an area and clicked SET PRINT AREA. In the picture, check out the abry area inside the dotted line rectangle. It is the selected print area.

If we print it, only the selected portion will be printed.

STEPS TO SET PRINT AREA

  • Just select the area and click on SET PRINT AREA.
  • CLICK ON CLEAR PRINT AREA to clear the print area.

ANIMATED EXAMPLE OF SETTING PRINT AREA

set print area in excel

explanation

The animated picture shows the different steps needed to set the print area.

We select the area and go to PAGE LAYOUT TAB and click PRINT AREA button under which we click the SET PRINT AREA button and the job is done.

Now we can print this area.

OTHER WAYS TO REACH THIS ARTICLE

  • SET PRINTING AREA IN EXCEL, SET PRINT TILE, SET PRINTING, ANIMATED EXAMPLE FOR SETTING PRINTING AREA

YOU MAY LIKE

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]

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: