How to set a print area in Excel

You’ve most definitely put in hours of time and effort to construct your Excel spreadsheet, and now it’s time to print off a small phase of it. The procedure isn’t as simple as printing a unmarried page from Microsoft Word, however you’ve no reason to fret. You may just print all the sheet and spotlight the necessary section, but there’s an easier, extra environmentally-conscious manner. Here is how to set a print area in Excel.

A print area is exactly what it feels like — you handiest print the vital section you want. It’s a smart way to save some paper and make sure that other people received’t be distracted by means of your extra data. Ready to get started?

How to set a print area in Excel

For our instance, we’ll be the use of a sample contact list. You can use a document of your individual or take a few minutes to copy down ours. Just consider that you wish to have to print a choose list of contacts to distribute in a assembly.

1. Select the cells that you need to come with in your print area.

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

3. Select Set Print Area.

4. Now save, shut, and reopen your Excel sheet. It turns out like an unusual step, however bear with us.

5. Head to File and choose Print. You will have to most effective see your print area displayed in the preview.

To take away your print area, apply steps one through 3 again however choose Clear Print Area as an alternative of Set Print Area.

That’s all there is to it. Now you'll be able to print any area of any spreadsheet that you wish to have without wasting paper.

Related: How to insert a checkbox in Excel

How much more can I do?

As you spend increasingly time practicing your Excel abilities, you’ll find yourself crunching numbers like by no means sooner than. If you need to select up the tempo even further, you could be interested in a finding out package that we found on Tech Deals. It teaches you the entirety from the mathematics fundamentals to top-tier functions and takes your Excel talents to the next level.

This finding out equipment is called the Complete Excel Bundle: Startup Toolbox, and it contains 14 unique classes. You can paintings on important enterprise functions like LOOKUP, good judgment functions, and even a little bit of VBA. Almost the whole lot included is business-focused, so it’s definitely worth the cash when you’re hoping to nail down a new activity.

The Complete Excel Bundle: Startup Toolbox has a overall retail worth of $2,800 and more than 20 hours of content, but you can dive in for $39 at this time. Over 500 different fledgling Excel users have already signed up.

Hit the button beneath to find out more.

Was this web page helpful?

You May Like Also

  • Move columns in Microsoft Excel
  • Unhide columns in Microsoft Excel
  • Insert multiple rows in Excel
  • Separate first and last name in Excel
  • Set a print area in Excel
  • Subtract in Microsoft Excel
  • Insert a checkbox in Excel
  • Create a drop down list in Excel
  • Make a pie chart in Excel
  • Make a line graph in Excel
  • How to insert a checkbox in Excel
  • Complete Excel Bundle: Startup Toolbox
  • Complete Excel Bundle: Startup Toolbox
  • How to add cells in Excel
  • How to find the mean in Excel
  • How to move columns in Microsoft Excel
  • How to sum a column in Excel
  • Move columns in Microsoft Excel
  • Unhide columns in Microsoft Excel
  • Insert multiple rows in Excel
  • Separate first and last name in Excel
  • Set a print area in Excel
  • Subtract in Microsoft Excel
  • Insert a checkbox in Excel
  • Create a drop down list in Excel
  • Make a pie chart in Excel
  • Make a line graph in Excel