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
Jump to: navigation, search
(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
 
Line 18: Line 18:
 
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 [http://openoffice.blogs.com Solveig Haugland's Blog]
 +
 +
 +
{{PDL1}}
  
 
[[Category:Documentation/FAQ/Calc/Formatting]]
 
[[Category:Documentation/FAQ/Calc/Formatting]]

Latest revision as of 10:06, 12 May 2009


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.

  1. Click in the cell where you want the list to appear. If you want the list in multiple cells, select multiple cells.
  2. Choose Data > Validity.
  3. Select Cell Range in the Allow list.
  4. 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.
  5. 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).
Personal tools