Set Print Area & print on one page

H

hawaiiham2000

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!
 
M

Mike H

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 not calculating margins & print area correctly 7
How can I expand print area to whole page? 8
Excel 2007 Multiple Print Areas 0
Print Area 4
Setting print area 1
Print Area Setting 1
Print Area 2003 and 2007 1
email as pdf print area excel 2007 1

Top