Excel printing multiple columns

[nevstic]

Good morning all
I wonder if anyone has the answer to the following please.

I have for example 2 columns , column "A" and column "D"
which I want to print on one page.When I highlight both columns by the cntrl key and to set the print area it still prints the "in between" columns as well. Also I am aware of the "hide" function for these unwanted columns.
But is there an easier way of highlighting and printing just what is highlighted on one page ?

thanks and best rgds
Nick

 

[DaleWatson123321]

Nick,

In response to your question... is there an easier way of highlighting and printing just what is highlighted on one page ? I dont know of any "manual" method of highlighting and printing.

However, if you want to consider different methods of "automation"... here are a couple of options.

Option 1

a) You could set up (non-printing) check-boxes for each of the columns you would potentially want to hide.

b) The user would then check off those columns NOT to be printed by checking the boxes.

c) You could write (record if necessary) VBA code to hide the columns checked off.

d) Attach the code to a macro button which would (also) be for printing, and then include code to unhide the columns after printing.

Option 2

This second option can be more difficult to set up, if you don't have any experience with Excel's "database extraction process". This is on Excel's menu under: Data - Filter - Advanced Filter. There are a couple of bugs in the form of (false) error messages that discourage some users from using this option. For example, a bug will display an ERROR message that says you cannot extract data to a SEPARATE sheet. Ironically, you can't IF you attempt to do so "manually" via the menu, because the ERROR message itself STOPS you from doing so - even though Excel DOES DEFINITELY allow for extracting data to a SEPARATE sheet.

Using VBA it IS possible to extract data to a separate sheet, AND there are MANY advantages to using this feature. For example, one can extract data "selectively", based on "criteria" you specify. And the "criteria" can be as precise as required in order to extract out the exact data you wish to extract.

Also, when the data is extracted, one can re-arrange the order of the field names. This can sometimes be advantageous.

If you wanted to go with Option 2, I have a variety of "example files" I can email you that should give you a "jump start" - for your current situation, and for other applications.

I hope this helps. Please advise as to how you make out, whether you need more help, and whether you'd like the example files.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[nevstic]

Hiya Dale
Many thanks for your detailed reply
I would indeed like to see the code of option2
and thanks very much.

Vbest rgds
Nick

 

[VulcanJedi]

Can't you goto menu, FILE-PRINT..., then select Print what-Selection? Tranpkp
************************************
- Let me know if this helped/worked!
Please remember to give helpful posts the stars they deserve!
This facilitates others navigating through the threads / posts!