Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pick from List

Status
Not open for further replies.
ebisabes

ebisabes

Technical User
Aug 11, 2006
71
US
when I right click on a cell one of the options is "Pick from List" but how do I create the list to pick from?
 
Sort by date Sort by votes
This list is based on the existing values in the cells above the one you click. So if you click in line 1, and there's nothing beneath...
If you want to create a list, have a look at Data Validation
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

E
  • Locked
  • Question
Extract lines from table into new table
Replies
2
Views
694
SkipVought
S
lm1340
  • Locked
  • Question
Upload documents to Jira Cloud from SharePoint using Power Automate
Replies
0
Views
443
lm1340
lm1340
grnzbra
  • Locked
  • Question
Set Cell Equal to Selected Value from Dropdown.
Replies
2
Views
306
combo
combo
Wicca
  • Locked
  • Question
MAXIFS - transfers NUMBERS but wont transfer <1.6 from one tab to another
Replies
16
Views
549
Wicca
Wicca
ladyck3
  • Locked
  • Question
Excel 365 - Working with Tables - Calculating data from one worksheet to another. 2
2
Replies
30
Views
1K
combo
combo

Part and Inventory Search

Sponsor

Back
Top