Windows 10: win10 excel drop down menus not working Help!!

tried mouse and cmd nothing working

:)

 

Excel Drop Down Menu Question

I'm toying around with a project for work. We're trying to make an Excel spreadsheet that has a list of parts that employees would sort of use to build an order form. It's coming along nicely and works fairly well with the touch screen tablet we have, but I had a question. At the moment, when you highlight a cell that has a drop down list of choice, a small box with a down triangle appears in the bottom right. You click that, then the list of items appears. Is there anyway I can make it so that when you click the cell the drop down menu appears? This would make working with the spreadsheet on the tablet many times easier.

 

Excel 2016 Drop down lists

Hi, SQRLR,

This document from 2012 shows how to use Macro in dropdown menu.

https://answers.microsoft.com/en-us/office/foru...

Step by Step Tutorial with photos on creating the dropdown menu.

https://www.lifewire.com/create-drop-down-list-...

Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised
on the site before you decide to download and install it.

 

Drop Lists in Win10

I have several applications that use drop lists that no longer work with the mouse in Windows10. Using the mouse left click does not activate the list of options. Sometimes, you can click in the field and use the keyboard down or up arrow to see the list
options but that is not always the case. On the same machine, using Excel 2013, I can create a drop list and it works perfectly. Any suggestions?