✦Template Printable Ideas Insights

How to Print Part of an Excel Spreadsheet

By

Ever found yourself looking at a sprawling Excel spreadsheet, wishing you could isolate just a specific subsection? While Excel doesn't offer a 'Print Part' button, there are easy, efficient ways to do this. Let's explore how to print only part of an Excel spreadsheet.

Whether you're dealing with intricate financial data or simple to-do lists, knowing how to extract a relevant section can significantly streamline your workflow.

Print Specific Rows

For those needing to print certain rows, Excel offers two methods: selecting cells or using Go To Special feature.

How to Set the Print Area in Excel (with pictures)
How to Set the Print Area in Excel (with pictures)
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step

To select cells, simply click and drag your mouse over the desired rows. A thin border will appear around the selected range. Hit Ctrl + P (Windows) or Command + P (Mac) to open the Print dialog box.

Using Go To Special Feature

If you need to print a continuum of rows, use Go To Special. Click inside your data range, then click Data > Filter > AutoFilter. For example, if you want to print row 5 to 10:

Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
a screenshot of an excel spreadsheet with arrows pointing to the text area
a screenshot of an excel spreadsheet with arrows pointing to the text area
a spreadsheet in excel for beginners
a spreadsheet in excel for beginners
  1. Select row 5.
  2. Press Shift key, then choose row 10.
  3. Right-click and select 'Go To Special', then choose Rows.
  4. Hit Ctrl + P (Windows) or Command + P (Mac) to print.

Printing Specific Columns

Similar to printing rows, you can print specific columns by selecting them first. For instance, to print columns B and D from row 5 onwards:

  1. Click on column B.
  2. Press Ctrl key, click on column D.
  3. Press Ctrl + [ (Windows) or Command + [ (Mac) to collapse the selected columns.
  4. Right-click on Row 5, Go To Special > Constants, then click Ok.
  5. Hit Ctrl + P (Windows) or Command + P (Mac) to print.

Printing Part of a Spreadsheet Using Print Areas

A more sophisticated approach involves setting Print Areas. This allows you to define specific ranges to print, even if they're not adjacent.

Let's say you want to print rows 5-10 and columns B-D:

Client Challenge
Client Challenge
[FREE] 141 Free Excel Templates and Spreadsheets
[FREE] 141 Free Excel Templates and Spreadsheets
Free Monthly Budget Excel Spreadsheet
Free Monthly Budget Excel Spreadsheet
how to print a large excel spreadsheet on one page
how to print a large excel spreadsheet on one page
a spreadsheet with the text please stop consollating data in excel like this
a spreadsheet with the text please stop consollating data in excel like this
How to Create Professional Looking Excel Spreadsheets
How to Create Professional Looking Excel Spreadsheets

Setting Print Areas

To set a print area:

  1. Select the range you want to print.
  2. From the File menu, choose Page Setup (or press Alt + P).
  3. In the Print Setup tab, under the "Print what?" section, choose "Print Area", then click Ok.

Next time you print, only the set Print Area will print.

Printing only part of an Excel spreadsheet might seem daunting initially, but it's a breeze once you get the hang of it. Remember, practicing will help you discover more tricks to streamline your Excel tasks. Happy printing!

Change the Gridline Color in Excel Spreadsheets - 2 Ways!
Change the Gridline Color in Excel Spreadsheets - 2 Ways!
How to Set the Print Area in Microsoft Excel
How to Set the Print Area in Microsoft Excel
Excel How-To: Starting a Basic Spreadsheet
Excel How-To: Starting a Basic Spreadsheet
the advanced excel chart sheet is shown in green and has instructions on how to use it
the advanced excel chart sheet is shown in green and has instructions on how to use it