Excel Online Data Validation Autofill Not Working

B

bwesten98

New Member
Joined
Apr 12, 2022
Messages
2
Office Version
  1. 365
Platform
  1. Windows
  2. Web
Hey All,

I have created data validation fields in several worksheets. When using them in Excel Online, I used to be able to start typing and have an auto filtered list popup based on what I had input to that point. Suddenly, this autofill feature is no longer there.

Is anyone else having this issue and/or does anyone know how I can fix it?

Thanks!
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Sort by date Sort by votes
Hi & welcome to MrExcel.
Try clicking on the dropdown arrow & then start typing.
 
Upvote 0
Fluff said:
Hi & welcome to MrExcel.
Try clicking on the dropdown arrow & then start typing.
Click to expand...
Hi Fluff,

I did notice that you can do that. However, before you didn't need to click the dropdown arrow. You could just start typing and it would automatically start autofiltering... It doesn't seem by much but it is a big time saver to just be able to tab over and start typing vs. having to click on the arrow
 
Upvote 0
MS have obviously changed something as a number of people have said it no longer works.
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
Drop down menu Autofill
Replies
1
Views
404
awoohaw
awoohaw
A
  • Solved
Missing Worksheet with Data Validation List Options
Replies
1
Views
193
ajm
A
A
  • Question Question
Excel Online Sharepoint - Workbook Links Updating with New Rows Added
Replies
0
Views
400
ah_mktanlys_01
A
B
  • Question Question
Auto Fill values in cells with items in Data Validation or a List/range
Replies
2
Views
337
Skyybot
Skyybot
G
  • Solved
Autofill to bottom of worksheet (macro not working)
Replies
1
Views
598
Artik
Artik

Forum statistics

Threads
1,224,814
Messages
6,181,126
Members
453,021
Latest member
Justyna P

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