» Adding non-contiguous ranges to a single contiguous range for printing in Microsoft Excel
CATEGORY - Excel Printing
VERSION - Microsoft Excel 2000 , Microsoft Excel 2002
In Excel 2000 and Excel 2002, you can join non-continuous ranges to form a single contiguous range in order to print them as a single print area.
The Paste All icon is new addition to Excel 2000 and Excel 2002.
Copy two or more separate ranges of cells separately. In Excel 2000 the Paste All icon appears on the Clipboard toolbar. In Excel 2002, press Ctrl+C+C to open the Clipboard pane, or from Edit, select Clipboard.
Select a cell and click the Paste All icon. The ranges that you copied are pasted in order. Now, define these continuous ranges as a single print area and print.
Book Store:
Recommended Books:
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Seven Habits Of Highly Effective People
- Advanced modelling in finance using Excel and VBA
- The 11 Immutable Laws of Internet Branding
No comments have been submitted.
