Microsoft Office Tutorials and References
In Depth Information
Printing Noncontiguous Ranges on a Single Page
Printing Noncontiguous Ranges on a Single Page
Excel lets you specify a print area that consists of noncontiguous ranges. Press Ctrl while you
select the ranges to print and then choose Page Layout
Page Setup
Print Area
Set Print Area.
After you’ve defined a print area, you can use Page Layout
Page Setup
Print Area
Add to
Print Area to specify additional ranges to print.
When you set up a noncontiguous print area, Excel always starts printing each range on a
separate sheet of paper. This tip describes a technique that allows you to print multiple ranges on a
single page.
The trick involves creating a linked picture of each of the ranges to be printed and then arranging
these pictures on a separate worksheet. Here’s one way to create a linked picture:
1. Select the range.
2. Press Ctrl+C.
3. Activate a different cell.
4. Choose Home
Clipboard
Paste
Linked Picture.
Fortunately, Excel has a much more efficient tool for the job: the Camera tool (which, for some
reason, Microsoft keeps rather hidden).
Breaking out the Camera tool
To add the Camera tool to your Quick Access toolbar, follow these steps:
1. Right-click the Quick Access toolbar and choose Customize Quick Access Toolbar to
display the Quick Access Toolbar tab of the Excel Options dialog box.
2. In the drop-down list on the left, choose Commands Not in the Ribbon.
3. Select Camera in the list.
4. Click Add to add the Camera tool to your Quick Access toolbar.
5. Click OK to close the Excel Options dialog box.
The Camera tool creates a linked picture of a range. Therefore, if the data in the linked range
changes, the picture is updated automatically.
Figure 185-1 shows a worksheet. The goal is to print two ranges (A3:C10 and E13:G20) on a single
page.
 
Search JabSto ::




Custom Search