Our Recommendation for You Search your Query, You can find easily. for example search by book name or course name or any other which is related to your education


Page Setup options worksheet in Excel 2013

Page Setup dialog box and tabs in Excel 2013

If you want to change the settings on a page that is a worksheet in Excel 2013 then you can do it on the toolbar 'Page Layout' on the ribbon of Excel 2013 commands in the group 'Page Setup'.

Page Setup group commands on the toolbar Page Layout in Excel 2013
In the dialog box 'Page Setup' there are four cards (Tabs).

On the 'Page' determine the page orientation 'Portrait' (placed vertically page) or 'Landscape' (horizontally laid page).

In the field of 'Scaling' determine the percentage to which the size of Excel 2013 to adjust the page size of the window, in the field 'Size' Paper Size choose any of the available paper size and print quality.

Page Settings tab in Excel 2013
On the 'Margins' with enrollment numbers to determine the boundaries of the page and the header and footer distance from the edge of the page, and the position of the table to the list (if the table is aligned horizontally or vertically on the paper).

setting and adjusting the margins on the Margins tab in Excel 2013
On the "Header/Footer" arrange the header and footer of the table as desired. So we can choose some of the titles in the list or click on the Custom Header or Custom Footer then appears an additional frame is divided into three parts.

setting headers and footers on the tab Header / Footer in Excel

In each field we enter data as desired and arrange them using the button in the box. Here we can change the font, size and font style, put in the header of the date, time or number of pages. When you click on the Edit Header button 'OK'.

how to insert a page number on the worksheet in Excel

On the 'Sheet' we have the possibility of different settings and one of them is a repeat on each worksheet columns in a table or a specific row at the top of the worksheet. Of course there are other possibilities such as: turning "Gridlines" when printing, or setting up a black-and-white print (not to spend on the color printer), the direction of the print queue in how Excel 2013 workbook contains multiple worksheets, etc.

setting various parameters of the worksheet tab sheet in Excel