Software

Ask something
Discussion Locked

Excel data to make a small booklet?

0 helpful
5 replies

by sumjay 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi folks,
I have an Excel spreadsheet which has a large number of rows containing data of various organiztions. The columns have headers like name of organization, address, State/Prov, etc. etc.
I would like to transfer this data into word to make up a small booklet with names and addresses.
Is there an easy way of creating this booklet from a spreadsheet?
Thanks

5 replies

by don christner

I wouldn't bring it into Word, I would use the File-Page Setup to set my margins and set the header row to repeat on each page. You will lose control of the spreadsheet if you bring it into Word. Let me know if you need more details.

Don

by sumjay

Hi Don, I have 15 column headers with lots of data on the spreadsheet with various widths. What I'd like to do is turn the spreadsheet 90 degrees. e.g. place the Cells A1:O1 column headings into the first column A1:A15. Then transfer the data which is now under the columns to the rows.

by dklippert

Yes. In Word look at Tools>Letters and Mailings Mail Merge.
You want to create a Directory. Your source document will be the Excel spreadsheet.

by sumjay

Hi Doug,
Sorry to respond to you so late. I tried your method and it worked! Now I am on my way preparing the Resource Directory for the Deaf, deafened and hard of hearing people located in York Region, Ontario.
Cheers,
Sam

This discussion is closed to new replies.