Print Area Printing

[Guest]

Greetings;

I want to print two columns. I have selected 10 rows on one column, held the
control key down and select the corrisponding rows on a column about 10
columns over on the worksheet. ex: column A and Column L, rows 10 - 20
respectfully.

I have then gone to the file, print area, set print area. fine to this point.

I then got to print preview and seen the areas to print are sellected
althouth 10 columns apart.... I then sellect pint and the two columns print
on two different pages.

Is there any way to get the two columns to print next to each other on the
same piece of paper (side by side as it were columns A & B) so the data can
be compared?

Right now the two columns print on two different pieces of paper and I have
to cut and paste the two columns together. and then copy for the 32 different
board members.

 

[Guest]

Hide the columns in between the two columns that you do want printed?

 

[Guest]

Works like a charm. Thanks for the help. You have saved me a great deal of
work for all future board meetings.

Thanks...

 

[Gord Dibben]

David

Just for info.

You can create Custom Views with print settings under View>Custom Views.

Create a custom view of your sheet as it now looks.

Create another view with those columns hidden.

If need to print that view again, just go to custom views and select the one you
created.


Gord Dibben MS Excel MVP