Printing in Excel can sometimes be complicated. Learn about Excel printing, including setting the right print area, in this lesson.


  1. Open an existing Excel 2010 workbook. If you want, you can use this example.
  2. Try printing two active worksheets. If you are using the example, try printing the worksheets labeled 2009 and 2010.
  3. Try printing only a selection of cells.
  4. Change the page orientation to landscape.
  5. Try fitting a large worksheet on one page.
  6. Try modifying the margins of a worksheet in Print Preview.
  7. If you are using the example, use the Print Titles command to make row 1 and column A appear on every page.
  8. Create a page break so only columns A and B appear on one page.