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

Contents

HOW TO SET PAGE MARGIN, ORIENTATION AND PAGE SIZE IN EXCEL?

INTRODUCTION

“PAGE MARGIN” is the space between the edge of the page and the content in all the four directions i.e. left, right, top and bottom.

ORIENTATION of the page is the direction in which the page is viewed or printed.

If the BASE is wider and height is lesser, we call it LANDSCAPE whereas if the BASE IS LESS and HEIGHT IS MORE, we call it PORTRAIT. We can set either of the two orientations in EXCEL for the view as well as for the PRINTING.

PAGE SIZE is the size of the page while printing. The length and breadth of the page can be set according to the requirement.

 

 

BUTTON LOCATION FOR SETTING MARGINS IN EXCEL

The button for setting the margin is located under the PAGE LAYOUT tab under PAGE SETUP section.

 

  • The MARGIN SET button is located under PAGE LAYOUT tab .
  • GO TO MARGINS.
  • THE options as per the picture above will be shown.
  • Choose any margin from the list or click CUSTOM MARGINS at the bottom.

STEPS TO SET CUSTOM MARGIN IN EXCEL

STEPS:

  • Go to PAGE LAYOUT>PAGE SETUP>MARGINS>CUSTOM MARGIN.
  • A dialog box as shown in the picture will popup.
  • Enter the values as per requirement.
DIALOG BOX FOR SETTING MARGINS OF THE PAGE

STEPS TO SET PAGE ORIENTATION IN EXCEL

The page orientation is the direction in which the page is visible or printed.

STEPS:

    • Go to PAGE LAYOUT>PAGE SETUP>ORIENTATION.

The orientation can be selected either as LANDSCAPE OR PORTRAIT.

The portrait will have more height than width and landscape will have less height than width.
A dotted line will show the printable area.

STEPS TO SET PAGE SIZE IN EXCEL

The page size can be set to get the proper printout of the page. The pages should be set according to the requirement and the option available with our printer. Here are the steps to set the page size in Excel.


STEPS:

    • Go to PAGE LAYOUT>PAGE SETUP>SIZE.
    • The following menu will open as shown in the picture.
set page size in excel

The page size can be selected from the list available.

The page size will be displayed by a dotted line .

The option is to help us judge how the print will come out.

 

OTHER WAYS TO REACH THIS ARTICLE

  • SET CUSTOM MARGIN, SET MARGIN, SET PRINT AREA, SET LOWER MARGIN, SET UPPER MARGIN, SET LEFT MARGIN, SET DIFFERENT MARGINS

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

gyankosh060309@gmail.com

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: