Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
Data Validation | Excel Discussion (Misc queries) | |||
Data Validation Window? | Excel Discussion (Misc queries) |