Printing a form

[Jeff Taylor]

This seems like it should be so easy. I have an excel
worksheet with headings. The worksheet includes business
names, contacts, address info, phone, etc. I hid the
columns which include info I don't want. I clicked on
Form in the Data tab. It displayed the form I want with
all the information organized the way I want. It shows
the number of forms, previous, next, etc. I just want to
print each form out, but there is no way to print it. The
top of the form shows "sheet 1". While the form is
displayed, none of the print controls on the worksheet
view function, and there are no print functions on the
form. It seems all of the advice is on designing a form
to enter data into the worksheet. I just want to print
out pages that organize the data onto one sheet (record)
per column. The form (sheet, record) is exacttly the end
result I want but there doesn't seem to be any way to
print them out. (1) How can I print the form (record)?
(2) How do I set the program to print all of the forms?

 

[Debra Dalgleish]

Unfortunately, you can't print the data form (unless you do a print screen).

You could set up another sheet in the workbook, with the fields arranged
for printing individual records, and formulas to display the selected
data. There are some sample files here that may help you:

http://www.contextures.com/excelfiles.html

Under 'Data Validation', look for 'Invoice for Selected Number'

Another option, if you have many records to print at one time, is to
create a mail merge in Microsoft Word. David McRitchie has instructions
for mail merge on his web site:

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

Also, there's information on the Word MVP site:

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

 

[Guest]

I have the exact same question as Jeff. You mention in your reply that the form can't be printed - unless you do a print screen. Please explain how to do this. I have tried Ctrl P as is normally used and it didn't work. I don't want to print a lot of forms at once, only as required so the mail merge is not suitable.

----- Debra Dalgleish wrote: -----

Unfortunately, you can't print the data form (unless you do a print screen).

You could set up another sheet in the workbook, with the fields arranged
for printing individual records, and formulas to display the selected
data. There are some sample files here that may help you:

http://www.contextures.com/excelfiles.html

Under 'Data Validation', look for 'Invoice for Selected Number'

Another option, if you have many records to print at one time, is to
create a mail merge in Microsoft Word. David McRitchie has instructions
for mail merge on his web site:

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

Also, there's information on the Word MVP site:

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

 

[Bob Umlas]

There's a Print Screen button on your keyboard. It will place the entire
screen image into the clipboard. You will need to then paste it, perhaps
into an empty worksheet or even Word. If you hold the Alt key down when you
press the Print Screen button, it will put the current object/form/whatever
onto the clipboard for pasting anywhere, then you can issue the standard
print command.

Bob Umlas
Excel MVP

I have the exact same question as Jeff. You mention in your reply that

the form can't be printed - unless you do a print screen. Please explain
how to do this. I have tried Ctrl P as is normally used and it didn't work.
I don't want to print a lot of forms at once, only as required so the mail
merge is not suitable.

 

[Dave Peterson]

hitting the printscreen button will copy the screen to the clipboard.

hitting alt-printscreen will copy the activewindow to the clipboard.

You can paste into any application that accepts pictures. (Word or even excel)