✦Template Printable Ideas Insights

Print Portion of Excel: How & Where

By

Tired of wasting paper and ink by printing entire Excel sheets when you only need a section of it? You're in the right place. Here's a step-by-step guide on how to print a specific part of an Excel sheet efficiently.

Before we dive into the process, ensure you're using Microsoft Excel 2013 or a later version, as the print area functionality has been improved in these versions.

Setting the Print Area in Excel

The first step in printing a specific part of an Excel sheet is to set the print area. This tells Excel where to start and end printing.

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
How to Set the Print Area in Excel (with pictures)
How to Set the Print Area in Excel (with pictures)
Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know
Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know

To do this, highlight the cells you want to print. Then, go to the 'Page Layout' tab in the toolbar and click on 'Print Area' in the 'Page Setup' group. Select 'Set Print Area' from the dropdown menu.

Using Named Ranges

Named ranges can be used to define and store a range of cells. This is useful when you frequently print the same part of an Excel sheet. Here's how to use named ranges:

7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
How To Print Large Excel Sheet | One Page Print Setup (Excel Tips & Tricks)
How To Print Large Excel Sheet | One Page Print Setup (Excel Tips & Tricks)

1. Select the range of cells you want to name. Go to the 'Formulas' tab and click on 'Define Name'.

2. In the 'New Name' dialog box, enter a name for the range in the 'Name' field and click 'OK'.

Printing using Named Ranges

Once you've set a named range, printing the specific part of the Excel sheet is straightforward. Just select the named range, go to the 'File' menu, click 'Print', and select the printer you want to use. Click 'Print' to print the named range.

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
Free Monthly Budget Excel Spreadsheet
Free Monthly Budget Excel Spreadsheet
Copy Data From One Sheet to Another in Excel
Copy Data From One Sheet to Another in Excel
how to print large excel sheet in one page
how to print large excel sheet in one page
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
50+ Essential Excel Keyboard Shortcuts | Ultimate Cheat Sheet for Beginners
50+ Essential Excel Keyboard Shortcuts | Ultimate Cheat Sheet for Beginners

Remember to remove the print area or delete the named range if you no longer need them to avoid printing the wrong part of the sheet in the future.

Limiting the Print Area to a Specific Sheet

By default, Excel prints the entire workbook when you print a specific sheet. If you want to limit the print area to a specific sheet, you can do so using the following steps:

1. Go to the 'Page Layout' tab in the toolbar.

how to print a large excel spreadsheet on one page
how to print a large excel spreadsheet on one page
[FREE] 141 Free Excel Templates and Spreadsheets
[FREE] 141 Free Excel Templates and Spreadsheets
How to Create Marks Sheet in Excel | How to Make Marksheet in Excel in Hindi.
How to Create Marks Sheet in Excel | How to Make Marksheet in Excel in Hindi.

2. In the 'Page Setup' group, click on the 'Breaks' button and select 'Insert Page Break'. This will tell Excel where to start a new page.

Manual Page Breaks

Manual page breaks allow you to control how Excel formats each page of your printout. Here's how to insert a manual page break:

1. Select the cell below where you want the page break. Go to the 'Page Layout' tab.

2. In the 'Page Setup' group, click on 'Breaks', and then click on 'Manual Break'.

Automatic Page Breaks

Automatic page breaks tell Excel to adjust each page to include as many rows as possible. Here's how to add an automatic page break:

1. Go to the 'Page Layout' tab, click on 'Breaks', and then click on 'Automatic Page Break'.

This will tell Excel to automatically adjust the print area based on the size of your printer paper.

Congratulations, you now know how to print a specific part of an Excel sheet! Whether you're using named ranges or page breaks, you can now easily print just the part of the sheet you need, saving ink and paper. Happy printing!