login
Excel help
-
No new posts
 2010-06-01 4:58 PM |
Veteran  369   Fairbanks |  Subject: Excel helpDoes anyone know if there is a way to merge an Excel spreadsheet (Columns for name, title, email, organization) into a one or two-page list? As in, two columns of: FName LName Organization Title FName LName Organization Title . . . and so on? I'm familiar with mail merge where each row becomes its own page, but don't know how to merge it into a condensed document. |
| 2010-06-01 5:04 PM in reply to: #2895178 |
Extreme Veteran 861 Northbridge, Massachusetts | Subject: RE: Excel help Merge it from two Excel files or into a Word file? What is the source? |
| 2010-06-01 5:06 PM in reply to: #2895178 |
| Extreme Veteran 861 Northbridge, Massachusetts | Subject: RE: Excel help If you are looking to make a row into a column (highlight and click copy (ctrl C) move cursor to cell you want, click on edit, paste special and then choose transpose Edited by SGriepsma 2010-06-01 5:07 PM |
| 2010-06-01 5:07 PM in reply to: #2895187 |
Veteran 369 Fairbanks | Subject: RE: Excel help I'm trying to merge it from one Excel file, into a Word file. |
| 2010-06-01 5:12 PM in reply to: #2895178 |
| Extreme Veteran 861 Northbridge, Massachusetts | Subject: RE: Excel help Does it need to be in Word as part of a larger document? If so, I would get it into the format you want for Excel and then just copy paste into Word as a table |
| 2010-06-01 5:14 PM in reply to: #2895178 |
Champion 5522 Frisco, TX | Subject: RE: Excel help Set up the table in a word document like you need in one column with the field values you are looking for (same as mail merge), format the document to two columns and then copy / paste the table with a space between each table down the page in both columns Edited by ashort33 2010-06-01 5:15 PM |
| 2010-06-01 5:27 PM in reply to: #2895178 |
Veteran 369 Fairbanks | Subject: RE: Excel help Got it!! Thanks for the help! |
| 2010-06-01 6:14 PM in reply to: #2895245 |
Extreme Veteran 442 | Subject: RE: Excel help Mail Merge in Word, without the page breaks? Let the wizard create the mail merge document, then delete the page break? |
|
|
|
View profile
Add to friends
Go to training log
Go to race log
Send a message
View album
CONNECT WITH FACEBOOK