Go to the Excel Shortcuts page for an interactive list, and to get the file.Here are some time-saving Microsoft Excel shortcuts to use when you're entering data. Once you are satisfied with the shortcut, click OK to save.More Data Entry Tutorials Data Entry Shortcuts.If the shortcut is already taken, you can also add Ctrl + Shift to assign it. Press the key you would like to use as shortcut on your keyboard.Once the macro is ready, click Developer > Macros icon in the Ribbon.With the macro method, you can assign whatever shortcut you'd like to open this feature.ĬommandBars('Cell').Controls('Pic&k From Drop-down List.').Executeīelow are the steps for adding a shortcut to your macro. You can call the same functionality using VBA as well. Using VBA to populate pick from drop-down list This key opens the right-click menu for the selected item.įurthermore, the “k” letter is underlined and this means that you can use this shortcut key while the menu is active. The menu key (the application key) is between the Windows (or FN) and CTRL keys on the right-side on most keyboards. Second shortcut option depends on whether you have the context (right-click) menu open. When you're on the cell you want to fill, press the Down Arrow ( ↓) key while holding Alt or Alt Gr keys. This shortcut is an easy way to display the drop-down list. Remember that at least one adjacent cell should be filled either up or down direction to use this feature.

You can see the feature’s name in the context menu when you right click a cell. The best part about this feature is that Excel can recognize the title and exclude it from the list selection.Īuto-complete works here, but it does not offer a solution if there are items starting with same characters, such as Columbia and CBS Records. In the following example, we see a drop-down with values in the column C. The 'Pick from drop-down list' feature generates a drop-down list on the fly, based on values on the adjacent cells in the same column. In this article, we are going to show you how to use pick from drop-down list feature in Excel. Dropdown lists are a common example of data validation used in organizing data input.

Excel page down shortcut