Excel Printing Techniques

10 tips for printing Excel spreadsheets

So you’ve made an Excel workbook full of data. It’s well organized, it’s up to date, and you’ve formatted it exactly like you want, so you decide to print out a hard copy … and it looks like a mess.

Excel worksheets don’t always look great on paper because they’re not designed to fit on a page they’re designed to be as long and wide as you need them to be. This is great for editing and viewing on screen, but it does mean your data might not be a natural fit to a standard sheet of paper.

Always before taking print change the view from Normal to Page Break Preview. In this view you can very well see what you are going to print and its almost similar print preview. If your worksheet takes up more than one sheet of paper, consider using page breaks to decide exactly which data should be on which page. When you insert a page break into your worksheet, everything below the break is moved to a different page than everything above it. This is useful because it lets you break up your data exactly the way you want.

Check the following options before you take print:

  • Viewing the page layout
  • Page Break Preview
  • Preview your worksheet before you print
  • Changing the page orientation
  • Adjusting the print area
  • Insert and remove page breaks
  • How to print gridlines
  • Scaling your document for printing
  • Adding a header or footer
  • Adjusting the page margins
  • Freezing Header

Leave a Comment