3 by 5 cards

[Deana]

I have Excel 2003 and I want to print data entered into a spread sheet with
page breaks onto 3" by 5" cards. There is not a 3" by 5" paper option in
Excel... has anyone done this and how did you do it?

 

[Ragdyer]

This is *not* a property of XL, but of your printer driver(s).

 

[David McRitchie]

Hi Deana,
Here is the reply I gave you in programming -- please post in only one newsgroup
-- posting in multiple newsgroup is annoying and wastes everybody's time
including your own.


Did you try changing your printer options
File, Page Set up, Page (tab), Options button
this is really you printer not Excel
look for "other Paper" then next "custom"
and set up your paper size.

Obviously you are going to have to insert your page breaks

The option that the Microsoft really gives you is to use Mail Merge in MS Word with
Excel as the database. http://www.mvps.org/dmcritchie/excel/mailmerg.htm
and you would probably have to set up you own paper definition.
With Mail merge you extract the information from Columns, which is probably
better suited to working with Excel for printing organized Index Cards,
(unless you are just making copies of one page).
--