Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine rows to print on one label
I have imported student information into an excel spreadsheet (use Excel
2003). Each student has one row of information for each course they take. I need to print one label for each student and each course & grade must print on a single label. How do I combine the rows to cause this to happen? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine rows to print on one label
assuming the info in the row is divided into separate columns for name,
course, grade, etc you can do a mail merge in word using the spreadsheet as the data source "Clearcreek" wrote: I have imported student information into an excel spreadsheet (use Excel 2003). Each student has one row of information for each course they take. I need to print one label for each student and each course & grade must print on a single label. How do I combine the rows to cause this to happen? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine rows to print on one label
That is what I am trying to do. However, a student has from 5-8 courses
which print on separate rows in my excel data source. When I try to merge using my excel spreadsheet as my data source, it prints one label for each COURSE rather than ONE LABEL PER STUDENT that contains ALL 6-8 courses. Jane Doe History Jane Doe Math Jane Doe Social Studies "dlw" wrote: assuming the info in the row is divided into separate columns for name, course, grade, etc you can do a mail merge in word using the spreadsheet as the data source "Clearcreek" wrote: I have imported student information into an excel spreadsheet (use Excel 2003). Each student has one row of information for each course they take. I need to print one label for each student and each course & grade must print on a single label. How do I combine the rows to cause this to happen? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I combine worksheets w/o enough rows to combine? | Excel Worksheet Functions | |||
How to print priority mail label in excel | Excel Discussion (Misc queries) | |||
how to print reference label name in excel for comments? | New Users to Excel | |||
print comments with cell label or name | Excel Discussion (Misc queries) | |||
How do I print on continuous label paper in Excel? | Excel Discussion (Misc queries) |