Alt > Ctrl + Tab – Go to the first toolbar under the Control Menu. Pressing Ctrl + Tab again will take you to the second toolbar, and so on. Use the right/left arrow keys to reach individual buttons on the toolbars and use the down arrow keys to access their drop-down menus. Press Enter to execute the selected action. Re: Excel Drop-down list keyboard shortcut No, not with a Data Validation dropdown. If you use the Control Toolbar ComboBox to put a dropbox control on your sheet, that control has a Property called MatchEntry - 1 - fmMatchEntryComplete.that one will autocomplete as you type.
To make it easier to people to enter data in your Excel workbook, you can create drop down lists in the cells, by using Excel. These lists will also help prevent invalid entries in your worksheets. A couple of years ago, one of the first videos that I uploaded to YouTube showed how to create data validation drop down lists in Excel 2003. I've just finished a new version, for Excel 2007 and Excel 2010, and you can see it at the end of this blog post.
![Excel for mac keyboard shortcuts Excel for mac keyboard shortcuts](https://www.bing.com/th?id=OGC.9e8c23997761925d7251acd443b7be8b&pid=1.7&rurl=https%3a%2f%2fexceljet.net%2fsites%2fdefault%2ffiles%2fimages%2fshortcuts%2fanimations%2fToggle-Autofilter.gif&ehk=1H5cszwMG1DifA0Q3%2fVHKg)
The new video includes a couple of shortcuts that will make it even easier to create those drop down lists. Name the Item List When creating drop down lists, you can use a list of items from a different worksheet, as long as you give a name to that list of items first. Here's the quickest way to of items: • Select the items • Click in the Name Box • Type a one-word name, and press Enter. Create the Drop Down Lists After you've named the source list, you can add the drop down lists, by following these instructions: • Select all the cells where you want the drop downs. • On the Excel Ribbon, click the Data tab, then click the Data Validation command.
• In the Data Validation dialog box, under Allow, select List. • Then, click in the Source box, and press F3 on your keyboard, to open the Paste Name box.
(Quicker than typing the name) • Click on the Name that you want to use in the drop down list, then click OK • An equal sign and the name will appear in the Source box. • Click OK, to create the drop down lists. Watch the Data Validation Video To see the steps for creating drop down lists with data validation in Excel 2007 and Excel 2010, watch this short video. Your browser can't show this frame. Here is a link to the page __________ Author Posted on Categories. Great tip, Debra.
I tried using a structured reference to an Excel 2007 (or 2010) Table column (like '=Table2[Products]') as my data validation list, but got an error message. It seemed like that would be a really handy way of making an auto-expanding list, but I guess it's a no-go. I tend not to use the OFFSET function because it's volatile (I think). Maybe I shouldn't worry about that, though.
![Delete Delete](https://i.ytimg.com/vi/onH6BZFlvb8/maxresdefault.jpg)
Maybe the Slicer thing is a better way to go. I haven't really worked with them at all, but perhaps it's time.