The information in this article applies to:
SUMMARY
If you set a print area that consists of multiple nonadjacent areas, but
you want to print the areas on one page, Microsoft Excel will print each
separate area on a separate page.
MORE INFORMATION
In certain cases, this workaround will not work. For example, if you have
one area to the right of another, and you want these areas printed one
above the other, the typical workaround would be to copy the second area
below the first and set a single print area. However, if your column
widths do not align correctly, this workaround will not work.
Microsoft Excel Version 5.0 or EarlierUse the following steps to take a picture of the second area and place it below the first:
REFERENCES
"User's Guide 2," version 4.0, page 512 Additional query words: 3.0 4.0 contiguous noncontiguous Discontiguous ranges
Keywords : xlprint |
Last Reviewed: March 22, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |