» Printing Non-Continuous Areas
CATEGORY - Excel Printing
VERSION - All Microsoft Excel Versions
To set non-continuous areas and add them all to the Print area:1. Select a range of cells.
2. Press Ctrl and select another area. Repeat this as many times as you need.
3. Click the Print Area icon (if the icon is displayed in the Standard toolbar).
OR
From the File menu, select Print Area, and then Set Print Area.
Each area within the print area will be printed on a separate page.
To combine non-continuous ranges into a single range in Excel 2000, Excel 2002 and Excel 2003:
1. Copy each range (in Excel 2000, the Clipboard can hold up to 12 different copied areas).
2. In Excel 2000, press Ctrl+C+C to display the Clipboard; in Excel 2002 & Excel 2003, press Ctrl+C+C to open the Clipboard Task Pane.
3. Select the Paste All icon and paste all copied ranges into one single range.
Book Store:
Recommended Books:
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Financial Statement Analysis with S&P insert card
No comments have been submitted.
