excel表格下拉箭头_Excel 2013中缺少下拉箭头

excel表格下拉箭头

Excel 2013中缺少下拉箭头 (Missing Drop Down Arrows in Excel 2013)

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.

在下面的屏幕快照中，单元格B3中有一个下拉列表，您可以从列表中选择是或否。

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.

最近，我发现另一个奇怪的事情要添加到该列表中-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:

徽标在链接的图片中：

1. Copy a cell that contains a logo, or another shape
   复制包含徽标或其他形状的单元格
2. Select another cell in the workbook
   在工作簿中选择另一个单元格
3. 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，因此，如果您使用其他操作系统，则可能不是问题。 但是，如果遇到此问题，则可以采用以下变通方法。 如果您找到更好的解决方案，请告诉我。

1. Select the cell with the data validation list
   选择带有数据验证列表的单元格
2. Click outside of the Excel window (e.g. click on the Desktop, or click in your browser window)
   在Excel窗口之外单击(例如，单击“桌面”，或在浏览器窗口中单击)
3. Click on the Excel window, and the arrow will appear, and you can select an item from the list.
   单击Excel窗口，将出现箭头，您可以从列表中选择一个项目。

翻译自: https://contexturesblog.com/archives/2013/07/16/missing-drop-down-arrows-in-excel-2013/

excel表格下拉箭头