Have I been sleeping on data validation lists, or was always just ignorant.

awoohaw

awoohaw

Well-known Member
Joined
Mar 23, 2022
Messages
4,835
Office Version
  1. 365
Platform
  1. Windows
  2. Web
I noticed today that I selected a column of 25 cells with only 3 unique names to use as a data validation list. when i clicked on the drop down the list was already filtered. Is this a fairly recent addition, or have I always misunderstood it? I have 365.
 
Sort by date Sort by votes
RoryA said:
According to the features flyer in the Excel blog, as long as you have version 2306 or later on CC, you will have it.
Click to expand...
Can you share the link to that blog? And, @RoryA , what version do you work with? Is this available for you?
 
Upvote 0

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
The blog is here.

At work I don't have it; at home I do.
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question
Generate lists based on Column information
Replies
6
Views
242
JerrExcel
JerrExcel
S
  • Solved
Data List Change + PDF Export on button click
Replies
4
Views
244
StevenE06
S
Yecart77
  • Solved
Create Data Validation Fixed Range but remove blanks
Replies
3
Views
309
awoohaw
awoohaw
B
  • Question
VBA code for zooming data validation menus but in 365 shared online
Replies
1
Views
93
myall_blues
myall_blues
M
  • Question
Excel unhide sheet - selection issue
Replies
2
Views
114
jkpieterse
jkpieterse

Forum statistics

Threads
1,216,500
Messages
6,131,015
Members
449,615
Latest member
Nic0la

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top