We help IT Professionals succeed at work.

Having A Dull Moment! Printing selected Columns Only

SiddharthRout
on
Say, in sheet1, I have data from A1 to D16. What should I do so that when printed, only columns A and D will print on a single page. This has to be achieved without hiding columns B or C. Cannot use "Grouping" as well because that would again hide Col B and C.

Sid
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010
Commented:
Sid, I don't think this can be done without hiding the columns. Although you can select non-contiguous ranges and assign them to the Print Area, they will print on separate pages.

cheers, teylyn
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010

Commented:
You may want to employ a helper sheet that references the desired columns and displays them contiguously.

Author

Commented:
>>>Although you can select non-contiguous ranges and assign them to the Print Area, they will print on separate pages.

Yeah I tried that but like you mentioned, it goes into separate pages.

I don't want to use any helper sheets.

You after all may be right. It might not be possible...

Let's wait for more inputs?

Sid
CERTIFIED EXPERT

Commented:
Can you just edit the page breaks to your liking in the print preview by draging the page breaks around?


Since your columns are not right next to each other I would create a second set of columns Idential to the others  

ie column E = Column A and column F = Column D

Author

Commented:
Thanks ScriptAddict. :)

I have already tried playing around with page breaks, print area, searching every nook and corner of Excel but couldn't find a setting which would just let me do what I want without using helper columns...

I even tried(Though I knew it wouldn't help) just selecting Col A and Col D and then doing a print selection only. That also goes in two separate pages. :)

I guess Teylyn might be right that it is not possible.

Sid

Author

Commented:
There is one more way (but I am not looking for this as well)

I can change the background color of the cols B and C to "No Fill" and change the font foreground to "White" and then print it :D

It's just that I was expecting an inbuilt easy way...

Sid
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010

Commented:
Sid, even Ron deBruin resorts to a helper sheet

Author

Commented:
Yes, I know about that method.

Unfortunately if there is no way then I will have to stick with my initial option of hiding Columns or using 'Groups". Much better than using Helper Columns or Sheets :-D

Here's what I will do. I will close this question and if someone comes with an answer that I am looking for then I guess you can re-open it for me :)

Sid

Author

Commented:
Apparently what I want cannot be achieved without Hiding/Grouping/Use of Helper sheets/columns :(

Explore More ContentExplore courses, solutions, and other research materials related to this topic.