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 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