Pinterest Stumbleupon Whatsapp
Ads by Google

Excel is a fantastically useful 7 Fun & Weird Things You Can Create With Microsoft Excel 7 Fun & Weird Things You Can Create With Microsoft Excel Imagine Excel was fun! Excel offers plenty of scope for projects that go beyond its intended use. The only limit is your imagination. Here are the most creative examples of how people are using Excel. Read More spreadsheet program, but there’s nothing worse than creating a perfect spreadsheet and printing it only to see it come out on nine sheets of paper, including a single row on the last one. What good is a beautifully crafted spreadsheet if it looks terrible on paper?

Fortunately, you can tweak your spreadsheet and the program settings to get everything on one page, and to make that page look as good as possible. If your spreadsheet is just too big for a single page, you can use these settings to distribute it over a number of pages more agreeably.

Preview Before You Print

This is an important step—you can head off a lot of problems before you print if you just know about them. If you print and then check to see how well it worked, you might end up wasting a lot of paper Manage Printing Costs & Cut Paper Waste By Setting Up A Print Server with PaperCut Manage Printing Costs & Cut Paper Waste By Setting Up A Print Server with PaperCut Read More  trying to get that last row or column onto the paper.

Depending on your version of Excel, you might have to click File > Print Preview, File > Print > Print Preview, or just File > Print to see what your spreadsheet will look like when it comes out of the printer. If it looks good, go ahead and print. If not, try some of the strategies listed below!

Use the Page Layout View

The page layout view will show you how your document will print while you’re working on it. It’s not a great view for working on your spreadsheet, but it can help you make adjustments to ensure that your columns and rows make the most of the space that you have. To activate the view, go to View > Page Layout.

excel-layout-view

Ads by Google

Now you’ll see your spreadsheet as it would be printed. Making adjustments using the tools listed below while in this view will give you a better idea of whether or not they’ve worked well. (This same functionality is available in Word, and can help you create professional-looking documents How To Create Professional Reports & Docs on Word How To Create Professional Reports & Docs on Word This guide looks at the elements of a good report, as well as review the structuring, styling, and finalizing of your document. Read More  there, too.)

Change the Page Orientation

If your spreadsheet is wider than it is tall, a horizontal orientation will help you fit more of it on a page. A taller spreadsheet will likely benefit from a vertical orientation. To choose which orientation your spreadsheet uses, open the Page Setup menu and choose Portrait or Landscape under the Page tab.

page-orientation-excel

Delete or Hide Rows or Columns

In large spreadsheets, there are often rows or columns that are redundant, contain old information, or just don’t need to be printed in a particular situation. These rows and columns take up valuable real estate on the page and can make it much  more difficult to get your spreadsheet to fit nicely.

excel-hide-columns

If you can delete some of that data, just use the familiar highlight > Edit > Delete sequence to get rid of them. If they contain information that you think you might need again sometime later, you can hide them by right-clicking on the row or column header and selecting Hide. To see the data again, highlight the rows or columns on either side of the hidden data, right-click on the label, and select Unhide.

Use Page Breaks

Just like in your favorite word processing program, you can insert page breaks to make sure that your spreadsheet is split between multiple pages where you want it to be, instead of where Excel decides it’s convenient. Just use Insert > Page Break to tell Excel where to split your document.

Change the Print Area

If your spreadsheet has a huge amount of data and you only need to print some of it, you can print just the part of the spreadsheet that you select. Select the cells that you want to print and click Print. Change the Print What: option to Selection, and the preview will update to contain only the data that you’ve selected.

excel-set-print-area

If you tend to print the same selection on a regular basis, you can set a permanent print area that encompasses just that section so you don’t have to select it each time. To do this, select the area you print frequently, then go to File > Print Area > Set Print Area. Now this selection will become the standard print area for your spreadsheet. To get rid of that setting, use File > Print Area > Clear Print Area.

Change Page Margins

If you need just a little more room to fit your spreadsheet on a page, adding some extra space to the margins of the page can solve your problem. You can access the Page Setup dialog either from File > Page Setup or with the Page Setup button in the print dialog. Add a fraction of an inch to each margin and check the print preview again.

excel-change-margins

It’s easy to go overboard with adding room in the margins to fit as much as possible on a page. However, remember that text running all the way to edge of a piece of paper is not only aesthetically unpleasing, but can also be hard to read. Be judicious with this one!

Wrap Text and Resize Columns

Excel is usually used for numerical data, but it can be really useful for text Saving Time with Text Operations in Excel Saving Time with Text Operations in Excel Excel can do magic with numbers and it can handle characters equally well. This manual demonstrates how to analyze, convert, replace, and edit text within spreadsheets. These basics will allow you to perform complex transformations. Read More as well. If you have a lot of text in your cells, they can really stretch out your spreadsheet and make it difficult to fit it on one page, or even on multiple pages; you might end up with a weird printing scheme that makes your document look like this:

excel-long-text

Some of the text is cut off, and the cells that aren’t cut off run way too far to the right. To limit the width of your spreadsheet to the width of a single page, you can limit the width of your columns and use text wrapping to make sure that you don’t lose any of the data that you want printed. First, go to Format > Cells > Alignment and make sure Wrap Text is enabled.

excel-wrapped-text

Now, when the text in a cell is wider than the column width, the text will wrap down to the next line. From here, you can adjust the widths of your columns by dragging the edge of a row or column header to resize it.

You can also double-click on the row or column labels to automatically make them as wide as necessary, as shown in the video below. To make sure that your columns fit on a page like you want them to, use the page layout view mentioned above.

Scale Your Spreadsheet

If nothing else has done the job, you can scale your spreadsheet so that it fits onto a single page (or a certain number of pages). In Page Setup, click the radio button next to Fit to: and choose the number of pages that you’d like your spreadsheet to print on. Selecting a smaller number of “wide” pages will scale the document horizontally, and selecting a smaller number of “tall” pages will scale it vertically. You can also select a percentage scale.

excel-scaling-setup

Using the scaling option can help limit the size of your document when it’s put on paper, but it can also make your text very small and difficult to read. Do check the preview and make sure that you’re not scaling so far that it’s impossible to read any of your data. Scaling is really useful when you’re trying to print Excel charts 8 Types of Excel Charts & When You Should Use Them 8 Types of Excel Charts & When You Should Use Them Graphics are easier to grasp than text and numbers. Charts are a great way to visualize numbers. We show you how to create charts in Microsoft Excel and when to best use what kind. Read More , too.

Making Your Printout Easier to Read

Once you’ve managed to get your spreadsheet on an acceptable number of pages, go a step further and make it as easy to read as possible. By tweaking a few other print settings, you can optimize the look of your printout. Here are a couple you should know about.

Printing Gridlines and Row or Column Headings

In the Page Setup menu (accessed via the print dialog or File > Page Setup), click on the Sheet tab and select Gridlines under the Print section. You can also select Row and column headings to add these labels to your printout.

excel-print-settings

Adding Header and Footer Information

Excel can automatically add useful information to the header and footer of your document to make it easier to read. In the Page Setup menu, click on the Header/Footer tab and use the dropdown menus to add information like page number, file name, and author name to the header or footer. If your spreadsheet is really long, this information can help keep the pages organized more easily.

You can also add custom text by clicking on Customize Header or Customize Footer.

Don’t Settle for Poorly Printed Spreadsheets

It can be frustrating trying to get your spreadsheet to look good when you print it—especially if you have to get it on a single page. But with a few tweaks to settings and format of your document, you can produce a nice printout! Don’t forget to learn other tips for Excel success in the office 5 Microsoft Word & Excel Skills You Must Have to Succeed at the Office 5 Microsoft Word & Excel Skills You Must Have to Succeed at the Office "Get that report to me, ASAP!" A core set of Microsoft Excel and Word tricks can make this task less stressful and help you whiz up a stylish report in no time. Read More while you’re at it, too.

Have any other tips for printing spreadsheets from Excel? Share them below!

Image Credits:businessman with question mark by Dooder via Shutterstock

  1. Rebou Chage
    September 24, 2015 at 6:27 am

    Don't forget to make a wider margin at the left of your page for portrait format, and at the top for landscape format to accomodate the punched holes for filing the hard copy. Many don't do this and thus the punched holes delete some of the text on these narrow margins.

    • Dann Albright
      September 27, 2015 at 3:22 pm

      Ah, that's a really great point. I haven't punched anything in a while, so I forgot that. Great thing to keep in mind!

Leave a Reply

Your email address will not be published. Required fields are marked *