How to Print in Excel Like a Spreadsheet Master

Printing spreadsheets doesn't have to be a nightmare...

Excel printing tips - feature

Learning how to print in Excel might seem overwhelming when it comes to printing sheets, workbooks, and specific cell selections. Once you understand your options, it’s easy to print just the parts of your spreadsheet that you need. Of course, you can always print the entire workbook if you want.

Windows 10 and Excel

It’s important to note that Windows 10 isn’t compatible with Office 2007 and earlier. This is why the steps included in this article only apply to Excel 2010 and later.

Some users have had issues printing after upgrading to Windows 10. If you’re trying to figure out how to print in Excel, but nothing is happening, try to print from other apps. If you can’t print, Microsoft recommends updating your printer drivers or running the printer troubleshooter tool.

Related Read: Excel Basics: Tips to Make You Feel Like a Pro

Basic Printing Options

View your printing options and settings by going to File > Print. If you only want to print one sheet out of a workbook, open that sheet before opening the Print menu.

Pro Tip: Select multiple sheets by holding Ctrl and clicking each sheet’s tab.

In the Print menu, you can select your printer and number of copies. Click Printer Settings if you need to alter printer specific settings, such as printing in color or black and white.

The spreadsheet specific options are under Settings, just below the printer options. By default, Print Active Sheets is selected. You can also choose to print a specific selection, a specific sheet, or the entire workbook by using the drop-down menu. If a sheet is more than one page, select your page range or stick with the default, which is the entire sheet.

You’re also able to choose the page orientation and margins. You can set these options before printing by choosing the Page Layout menu tab.

A print preview pane is available on the right of the Print menu. As you make changes to the print options, you’ll see the preview change. Press Print at the top of the menu window to print when you’re ready.

How to Print in Excel: Advanced Options

You don’t have to print an entire sheet or workbook. If you only need to print a group of 20 cells, such as the totals for a financial report, you can do so.

  1. Open your workbook and highlight the cells you want to print.
  2. Go to File > Print and choose Print Selection from the drop-down menu (Print Active Sheets may be selected by default).

Pro Tip: Gridlines don’t print by default.

If you want gridlines to appear in the printed copy, do the following:

  • Choose the Page Layout tab and check the Print checkbox under Gridlines in the Sheet Options group.

Do you have other Excel printing tricks? Share with us in the comments below!

Related Read: Excel Basics: Tips to Make You Feel Like a Pro

Contribution by Crystal Crowder

About the Author

Crystal lives and breathes tech. She’s spent over a decade writing tutorials, reviews, and more on tech, business, and lifestyle sites. Her idea of fun is settling down with the latest tech and gadget news.