TWO QUESTIONS: Validation & Spacing...PLEASE HELP
 

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.

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.

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.

Can't believe that I omitted saying to you to press the Alt + Enter TWICE
between the 1st and 2nd line and also twice between the 2nd and 3rd line.
daaaa..

"Jim May" wrote:

Q1- Each cell in the spreadsheet is independent;
With a given cell selected, go to Data, Validation..
If dialog box "shows no validation data, then none exists".
Q2 - To enter into a cell as you describe, in a blank cell
type:
Line1 << do not press enter, instead press Alt (key) + Enter simultaneously
(enter) Line2 << do not press enter, instead press Alt (key) + Enter
simultaneously
(enter) Line3 << Now press just enter


"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.