XL: Printing Nonadjacent Areas on One Sheet

• Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a, 5.0
• Microsoft Excel for Windows 95, version 7.0
• Microsoft Excel 97 for Windows

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.

To work around this behavior, hide the columns and rows between the areas and set a single, continuous print area to print everything on one 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 Earlier

1. Highlight the second area.



2. Click the Camera tool on the Utility toolbar.



3. Place the insertion point in the appropriate position below the first area and click. A picture of the second area will be placed below the first.



4. Set a new print area that contains the picture.

REFERENCES

"User's Guide 2," version 4.0, page 512
"Microsoft Excel User's Guide," version 3.0, page 522

Additional query words: 3.0 4.0 contiguous noncontiguous Discontiguous ranges

Keywords          : xlprint 
Version           : WINDOWS:3.0,4.0,5.0,7.0,97
Platform          : WINDOWS 
Issue type        : kbhowto 

Last Reviewed: March 22, 1999