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

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
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
Excel Online Sharepoint - Workbook Links Updating with New Rows Added
Replies
0
Views
95
ah_mktanlys_01
A
T
  • Question
how to share excel online
Replies
1
Views
152
Peter_SSs
Peter_SSs
D
  • Solved
Autofill from another workbook - fill column with row data.
Replies
3
Views
179
Fluff
Fluff
B
  • Question
Looking for advice: Methods to update a table from a data source stored online
Replies
0
Views
256
blothian
B
G
  • Question
Help with VBA to soft error on close/save if data missing from fields.
Replies
0
Views
186
Guitarmageddon
G

Forum statistics

Threads
1,214,943
Messages
6,122,380
Members
449,080
Latest member
Armadillos

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