View Single Post
  #4   Report Post  
Jim May
 
Posts: n/a
Default

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.