You can create drop down lists on a worksheet with Excel’s data validation feature, and they make data entry much easier – usually! Sometimes things go wrong though, like missing drop down arrows in Excel 2013. Have you seen that problem?
您可以使用Excel的数据验证功能在工作表上创建下拉列表，它们通常使数据输入更加容易。 但是有时还是会出错，例如在Excel 2013中缺少下拉箭头。您看到这个问题了吗？
In the screen shot below, there is a drop down in cell B3, and you can select Yes or No from the list.
That list is working well, but data validation does have its quirks. In fact, it has so many quirks that I’ve got a whole page on my website explaining what they are, and how to work around them.
And recently, I found another oddity to add to that list – missing arrows in Excel 2013.
"Missing arrows" is a fairly common problem, and usually they can be fixed by using the keyboard shortcut to show objects -- Ctrl + 6
“缺少箭头”是一个相当普遍的问题，通常可以使用键盘快捷键显示对象来固定它们-Ctrl + 6
Unfortunately, that trick didn't work this time. There are a few more fixes for missing data validation arrows on my website, and none of those worked either.
粘贴链接的图片 (Paste a Linked Picture)
Here's how I discovered the new problem, and added a new workaround to that missing arrows page.
Last week, I was updating a file in which you can select a company name from a drop down list. Based on the company name that was selected, a company logo appears on an invoice sheet in the workbook.
The logo is in a linked picture:
- Copy a cell that contains a logo, or another shape 复制包含徽标或其他形状的单元格
- Select another cell in the workbook 在工作簿中选择另一个单元格
- On the Ribbon’s Home tab, click Paste, then click Linked Picture 在功能区的“主页”选项卡上，单击“粘贴”，然后单击“链接的图片”。
链接的图片和箭头不要混用 (Linked Pictures and Arrows Don’t Mix)
As soon as I pasted that linked picture, the drop down arrow disappeared. I thought the workbook might be corrupted, so I tried the same thing in a different workbook. The drop down arrow disappeared there too.
一旦我粘贴了链接的图片，下拉箭头就消失了。 我以为该工作簿可能已损坏，因此我在另一个工作簿中尝试了相同的操作。 下拉箭头也在那里消失了。
The arrow appeared briefly if I pressed the mouse button when selecting the cell, but vanished as soon as I let go. The same file worked without problems in Excel 2010.
如果在选择单元格时按下鼠标按钮，箭头会短暂出现，但一旦松开，箭头就会消失。 相同的文件在Excel 2010中正常工作。
消失的箭头解决方法 (Vanishing Arrow Workaround)
I’m using Excel 2013, on Window 8, so if you’re using a different operating system, it might not be a problem. However, if you run into this issue, here’s a kludgy workaround. If you find a better solution, please let me know.
我在Windows 8上使用Excel 2013，因此，如果您使用其他操作系统，则可能不是问题。 但是，如果遇到此问题，则可以采用以下变通方法。 如果您找到更好的解决方案，请告诉我。
- Select the cell with the data validation list 选择带有数据验证列表的单元格
- Click outside of the Excel window (e.g. click on the Desktop, or click in your browser window) 在Excel窗口之外单击(例如，单击“桌面”，或在浏览器窗口中单击)
- Click on the Excel window, and the arrow will appear, and you can select an item from the list. 单击Excel窗口，将出现箭头，您可以从列表中选择一个项目。