Create a Header or Footer,Set Page Margins,Change Page Orientation & Set Page Breaks

Create a Header or Footer,Set Page Margins,Change Page Orientation & Set Page Breaks

    Create a Header or Footer
    To create a header or footer:
    • Click the Header & Footer button on the Insert tab
    • This will display the Header & Footer Design Tools Tab
    • To switch between the Header and Footer, click the Go to Header or Go to Footer button
    Header & Footer
    • To insert text, enter the text in the header or footer
    • To enter preprogrammed data such as page numbers, date, time, file name or sheet name, click the appropriate button
    • To change the location of data, click the desired cell
    HF

    Set Page Margins
    To set the page margins:
    • Click the Margins button on the Page Layout tab
    • Select one of the give choices, or
    Set Page Margins
    • Click Custom Margins
    • Complete the boxes to set margins
    • Click Ok
    Custom Margins
    Change Page Orientation
    To change the page orientation from portrait to landscape:
    • Click the Orientation button on the Page Layout tab
    • Choose Portrait or Landscape
    Page Orientation
    Set Page Breaks
    You can manually set up page breaks in a worksheet for ease of reading when the sheet is printed. To set a page break:
    • Click the Breaks button on the Page Layout tab
    • Click Insert Page Break
    Page breaks

Last modified: Wednesday, 11 January 2012, 11:06 PM