How can I set selectively printing
You can either set the print area to contain just the columns with the
information you want or you can select an area and use File | Print with the
"Selection" option to just print what you've got selected.
There is definitely NOT a setting to print based on colors or font type.
You'd have to resort to VBA for that.
"Learning Excel" wrote:
I have a lot of worksheets around 250 (and growing )that have demographic
information of people.
1 worksheet per person.
It includes name, last name, dob, address...
The information is scatter left and right, up and down.
Here comes my problem :
I have to print that information ommitting the general information( I'll
call them TITLES :
name, last name, dob, address... because all those TITLES are in a pre printed
page. In conclusion I only want to print the information that changes like :
John Doe, 01/01/1980, 123 excell av. Dallas, Tx...
This parcially worked forme : erasing the TITLES before printing.
Q : is there a setting to print specific information (selectively) in a
worksheet ?
Either using colors, font types... Without VBA.
Thanks for your help.
--
Socrates said: I only know, I don''''''''t know nothing.
I say : I don''''''''t even know, I don''''''''t
know nothing.
|