Trouble adding non-adjacent cell columns to a print area

[JoAnn]

Hi,
I can't seem to add non-adjacent columns to my print area
in Excel 2000 and don't know what I'm doing wrong.

I'm defining my area (in page break view) by 1st selecting
the 1st 4 columns (which happen to be adjacent) and
setting them as the print area. I then select each
additional non-adjacent column, right-click a cell in it
and select "Add to Print Area".

According to the Help text, this is supposed to work. But
all I ever get is the first 4 (adjacent) columns. The rest
don't print or display in print preview.

So what am I doing wrong? I've tried clearing the print
area and resetting it but it doesn't change the outcome.

Thanks!
JoAnn

 

[Frank Kabel]

Hi
also see:
http://www.rondebruin.nl/print.htm#non-contiguous

 

[CLR]

I don't get that "Add to Print Area" option in my XL2k, but I can just hide
the columns I don't want to print, and then select the visible area that I
do want to print.....maybe that would work for you,........and if you have
to do it often, you could record a macro to minimize the steps............

Vaya con Dios,
Chuck, CABGx3

 

[Debra Dalgleish]

If the areas are non-contiguous, they'll print on separate pages, and
will appear on separate pages in the print preview.

Did you click the Next button, at the top left of the preview window?
Does the status bar, at the bottom left of the preview window, show page
numbers, e.g. Page 1 of 4?

 

[Guest]

I didn't get add to print area on my 2k either. hiding the
non adjacent columns seem the best idea. you can create a
hide macro on record. then an unhide macro.

 

[JoAnn]

Thanks for all the info!! The problem was that they
didn't print contiguously, which threw me off. I finally
managed to get it to do that by hiding cells I didn't want
and redefining my print area (as suggested). It is now in
a macro.

Only problem remaining is how to get my print area to
ignore blank rows a) within the spreadsheet and b) at the
end of the spreadsheet (two different scenarios I need to
address).

I want this to be part of the macro so it has to allow for
new rows of info being added in the future. Is there a
setting somewhere that controls this?

Thanks again!!

 

[CLR]

Hi JoAnn...........

Depending on how your data is situated, you might try Data > Filter >
Autofilter, and then filter a Key column on "non-blanks".............this
can also be recorded into a new macro and then cut and pasted into your
existing one............

Vaya con Dios,
Chuck, CABGx3