I am told that in Excel 2003 you could set a print area for multiple
non-adjacent columns and have them print on one page. How would we do this
in 2007? It prints on multiple pages. Must we hide columns and print or set
Custom views and print?

Is there a simple way to do this without macros?

Thanks!

Hi,

There are workarounds but there's no way of doing that in e2003 and AFAIK no
way in e2007.

I common workaround is to copy the non adjacent columns into adjacent
columns on another sheet and print that.

Mike

"hawaiiham2000" wrote:

I am told that in Excel 2003 you could set a print area for multiple
non-adjacent columns and have them print on one page. How would we do this
in 2007? It prints on multiple pages. Must we hide columns and print or set
Custom views and print?

Is there a simple way to do this without macros?

Thanks!

You were misinformed about 2003 and there is no way in 2007 either.

To print non-adjacent columns you can hide the intervening columns, print
visible columns then unhide.


Gord Dibben MS Excel MVP

On Fri, 16 Oct 2009 13:43:01 -0700, hawaiiham2000
wrote:

I am told that in Excel 2003 you could set a print area for multiple
non-adjacent columns and have them print on one page. How would we do this
in 2007? It prints on multiple pages. Must we hide columns and print or set
Custom views and print?

Is there a simple way to do this without macros?

Thanks!