Polina

1. Select the DV cell and DataValidationList. Check out the Source Range.

2. Type in some text then hit ALT + ENTER twice. Type in more text then
repeat the ALT + ENTER. Type last line of text the hit just ENTER.


Gord Dibben Excel MVP

On Thu, 28 Jul 2005 12:27:06 -0700, Polina
wrote:

Validation: I am in the cell that has the validation selection, but when I
select validation I cannot see where the person who created the sheet put the
validation choices, how can I find where he typed in his validation table of
choices.

Spacing: I want to have a cell where I can type three lines of text and have
a space between each line without it having to go into a new cell. So I want
the three lines of text and three blank lines in between in one cell.


Thanks for the help.