Поиск Google ничего не нашел

Drop Down from a List in Another Workbook. Important Note: For the data validation to work, the workbook that contains the list must be open, in the same instance of Excel.


Create a Cell Drop-Down List in Excel with Data Validation.


Excel Drop Down List Not Working 2007.


Drop Down Listed in Excel '10 stopped working. I used a copy of my file on a different machine which is running Excel 2007, the drop down list function does not. Hi, I created a drop down list in excel. Saved it as both a.xls and a.xlsx. from MS 2013. The drop down does not exist when I open it in oo...


A spreadsheet in 2013 Excel, opening in 2007 and the drop down boxes are gone.


This is the fastest 3-step way to create a drop-down box in all versions of Excel 2016, 2013, 2010, 2007 and 2003. 1. Select a cell or range for your drop-down list. You start by selecting a cell or cells where you want a drop-down box to appear.


drop down list compatibility issue between Excel 2007 and Excel 2010.


I have a drop down list which is auto updating from a table. It works fine when the source data and drop down list are on the same sheet, but its not updating when


Please Note: This article is written for users of the following Microsoft Excel versions: 2007 and 2010. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Drop-Down List Font Sizes.


Create a drop-down list. Applies To: Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac More...