Printing multiple nonadjacent cells on the same sheet in excel 200

[Guest]

I have an invoice that I have set the print area for and it has set every
nonadject set of cells as its own page giving me 26 pages on the same sheet.
I have tried everything help has suggested but nothing has worked. Can this
be done in excel 2002?
Thanks for any help.

 

[MartinW]

Hi Donny,

It's a bit hard to understand your question. Do you mean that Excel
has set your data to 26 pages which you don't want, or are you
trying to get excel to set your data to 26 pages?

Try going to View>Page Break Preview. You can drag your page breaks
around in there by hovering your mouse over the dashed lines and clicking
and dragging to where you want.

Also in Normal view you can select the entire area you want to print
and go to File>Print Area>Set Print Area.

Post back with a better explanation if neither of those are useful.

HTH
Martin

 

[Guest]

Hi,

Excel won't print multiple print areas on the same page.

If a print area contains nonadjacent areas of a worksheet, Excel prints each
area on a separate page by default. However, you can specify that separate
parts of a worksheet print on the same page by using one of the following
methods:

Print nonadjacent columns side by side

Select the columns you don't want to print, point to Column on the Format
menu, and then click Hide.

Set one print area that contains all of the columns, including the hidden
columns.

Print nonadjacent rows above and below each other

Select the rows you don't want to print, point to Row on the Format menu,
and then click Hide.

Set one print area that contains all of the rows, including the hidden rows.

Challa Prabhu