Tips.Net > ExcelTips Home > Printing > Printing a Portion of a Worksheet
Printing a Portion of a Worksheet
Summary: When printing the data in a worksheet, you are not limited to printing the entire worksheet. Instead, you can print just a portion of the worksheet. All you need to do is make one small change in the Print dialog box, as described in this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)
It is a safe bet that you already know how to print a worksheet. What you may not know is how you can quickly print just a portion of a worksheet. You can accomplish this by following these steps:
- Select the cell range you want to print.
- Choose Print from the File menu. You will see the Print dialog box. (Click here to see a related figure.)
- In the Print What box, choose the Selection option.
- Click on the OK button.
Tip #3242 applies to Microsoft Excel versions: 97 2000 2002 2003
Save Time and Money! Many people need to keep track of employee time, but don't know where to start when it comes to creating a spreadsheet. Here's a way to save time, effort, and money with ready-to-use timesheet templates.
Check out Timesheet Templates today!
Fast Answers!
It doesn't matter if you are a beginner or expert, the ExcelTips archives are the fastest way to improve your productivity. (more information...)
Helpful Links
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site