printing form in excel?

Question

i have a worksheet with 50 rows and columns from A to W. I want to print a form for each row with corresponding entry from selected columns. is it possible in excel?

Answer 1

Yes simple.
way # 1 (Using Excel Only)
consider the sheet which is having the 50 rows and A to W colums is the data model (sheet)
use a new sheet for each form.
by form I under stand that it is like a letter to customer for example.
go to the new sheet write the text you need then in the cell you need to write the piece of information press = then point by mouse to the data sheet and select the cell then press ENTER
complete your form in the same way
configure this for for printing using setup when you preivew your printing

Way # 2 (Using Excel & MS Word)
consider the sheet which is having the 50 rows and A to W colums is the data model (sheet)

Open MS Word, go to mail and merge
follow the wezard
design the letter
when he ask you about the data point to the excel file
then word will give you a drop down list with each column header in excel as a field you can insert in word between sentences .
complete your sentences and fields the select merge for printing or email.

you did it.


Regards.

Answer 2

What you want is to do a Word Merge.

Create your form in Word and set the layout there. Then click on Tools -> Letters and Mailings... -> Mail Merge

You can then merge your Excel sheet into the Word doc and print out one form per record/respondent. If you are using Word 2003, the wizard on the right is very nice.

Answer 3

highlight the row you want to print, (drag the mouse over area) click print and under the page range click "selection". it will only print that section. hope this helps!

Answer 4

highlight the area and print selected area

Answer 5

highlight what you want to print.
choose selection