How to set a print area in Excel

Sometimes you might find that you need to print a small part of your Excel spreadsheet. You could always print the whole sheet and just highlight the important section, but there’s an easier way. Here are some tips on how to set a print area in Excel.

A print area is exactly what it sounds like — you only print the important area you need. It’s a great way to save some paper and make sure that people won’t be distracted by your extra data. Ready to get started?

How to set a print area in Excel

For our example, we’ll be using a sample contact list. Just imagine that you need to print a select list of contacts to distribute in a meeting.

1. Select the cells that you want to include in your print area.

2. Go to the Page Layout tab and find the Page Setup group. Now click Print Area to open a menu.

3. Select Set Print Area.

4. Now save, close, and reopen your Excel sheet.

5. Head to File and select Print. You should only see your print area displayed in the preview.

To remove your print area, follow steps one through three again but select Clear Print Area instead of Set Print Area.

That’s all there is to it. Now you can print any area of any spreadsheet that you want without wasting extra paper.

How much more can I do?

The more Excel skills you learn, the more effective you’ll be at crunching numbers. If you want to accelerate your journey, you might be interested in a learning kit that we found on Tech Deals. You can work on everything from basic skills to advanced functions and take your Excel abilities to the next level.

This learning kit is called the Complete Excel Bundle: Startup Toolbox and it includes 14 unique courses. You can work on tons of important business functions like the LOOKUP function, logic functions, and even a little bit of VBA. Many of the lessons are business-focused so they should look great on your resume.

The Complete Excel Bundle: Startup Toolbox has a total retail value of $2,800 and more than 20 hours of content, but you can dive in for $39 right now. Over 250 others have already signed up.

Hit the button below to find out more.

$39 .00

The Complete Excel Bundle: Startup Toolbox

Save $2761 .00

Buy it Now

The Complete Excel Bundle: Startup Toolbox Buy it Now

Save $2761 .00 $39 .00

Via Phandroid