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

[email protected]

KINDLY SPEND FEW SECONDS HERE....

-We might be compensated for the visits or purchases you make by clicking the ads on this website .  They help us to keep bringing excellent quality articles for you.
-Click on the pictures if you can’t read. All of them are High Resolution .
-If you can’t find what you were looking for, kindly message in the chat box.
*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW