MS Excel Header and Footer

Page Orientation in Excel Tutorial


Page Orientation
Page orientation allows you to define the whether the Excel Sheet will be printed horizontally or vertically in the page. If the print are extend beyond the print area, it accommodates itself into next page on the side or bottom. 
Types of Page Orientation
  • Portrait: This option prints the sheet in the vertical or Tall pattern. It is the default option for page orientation.
  • Landscape: This option prints the sheet in the horizontal pattern. It comes handy when there is large print area horizontally.
Changing Page Orientation
  • The page orientation can be changed to Landscape or Portrait from the Orientation option listed under the Page Layout Tab.
  • Next print the page using Print option in file Tab.

Header and Footer in Excel Tutorial


Header and Footer
Header and Footer allow you to add some text on the top or the bottom of the each sheet that is contained in the Excel File. Header is used for printing the text on top of page while Footer is used from printing on the bottom of the page. By default, both Header and Footer are blank.
Adding Header and Footer
  • You can find the Tab for Header and Footer in the Page Setup dialog box.
Microsoft Excel has a predefined set of header and footer for which you can choose one. You can also design your own.
  • &[Page] : It shows the page number.
  • &[Pages] : It shows the total count of the pages to be printed.
  • &[Date] : It shows the current date
  • &[Time] : It shows the current time
  • &[Path]&[File] : This option lets you put the filename along with the complete path of the workbook.
  • &[File] : This option shows the name of the workbook.
  • &[Tab] : This option shows the name of the current sheet.
Other header and footer options
You can explore several other options in Header and Footer by going into the option of Header and Footer in the Page Layout view. Following are the options available.
  • Different First Page: This option allows you to set a different header and footer for the first page than other pages.
  • Different Odd & Even Pages: This option allows you to set two different header and footer for even and odd pages separately.
  • Scale with Document: This option allows Excel to change the font size of the text in the header and footer to fit the content in the available space. This option is active by default. 
  • Align with Page Margins: This option set the alignment of the header and footer according to the margins. In case of the left alignment, the header and footer shifts towards the left margin and vice versa. This is also the default option. 

Page Breaks in Excel Tutorial


Page Breaks
Excel Allows to apply the page breaks within the sheets, which sets the rows, or columns that will be part of a specific sheet. This option can be used to trim unwanted columns on the right or unwanted rows on the bottom.
The page breaks are applied automatically in Excel sheet. However, you can choose to set page breaks according to your requirement like when you want certain rows or columns at the end or beginning to be or not to be part of the current sheet.
Inserting Page Breaks
You can access the option for the Page Break listed in the drop down list, which appears on clicking the Breaks option listed under Page Layout Tab s shown below in the screenshot.
Insert vertical Page break First, place the mouse pointer anywhere in the first row. Then choose the option for Insert Page Break listed in the drop down list of Beaks under the Tab of Page Layout.
Removing Page Breaks
  • Remove a page break you’ve added: First of all place the mouse pointer in the first row. Then choose the option for Remove Reset All Page Breaks listed in the Breaks under Page Layout Tab. 
  • Remove all manual page breaks: You can do this by choosing the option for “Reset All Page Breaks” listed under the Page Layout Tab in the Breaks.

No comments: