One way is to use a multi-cell array ..

Select any 10 cells col range,
eg select F2:F11
Place in the formula bar:
=TEAM1GOLFERS
Press CTRL+SHIFT+ENTER to confirm the formula
(instead of just pressing ENTER)

Another way (non-array)
Put in any starting cell
eg in B2, normal ENTER will do:
=INDEX(TEAM1GOLFERS,ROW(A1))
then copy B2 down by 10 rows to B11
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jim Tibbetts" wrote:
I am in the process of converting over to Excel from QPW. (Tired of losing
data because of unstable software). I've been using Excel (and writing
formulas) at work for years, so I am familiar with it. But, this ones got me
stumped. I have a notebook that contains a named range of 10 golfers called
TEAM1GOLFERS. When I put +TEAM1GOLFERS in a cell on another page (in the same
notebook) it returns only the first name in the list. How do I get all 10
names to show? Also, is there a list of workbook functions available to view
without going to help?

Thanks for any help.
--
Jim T