Toby,

In a word, no. Not directly, anyway. If you have Access, link your table to Access, then
create a report with the layout you want. Or use the Word mail merge.

Your table layout of the data is correct for when you want to do analysis and summary kinds
of things. That's what Excel is good for. But it doesn't have means to present the data in
other layouts.

If you still want the single-record layout on a sheet (which you could also print -- Excel
prints a sheet as is), create another sheet, using a VLOOKUP for each field. Be sure your
key field (name, or whatever uniquely identifies a person) is at the left of the other
fields.
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"Toby" wrote in message
...
I have entered into a spreadsheet many lines of data using one line per
person to include information for that person. I wish to be able to select a
person by number and then print that persons data onto a form with the data
in pre planned positions on the Form, aAlso I would like to display the same
data on a form on the screen. Can this be done with Excel if so can you give
me some guidance and help.
Dave T