Printing in Excel 2 - Print Specific Data from a Worksheet in Excel - Set Print Area Excel 2007

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials.

Print only selected or desired data in Excel. This excel video tutorial shows you how to select a single section or multiple sections within a worksheet or workbook in Excel and then to print that area. This video tutorial covers the Print Area feature in Excel. You will learn how to print a single area of a worksheet, set multiple print areas within the worksheet, and how to clear all print areas from the worksheet so that you can print the entire Excel worksheet.

This is a very useful tutorial for printing in Excel and allows you to print only the data that you need printed.

For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Category:

Education

Tags:

• excel
• printing
• data
• print area
• set
• specific
• selection
• important
• part of

[AF0093]

This is great information. Do you know how to select which page to print on a Mac? For instance I have 12 pages sent via PDF out of those 12 I only need to print 1. Do you know how to do this?

[saud10]

many thanks for the illustration. that was really helpful

[HottiesContest21]

Very clear and concise instructions, THANKS.( My stress level just went down a few notches ...)

[Dianabikosi]

This was SO helpful! Thanks for your help whomever you are!

[bridge9389]

thanks man this is great! straight to the point!

[egmontana54]

This is an excellent demonstration on how to print with excel 2007. Easy to understand and he takes you step by step.

egmontana54