Hey Polina,

On the validation question,
When you go to the menu bar and choose DataValidation you should see
a window which has three tab across the top. you should be in the
first tab called Settings. In the middle of the window should be
either 2 or 3 boxes with labels. If you see only 2 then your list is
not validating this cell. If you see 3, the bottom box will have the
label "Source:" whatever is in this box is where your list is hiding.
If it is not a cell reference, then post it here and we can attempt to
track it down.

On the spacing issue:

Here is a sample of code that I use to get multiple lines in a cell:

="1st line of text"&CHAR(10)&"Next line of text"&CHAR(10)&"Last line
of text"

Which shows in the cell as:

1st line of text
Next line of text
Last line of text

To add extra rows, just take the &CHAR(10)& and change it to:

&CHAR(10)&CHAR(10)&

CHAR(10) is the carriage return I believe. The = sign in front makes
it a formula which is why you need the quotation marks around your
text and the "&" to tie the text together

You will have to adjust the height of the row in question manually.
If it does not appear correct, try formatting the cell with word wrap
(and centering if that is your preference)

HTH

-Minitman

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.