Excel help, is this possible?

[ItsAllGoingToBeFine]

I have seen some amazing things talked about in excel on here before, so I thought I would at least ask. I did Google first, but didn't really get anywhere as I'm not sure what to Google IYSWIM.

The scenario is large spreadsheet about customers. Each customer has a row which has various columns, name, age, address etc (although there are a lot more columns than this.)

I want ot be able to print a page per customer with all of the information laid out in an easily readable format.

I guess I want the column headers to be be in a list down the page, with the relevant info next to them

Eg

Name:. Petunia
Age: 113
Address:.... Etc

Is it possible to automate this in some clever way so that I can convert each of the rows into an info page without having to do it individually?

Yes! You can do a mail merge with Word. You set up a Word document as you want each page to look and then you add links to the various Columns and once you merge it, you will be able to see each customer on one page. There are lots of tutorials online for mail merging which will explain it far better than I can type

Thanks very much! Now I know what I'm actually looking for I'm can figure it out