Microsoft Office/Printing in Excel

The page breaks can be changed on an Excel spreadsheet so that it prints a bit nicer. This can also help to reduce the number of pages that get printed.


 * 1) First, check out how it is currently set to print with File > Print Preview.
 * 2) Second, if you want to change the page breaks, at the top of the print preview, click the “Page Break Preview” button.
 * 3) Now you will see the spreadsheet broken up by dashed lines with a faint page number in each region.
 * 4) You can move these dashed lines to change the page breaks.
 * 5) Do File > Print Preview again and you will see how the change affects the printing.
 * 6) You will also see “Page Break Preview” option has changed to “Normal View”
 * 7) You can also find “Page Break Preview” and “Normal View” under View in the menu bar.

What if you want to print only part of the spreadsheet?

 * 1) Highlight the area that you want to print.
 * 2) From the menu bar, select File > Print Area > Set Print Area
 * 3) Now when you go to File > Print Preview, you will see only the area that you highlighted.
 * 4) To go back to printing the entire document, use File > Print Area > Clear Print Area

Not able to highlight the region you wanted to print?

 * 1) Go to File > Page Setup
 * 2) Click the Sheet tab
 * 3) In the box marked “Print Area” you can click the tiny spreadsheet icon.
 * 4) This will reduce the box and allow you to highlight what you want (or something close to it).
 * 5) You will see the cell range appear in the “Print Area” box.
 * 6) Edit the string to get it to cover what you want, and click on the icon at the end of the box.
 * 7) Now hit File > Print Preview
 * 8) Remember to remove these settings if you want to print something else.