Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Thursday, 04 March 2021
  0 Replies
  2.2K Visits
0
Votes
Undo
Hi, 

want to create auto sugest & auto pop up data validation list same as google sheet, without Macro & VB in Office 365.

Please check attached image below. i want ot do same in Excel, if i type any word in that Location Column then it should automatically pop up, 
for Ex, if i Type Mech then all the Mech Options should autosuggest & autopop up in Excel. this thing is easily available in google Sheets but want to creat in Excel without using Macro or VB.

Thanks.

 
There are no replies made for this post yet.