Since the data in excel is stored in large volume, the total data might not required get printed always. The main focus of Excel is to store and manage data. Even though, at the time of printing we should determine the page dimensions and determine the data to be printed from the sheet.

Setting Page Setup:
Page layout tab–>Page setup group

Page button:
Scaling: using this we can reduce or enlarge the printable area to fit into specified page

Margins button:
Specify margins for the page and header and footer
Specify horizontal and vertical centering of data
Print Titles: Specify rows or columns to be repeatedly printed in each page

Setting/clearing printing area:
Page layout tab–>Page setup group–>Print Area

Printing worksheet/workbook:
office button–>print–>print

Options in Print Dialog box:
1. Printer: Select the name of the printer
2. Print Range: Select the number of pages to be printed
a. Copies: Specify the number of copies of each page
b. Print What:
c. Selection: prints only selected part of worksheet
3. Entire workbook: prints entire workbook
4. Active Sheet: Prints selected sheet or sheets

Click preview button to check how the sheet is going to be printed with your selected options

Changing view of Workbook:
view tab–>workbook views group–>Pagebreak preview/page layout

Displaying headings with all records(Freeze Panes):
view tab–>window group–>Freeze panes button

Printing Heading in every page:
Page layout tab–>sheet options group–>check print checkbox
(or)
click on right arrow of sheet options group of page layout tab–>specify rows to repeat at top in the dialog