Microsoft KB Archive/31713

{|
 * width="100%"|

Excel: Noncontiguous Cells Print on Separate Pages

 * }

-

The information in this article applies to:


 * Microsoft Excel for the Macintosh, versions 1.x, 2.2, 3.0, 4.0

-

SUMMARY
When you set a noncontiguous range of cells as a Print Area in Microsoft Excel, each area is printed on a separate page. Microsoft Excel treats each area as its own section when sending the information to the printer; each page will be numbered, and headers and footers will appear on every page.

To print several nonadjacent columns on one page, hide the columns that are not to be printed by setting their width to zero. To set a column width to zero, do the following:


 * 1) Select a cell in the column to be hidden.
 * 2) From the Format menu, choose Column Width.
 * 3) Enter 0 in the Column Width box. Click OK.

After printing, do the following to show the hidden columns:


 * 1) From the Formula menu, choose Goto.
 * 2) Enter the reference of a cell from the hidden column. Click OK.
 * 3) From the Format menu, choose Column Width. Enter a column width, or click Standard Width. Click OK.

MORE INFORMATION
Microsoft Excel versions 2.2, 3.0, and 4.0 also provide the option of hiding rows that you do not want to be printed. To hide these rows, do the following:


 * 1) Select a cell in the row to be hidden.
 * 2) From the Format menu, choose Row Height.
 * 3) Enter a 0 in the Row Height box. Click OK.

Additional query words: discontiguous discontinuous noncontinuous

Keywords :

Version :

Platform :

Issue type :

Technology :