Margins are the blank areas along the sides, top, and bottom of a printed page. All printed pages in MS Excel have the same margins and it can’t define separate margins for different pages.
You can set margins with various ways as below
When you click on custom Margins option from Margin button drop down list, the Page setup dialog box will appear with select Margins tab as illustrated right.
There are various options available for custom settings like:
A header is information that appears at the top of each printed page and a footer is information that appears at the bottom of each printed page. By default, new workbooks do not have headers or footers.
You can choose predefined header and footer like Page number, Current Date, Current time, Book Name, Sheet’s Name, Picture etc. or also can add your text into header and footer area by using the option Custom Header and Custom Footer button.
If you don’t want a row to print on a page by itself or you don’t want a table header row to be the last line on a page. MS Excel gives you precise control over page breaks. MS Excel handles page breaks automatically, but sometimes you may want to force a page break either a vertical or a horizontal one so that the report prints the way you want. For example, if your worksheet consists of several distinct sections, you may want to print each section on a separate sheet of paper.
Insert Horizontal Page Break: For example, if you want row 10 to be the first row of a new page, select cell A10. Then choose Page Layout>>Breaks>>Insert Page Break.
In this case make sure to place the pointer in row 1 of particular column in which left you want to insert column break like C1. Choose Page Layout>>Breaks>>Insert Page Break to create the page break.
Page orientation refers to how output is printed on the page. If you change the orientation, the onscreen page breaks adjust automatically to accommodate the new paper orientation.
MS Excel provides various sheet options for printing purpose like generally cell gridlines aren’t printed. If you want your printout to include the gridlines, Choose Page Layout>>Sheet Options group>>Gridlines>>Check Print
Options in Sheet options Dialogue
Page Layout >> Background command This button displays a dialogue box that lets you select an image to display as a background. Background images placed on a worksheet are never printed.