Printing just a section of an Excel worksheet can be a real lifesaver when you’re dealing with large spreadsheets. You might not need to print the entire thing, just a specific range of cells. The good news? It’s a super simple process in Excel 2019. In just a few clicks, you can select the part you want, set the print area, and get your printout without any unnecessary data.
Step by Step Tutorial: How to Print Part of a Worksheet in Excel 2019
Before diving into the steps, let’s understand what we’re aiming for here. This tutorial will guide you through selecting a specific part of your Excel worksheet and printing only that section. Whether it’s a table, a few rows, or a combination of cells, you’ll be able to print exactly what you need.
Step 1: Open Your Excel Worksheet
Open the worksheet that contains the data you want to print.
Opening your worksheet is, of course, the first step. Make sure you have the right file open and that you can see all the data you might want to print.
Step 2: Select the Range of Cells You Want to Print
Click and drag to highlight the cells you want to print.
This step is crucial – be careful to select only the cells you need. If you accidentally include cells you don’t want to print, you’ll waste ink and paper.
Step 3: Set the Print Area
Go to the Page Layout tab, click on ‘Print Area,’ and select ‘Set Print Area.’
Once you’ve highlighted the cells, setting the print area tells Excel that this is the only part of the worksheet you’re interested in printing. You can always clear or change this later if you need to.
Step 4: Check Your Print Settings
Press Ctrl + P to open the print settings and preview your printout.
Here’s where you’ll make sure everything looks right. You can adjust settings like orientation, margins, and scale here. The print preview function is a great way to make sure everything is in place before you actually print.
Step 5: Print Your Selection
Click ‘Print’ to print your selected range of cells.
Once everything looks perfect, go ahead and print. Make sure your printer is on and stocked with paper!
After completing these steps, your printer should spring to life and produce a printout of just the section of the worksheet you selected. No more wasted ink and paper on unnecessary data!
Tips for Printing Part of a Worksheet in Excel 2019
- Preview your printout before printing to ensure that the selection fits well on the page.
- Use the ‘Print Titles’ feature if you want to include row or column titles on every page of your printout.
- Save your workbook after setting the print area, so you don’t have to reselect it every time you print.
- If you need to print a different range, simply clear the print area and select a new one.
- Consider using ‘Page Break Preview’ to adjust where pages are divided if your selection spans multiple pages.
Frequently Asked Questions
What if I need to print multiple, non-adjacent areas of my worksheet?
You can set multiple print areas by holding down the Ctrl key while selecting the different areas. Then, set the print area as usual.
Can I save the print area for future use?
Yes, once you set a print area, it’s saved with the workbook. You won’t have to reselect it each time you open the file.
How do I clear a print area if I no longer need it?
Go to the Page Layout tab, click on ‘Print Area,’ and select ‘Clear Print Area.’
Can I print gridlines along with my data?
Absolutely. Check the ‘Print’ section under ‘Page Layout’ and make sure ‘Print’ under ‘Gridlines’ is checked.
What if my printout is too small to read?
You can adjust the scale in the print settings. Increasing the scale will make the printout larger, but be careful not to make it too big, or it might not fit on the page.
Summary
- Open your Excel worksheet.
- Select the range of cells you want to print.
- Set the print area via the Page Layout tab.
- Check print settings and preview your printout.
- Print your selection.
Conclusion
Printing part of a worksheet in Excel 2019 might seem like a small feature, but it’s incredibly useful. It can save you time, ink, and paper while ensuring that you only share the necessary data. Whether you’re printing a report for work, a project for school, or just trying to stay organized, knowing how to print only what you need is a handy skill.
As you get more comfortable with Excel, you’ll find that this is just one of many features that help you work more efficiently. Keep exploring, and you’ll discover even more ways to make Excel work for you. And if you ever feel stuck, remember that the Excel community is vast and always willing to lend a hand. So go ahead, give it a try – what part of your worksheet will you print today?
Matthew Burleigh has been a freelance writer since the early 2000s. You can find his writing all over the Web, where his content has collectively been read millions of times.
Matthew received his Master’s degree in Computer Science, then spent over a decade as an IT consultant for small businesses before focusing on writing and website creation.
The topics he covers for MasterYourTech.com include iPhones, Microsoft Office, and Google Apps.
You can read his full bio here.