Difference between revisions of "Documentation/FAQ/Calc/Formatting/How can I create a drop-down list that references a list of values to select from?"
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc | Formatting
(New page: {{DISPLAYTITLE: How can I create a drop-down list?}} <section begin=question/> '''How can I create a drop-down list that references a list of values to select from?''' <section end=questi...) |
m |
||
| (One intermediate revision by one other user not shown) | |||
| Line 6: | Line 6: | ||
<section begin=answer/> | <section begin=answer/> | ||
| − | Under | + | Under {{menu|Data|Validity}}, you can control what people can enter in spreadsheets, and offer them help in the form of lists, help tips, etc. |
# Click in the cell where you want the list to appear. If you want the list in multiple cells, select multiple cells. | # Click in the cell where you want the list to appear. If you want the list in multiple cells, select multiple cells. | ||
| − | # Choose | + | # Choose {{menu|Data|Validity}}. |
# Select Cell Range in the Allow list. | # Select Cell Range in the Allow list. | ||
# Type the range. | # Type the range. | ||
| − | #*To type a range in the same sheet, type something like this: $F$1:$F$20. You need the $ to make the reference absolute. | + | #*To type a range in the same sheet, type something like this: '''$F$1:$F$20'''. You need the $ to make the reference absolute. |
| − | #*If the range is in a different sheet, add the absolute sheet reference in front, like this: $Projects.$F$1:$F$20. | + | #*If the range is in a different sheet, add the absolute sheet reference in front, like this: '''$Projects.$F$1:$F$20'''. |
| − | # Click | + | # Click {{button|OK}}. |
| − | Then if you need to, just change the contents of the cell range and the list updates. Previous entries in those spreadsheets containing entries no longer in the list do not change. | + | Then, if you need to, just change the contents of the cell range and the list updates. Previous entries in those spreadsheets containing entries no longer in the list do not change. |
<section end=answer/> | <section end=answer/> | ||
| + | |||
| + | This FAQ comes from [https://openoffice.blogs.com Solveig Haugland's Blog] | ||
| + | |||
| + | |||
| + | {{PDL1}} | ||
[[Category:Documentation/FAQ/Calc/Formatting]] | [[Category:Documentation/FAQ/Calc/Formatting]] | ||
Latest revision as of 16:35, 16 May 2021
How can I create a drop-down list that references a list of values to select from?
Under Data → Validity, you can control what people can enter in spreadsheets, and offer them help in the form of lists, help tips, etc.
- Click in the cell where you want the list to appear. If you want the list in multiple cells, select multiple cells.
- Choose Data → Validity.
- Select Cell Range in the Allow list.
- Type the range.
- To type a range in the same sheet, type something like this: $F$1:$F$20. You need the $ to make the reference absolute.
- If the range is in a different sheet, add the absolute sheet reference in front, like this: $Projects.$F$1:$F$20.
- Click OK .
Then, if you need to, just change the contents of the cell range and the list updates. Previous entries in those spreadsheets containing entries no longer in the list do not change.
This FAQ comes from Solveig Haugland's Blog
| Content on this page is licensed under the Public Documentation License (PDL). |
