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
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.
OTHER WAYS TO REACH THIS ARTICLE
SET PAGE FOR PRINTING, SET LAYOUT OF PAGE IN EXCEL, ADD HEADER IN PAGE
YOU MAY LIKE
- HOW TO USE PIVOT TABLES IN EXCEL?
- how to print title in excel
- HOW TO SET PRINT AREA IN EXCEL?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.