Set The Print Area As Range A2:C16 To Save Hours On Excel Printing Tasks!

How to Set the Print Area in Excel to A2:C16 (And Why You'd Want To)

Ever tried to print an Excel spreadsheet only to watch your printer churn out 47 pages of mostly empty cells? In practice, yeah, I've been there too. That's exactly where the print area feature becomes your best friend.

Setting a print area lets you tell Excel exactly which cells you want on that printed page — nothing more, nothing less. Whether you're printing an invoice, a summary report, or just a clean little data table, controlling your print range saves paper, ink, and your sanity Worth keeping that in mind..

So let's dig into how to set your print area to exactly A2:C16, and I'll walk you through a few different ways to do it Worth keeping that in mind..

What Is Print Area in Excel?

Print area is a built-in Excel feature that defines which portion of your worksheet will actually print. By default, Excel assumes you want to print everything that has data in it — and sometimes it even throws in all those empty rows below and columns to the right that you forgot to delete.

When you set a print area, you're essentially drawing a boundary. Also, anything inside that boundary prints. Anything outside it? Ignored. Simple as that Still holds up..

The range A2:C16 specifically means columns A through C, rows 2 through 16. Row 1 is typically your header row, which you'll probably want to repeat on each printed page — but we'll get to that.

Why This Specific Range?

You might be working on something that fits neatly into a 15-row by 3-column space. Maybe it's:

• A small inventory list
• A contact directory
• A financial summary with three key columns
• A homework assignment (this comes up a lot, actually)

The exact range doesn't matter as much as understanding that you have full control. You can set print area to any range you want — A2:C16 is just the example you're working with right now Most people skip this — try not to..

Why Does Print Area Matter?

Here's the thing — most people don't think about print area until they're frustrated. But once you know how to use it, you'll find yourself setting it constantly That's the whole idea..

It saves resources. Printing 50 unnecessary pages because Excel included 400 empty rows? That's wasteful. Print area fixes that That's the whole idea..

It looks professional. When you hand someone a printed spreadsheet, you want it to look intentional. A clean, properly bounded printout with headers repeated on each page just looks better than a sprawling document with random empty space Not complicated — just consistent..

It prevents confusion. If you're printing multiple copies for a meeting, you don't want people flipping through pages of nothing. Print area ensures everyone gets exactly what they need Worth keeping that in mind..

It works with page breaks. Once your print area is set, Excel's page break preview actually makes sense. You can see exactly where pages will cut off and adjust accordingly.

How to Set Print Area to A2:C16

Now for the main event. There are several ways to do this, and I'll walk you through each one.

Method 1: Using the Page Layout Tab

This is the most common way and probably the easiest.

1. Select the cells you want to print — click and drag from A2 to C16
2. Go to the Page Layout tab in the ribbon
3. Look for the Print Area button (it's in the Page Setup group)
4. Click it and select Set Print Area

You'll know it worked because Excel will likely add a gray border around your selected range, and if you look at the Print Preview, you'll see only those cells.

Method 2: Using the Name Box

This method is faster once you know it, and it feels a bit more precise Worth keeping that in mind..

1. Click in the Name Box (that's the little box to the left of the formula bar that usually shows the cell reference)
2. Type: A2:C16
3. Press Enter — now your range is selected
4. Go to Page Layout → Print Area → Set Print Area

Same result, slightly different path. Some people prefer this because it's less mousing around Surprisingly effective..

Method 3: Using the Print Preview Window

If you're already in the print preview, you can set it from there too That's the part that actually makes a difference..

1. Press Ctrl + P to open the print preview (or File → Print)
2. Look for the Page Setup link at the bottom of the preview window
3. Click it, then go to the Sheet tab
4. In the Print Area box, type: A2:C16
5. Click OK

This is handy when you're already thinking about printing and realize you need to adjust your range Easy to understand, harder to ignore..

Method 4: Using VBA (For Repeated Use)

If you need to set this print area frequently — like in a template you use over and over — you can automate it with a tiny macro.

Press Alt + F11 to open the VBA editor, insert a new module, and paste this:

Sub SetPrintAreaA2C16()
    ActiveSheet.PageSetup.PrintArea = "$A$2:$C$16"
End Sub

Now you can run that macro anytime you need to set the print area instantly. You can even assign it to a button for one-click setup That's the whole idea..

How to Clear or Change Print Area

What if you set the wrong range? Or want to go back to printing everything?

It's easy. Go to Page Layout → Print Area → Clear Print Area. That removes the boundary entirely, and Excel goes back to printing whatever it finds.

To change it to a different range, just follow any of the methods above with your new range selected. Excel automatically replaces the old print area with the new one Less friction, more output..

Common Mistakes People Make

Let me save you some frustration by pointing out what usually goes wrong And that's really what it comes down to..

Forgetting about row 1. If your data in A2:C16 has headers in row 1 (like "Name | Address | Phone"), those headers won't automatically repeat on each printed page. You need to set that separately in Page Layout → Print Titles → Rows to repeat at top.

Not checking the print preview. Always, always preview before printing. What looks right on screen sometimes breaks awkwardly across pages. The preview shows you exactly where page breaks fall Which is the point..

Selecting the wrong cells. It's easy to accidentally include an extra row or miss a row when clicking and dragging. Double-check your selection before setting the print area.

Saving without realizing print area is set. If you save your workbook with a print area defined, that setting stays there. Next time you open it and hit print, you might be confused why only part of your data is printing. The print area is saved with the file.

Ignoring page orientation. If your data is wide, you might need landscape orientation instead of portrait. You can change that in Page Layout → Orientation. This matters more when you have a specific print area — the wrong orientation can make your data look cramped or leave huge empty spaces Worth knowing..

Practical Tips That Actually Help

Here's what I've learned after years of dealing with Excel printouts:

Use Print Titles for headers. If your print area spans multiple pages, set row 1 as a repeat title so every page shows the column headers. Go to Page Layout → Print Titles → Rows to repeat at top Turns out it matters..

Adjust margins for better fit. Sometimes shrinking the margins slightly (Page Layout → Margins → Custom Margins) lets your data fit on one page instead of spilling to a second Turns out it matters..

Check scaling. Under Page Layout → Scale, you can tell Excel to fit your print area to a specific number of pages. "Fit to 1 page" is often the easiest solution when you're not sure how it'll look.

Print gridlines if needed. By default, Excel doesn't print the gridlines you see on screen. If you want them, go to Page Layout → Print → check "Gridlines."

Save as PDF first. Before printing, save as PDF to check how it looks. It's faster than printing, and you can email it to yourself to view on another device. No commitment required Easy to understand, harder to ignore..

FAQ

How do I set print area in Excel to a specific range?

Select the cells you want to print, then go to Page Layout → Print Area → Set Print Area. You can also type the range in the Name Box first, then use the same menu path No workaround needed..

Can I set multiple print areas in Excel?

Not in a single worksheet the traditional way — Excel only supports one print area per sheet. Still, you can work around this by using separate worksheets or inserting page breaks to control what prints on each page Worth knowing..

Why does my print area keep resetting?

This usually happens if you're selecting more cells and setting a new print area, or if you have a macro that's clearing it. Check if you have any macros running on open or close that might be modifying the print area The details matter here. Surprisingly effective..

Will the print area save when I close the file?

Yes. The print area setting is saved with your workbook. When you reopen it, the print area will still be there.

How do I print just the headers on every page?

Go to Page Layout → Print Titles. Under "Rows to repeat at top," specify row 1 (or whichever row has your headers). This ensures those headers appear on every printed page.

The Bottom Line

Setting a print area in Excel is one of those small skills that makes a big difference. Whether you're printing A2:C16 or any other range, knowing how to control exactly what hits the paper saves time, money, and embarrassment.

The Page Layout method is the most straightforward, but the Name Box technique is faster once it becomes muscle memory. Pick whichever feels natural to you and stick with it.

And remember — always preview before you print. It's the easiest way to avoid wasting a whole sheet of paper on a mistake you could've caught in two seconds.