Show-Me  Academy Menu  |  FAQ  |  About  |  Contact  |  See all the latest video tutorials from Show-Me Academy with our RSS feed

Show me how to adjust page breaks and print area in Microsoft Excel 2007

Excel -> Microsoft Excel 2007

Problem: I need to print a piece of my Excel file without sending the entire worksheet to the printer.



  1. Open Microsoft Excel 2007
  2. Click the "Page Layout" tab
  3. On the "Page Setup" section, click the "Breaks" button
  4. On the drop-down menu, click the "Insert Page Break" item
  5. On the "Page Setup" section, click the "Breaks" button
  6. On the drop-down menu, click the "Remove Page Break" item
  7. Note that you can also click the "Reset All Page Breaks" item to remove any page breaks at once
  8. Select a group of cells to be used as the new print area
  9. On the "Page Setup" section, click the "Print Area" button
  10. On the drop-down menu, click the "Set Print Area" item
  11. Select an additional group of cells to be added to the print area
  12. On the "Page Setup" section, click the "Print Area" button
  13. On the drop-down menu, click the "Add to Print Area" item
  14. On the "Page Setup" section, click the "Print Area" button
  15. On the drop-down menu, click the "Clear Print Area" item

Menu  |  FAQ  |  About  |  Contact  |  Terms  |  Privacy  |  RSS
© Copyright 2008 by Show-Me Academy, Inc. - All rights reserved