When printing a worksheet that you created in Microsoft Office Excel, there are times when we have to do some settings from the default condition. If in the previous article we learned how to set the scale and size of the printing paper used to print an Excel worksheet, then in this article we will discuss how to set the page number and specify the page margins Excel worksheet.
How to Set Page Number
Page Setup, kita bisa menemukan menu pengaturan lembar kerja yang akan dicetak.”>On the File menu -> Page Setup, we can find the settings menu worksheet to be printed. First page number text box is used to specify the page number to a worksheet (worksheet) which we will print. The default value is listed on the Auto setting. Auto setting this means that Microsoft Excel will give the first page number that we will print the number 1 (one).
In addition to using Auto setting, we can determine the number of pages with specific numbers for the first page and the next page will be filled with the next numbers. This can be done when we have to print a few pages before and want to continue printing the next page.
We can also specify the page number with the number zero, positive or negative. These settings are valid only when we put the page number in the header and footer. When we print without headers and footers numbering, we can directly get printed page Auto.
set the page number excel
How to Set Page Margins
In addition to a set number of pages, there are times when we have to set the margin, the distance of the edge of the writing on the paper size. To set page margins worksheet that will we print, we can use the Margins tab. Where are the Margins tab? Page Setup, pilih tab Margins, sehingga akan tampil kotak dialog Page Setup dengan tab Margins.”>First, not the menu File -> Page Setup, select the Margins tab, so it would appear the Page Setup dialog box with the Margins tab.
set margin margin excel
What is the purpose Margins tab? Margins setting is used to determine the size of the margins or blank space on the edge of the page worksheet that we will print. Some setting margins that we will meet at work using Microsoft Office Excel is:
Top Margin is used to determine the size of the margin at the top.
Bottom. Bottom Margin is used to determine the size of the margin at the bottom.
Left. Left Margin is used to determine the size of the margins on the left.
Right. Right Margins are used to determine the size of the margin on the right.
Header. Header Margin is used to determine the size of the margin in the header (the title of the head).
Footer. Footer Margin is used to determine the size of the margin in the footer (the title of the foot).
Similarly, article tips specify the page number and set the margins on Microsoft Excel worksheet I have to. Hopefully it can help you in your work to make a good and interesting report.