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

Table of Contents

HOW TO SET PAGE LAYOUT IN EXCEL?

INTRODUCTION

The View tab of excel has many subgroups like workbook view, Show/hide, Zoom, windows and Macros, which specially deals with layouts, showing or hiding line numbers, column names etc. freezing panes, freezing top rows and Macros.

 

PAGE LAYOUT mainly deals with the setting of the page ready for printing like setting the orientation, setting margins etc.

BUTTON LOCATION FOR PAGE LAYOUT IN EXCEL

page break preview excel
PAGE LAYOUT BUTTON

STEPS TO SET PAGE LAYOUT IN EXCEL

The page layout can be set by using this function. Page Layout pertains to the margins etc. for a page while printing.

As soon as the button is clicked, the normal sheet divides itself into different pages.

The margins can be set by dragging the cursor on the ruler.

If header is to be added , just click on the message “Click here to Add header

Similarly if Footer is to be added, just click on the message “Click here to Add footer”. The Header and Footer insertion can be read HERE.

 

Click NORMAL to get back to normal view of full worksheet.

page layout setting excel
PAGE LAYOUT SETTING VIEW

OTHER WAYS TO REACH THIS ARTICLE

  • SET PAGE FOR PRINTING, SET LAYOUT OF PAGE IN EXCEL, ADD HEADER IN PAGE

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

Like this:

Like Loading...

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: