Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Printing non-adjacent columns
Hi
I have approx. 30 columns but I only want to print non- adjacent ones for example. Column B, E-G, K and P. I have tried setting print area but that will give me one column on one page. Can this be done on the same page?? Thanks in advance Ann |
#2
|
|||
|
|||
Try hiding the columns that you don't want to print.
"Ann Shaw" wrote: Hi I have approx. 30 columns but I only want to print non- adjacent ones for example. Column B, E-G, K and P. I have tried setting print area but that will give me one column on one page. Can this be done on the same page?? Thanks in advance Ann |
#3
|
|||
|
|||
Hi Ann-
Just to expand on Kerry's reply, if this is something you need to do repeatedly, you may want to look into the following features: 1) DataGroup and Outline 2) ViewCustom Views Using either or both can save a lot of time for viewing as well as printing... and you don't need to get involved with macros. Hope this is useful |:) "Ann Shaw" wrote: Hi I have approx. 30 columns but I only want to print non- adjacent ones for example. Column B, E-G, K and P. I have tried setting print area but that will give me one column on one page. Can this be done on the same page?? Thanks in advance Ann |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why can't a copy and paste columns? | Excel Worksheet Functions | |||
print excel columns on less pages | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Printing multiple columns on one page | Excel Discussion (Misc queries) |