If you find a better solution, please let me know. However, if you run into this issue, here’s a kludgy workaround. I’m using Excel 2013, on Window 8, so if you’re using a different operating system, it might not be a problem. The same file worked without problems in Excel 2010. The arrow appeared briefly if I pressed the mouse button when selecting the cell, but vanished as soon as I let go. The drop down arrow disappeared there too. I thought the workbook might be corrupted, so I tried the same thing in a different workbook. On the Ribbon’s Home tab, click Paste, then click Linked PictureĪs soon as I pasted that linked picture, the drop down arrow disappeared.Copy a cell that contains a logo, or another shape.Based on the company name that was selected, a company logo appears on an invoice sheet in the workbook. Last week, I was updating a file in which you can select a company name from a drop down list. Here’s how I discovered the new problem, and added a new workaround to that missing arrows page. There are a few more fixes for missing data validation arrows on my website, and none of those worked either. Unfortunately, that trick didn’t work this time. “Missing arrows” is a fairly common problem, and usually they can be fixed by using the keyboard shortcut to show objects - Ctrl + 6 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.Īnd recently, I found another oddity to add to that list – missing arrows in Excel 2013.

That list is working well, but data validation does have its quirks. In the screen shot below, there is a drop down in cell B3, and you can select Yes or No from the list. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors DateĪ community since MaDownload the official /r/Excel Add-in to convert Excel cells into a table that can be posted using reddit's markdown.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. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved.

OPs can (and should) reply to any solutions with: Solution Verified

Only text posts are accepted you can have images in Text posts.Use the appropriate flair for non-questions.Post titles must be specific to your problem.

My sheets in excel disappeared