Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |