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.

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.

Your second options might work for me "select area, File/ Print with the
selection"
This will have to be done everytime I print ?
or back to the original question : How can I set it up to print just the
select area
everytime I hit the printer icon ?
I'm trying doing this : select the wanted printed area.
give it a name.
then I get stuck.
THANKS

--
Socrates said: I only know, I don''''''''t know nothing.
I say : I don''''''''t even know, I don''''''''t
know nothing.


"JLatham" wrote:

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.

Don't worry about giving the area a name. Excel can do it all for you. Open
the workbook and select the sheet. Then choose File | Page Setup and click
on the [Sheet] tab.
Click in the entry area at the top marked Print Area and then go to your
sheet and select the area that you want to be printed. With the area
selected, click the [OK] button on the Page Setup dialog. Now every time you
print that sheet, the area you selected will be what gets printed.
This even works for areas that don't touch one another. Lets say all you
want to print are two square areas: A1:C3 and H9:J11 you could select all
of A1:J11, or you could first select A1:C3 and then, while holding the [Ctrl]
key down, select H9:J11 and then click the [OK] button on the Page Dialog.
This method can be extended to sevaral separated areas on a sheet.

"Learning Excel" wrote:

Your second options might work for me "select area, File/ Print with the
selection"
This will have to be done everytime I print ?
or back to the original question : How can I set it up to print just the
select area
everytime I hit the printer icon ?
I'm trying doing this : select the wanted printed area.
give it a name.
then I get stuck.
THANKS

--
Socrates said: I only know, I don''''''''t know nothing.
I say : I don''''''''t even know, I don''''''''t
know nothing.


"JLatham" wrote:

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.