Learn all about Page Layout, Page Setup and Printing in Excel

So, you have worked on an Microsoft Excel worksheet, and it is time for printing that. When you print, however, you find that the printout is not up to your expectations: that, not all the required columns and rows are on a single page, that the report is not centered on the page, that there is no header or footer, that the header row is not repeated in each of the pages and so on. In short, you have a printout that is far from perfect.

So, you have worked on an Microsoft Excel worksheet, and it is time for printing that. When you print, however, you find that the printout is not up to your expectations: that, not all the required columns and rows are on a single page, that the report is not centered on the page, that there is no header or footer, that the header row is not repeated in each of the pages and so on. In short, you have a printout that is far from perfect.

You will get answers to these, and many other questions in this course.

Once you are through the course, you will be able to print out worksheets and or workbooks that are professional looking besides meeting your exact requirements.
So, what you will precisely learn from this course?

In this course, you will learn:

How to layout the page in terms of correct paper size, and orientation.
How to set up the page margins: left, right, top and bottom.
How to insert or adjust or delete a page break so that the new page starts at the exact place where you want.
How to repeat Titles: that is how to add row/column headings to each of the printed pages.
How to format the worksheet background with a logo or picture of your choice and how to apply a theme for the worksheet.
How to toggle printing of gridlines.
How to insert header, footer, page number etc., to the printed report.
How to shrink or enlarge to fit the contents on given number of pages.
How to print only a range of cells or the entire worksheet or workbook.
How to preview before printing, and how to undertake the printer-related settings.
And finally,
How to cancel a print
There is a class project, with a number of exercises, that you can complete to reinforce the learning from the various lessons.