TIPS AND TRICKS

Use Page Breaks to Print in Excel 2007

Printing spreadsheets in multiple pages and printing partial spreadsheets are two areas where our students request special help.  To control your print job, go to Page Break Preview (View tab, Workbook Views group) and follow these steps:

  • Insert a vertical page break by selecting the column to the right of where you want the break. Go to the Page Layout tab, click Breaks from the Page Setup group, and click Insert Page Break.
  • Insert a horizontal page break by selecting the row below where you want the break. Go to the Page Layout tab, click Breaks from the Page Setup group, and click Insert Page Break.
  • Move an existing page break by dragging the page break to the preferred location.
  • Delete a page break (manual breaks only; automatic breaks can’t be deleted) by clicking on the page break, going to the Page Setup group, clicking on Breaks, and clicking Remove Breaks.

To remove all manual breaks, return to the Page Setup group, click on Breaks and click on Reset All Page Breaks. Once you’re happy with the page breaks, return to the View tab, go to the Workbook Views book, and click Normal to view  your worksheet the regular way.

 

USE OUR MS OFFICE FOUR AND EIGHT PACKS AND SAVE!

Share these passes with your colleagues for maximum flexibility!

Call for details and Save!


HELP MY WEBMASTER JUST QUIT!

If you change your website's content frequently, use our special software to make the changes without having any web skills.  Visit www.cccsolutions.com or call us to learn more.