Microsoft Office/Printing in Excel

From Wikibooks, open books for an open world
Jump to navigation Jump to search

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?[edit | edit source]

  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?[edit | edit source]

  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.