I have tried the following which doesn't work:

In Sheet1 I have formulas like this one: =E12&CHAR(10)&F12 where E12 holds the text Actual and F12 the number 2004. I have named the
range with these formulas "Headings". In Sheet2 I have the report where one of the headings (cell E5) should be Actual 2004 and
shown as if I press Alt+Enter between Actual and 2004. If I use Data validation by referring to List, Headings I get Actual, then
the CHAR(10) symbol, and then 2004 on one line.

What else can I do to obtain the line break when I have many heading variants to choose between?

Hans Knudsen