98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel printing
Excel printing
Resolved · Low Priority · Version Standard
Naomi has attended:
Excel Intermediate course
Excel printing
how do you set up print preferences in excel (eg set print area).
Printing printsetup ranges
Hi Naomi
Your question is a bit vague - do you mean how can you set up multiple print ranges on one sheet or do you mean where is the set print area command? I assume you mean the first.
For multiple print ranges, the easy way is to name each range you want to print. Then select the range you want to print from the NAME box.
Choose FILE then PRINT, click on the SELECTION option in the dialog and click the Print button.
Each time you do this you will print a different range from the same sheet.
Good luck!
Alan
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Select blank cells automaticallyGet Excel to find any blank (empty) cells in a region for you by: |