Keyboard Shortcut For Drop Down Box Excel 2016 Mac

Posted on |

To create your own drop-down list for the cell, do the following:

1. Create a column or a row of the items in theactive spreadsheet for the drop-down list.

252 time-saving Hotkeys for Excel 2016. Extensive, exportable, wiki-style reference lists for Keyboard Shortcuts/Hotkeys. 252 Shortcuts for Microsoft Excel 2016. Display the G oTo dialog box. By opening header drop-down and using Arrow Keys and Space to unhide item. By default, Function keys on a Mac control the computer itself, things like screen brightness, volume, video pause and play, and so on. To make function keys operate as you expect in Excel, you need to hold the function or fn key. You'll find this key in the lower left on your keyboard.

2. Select the cell that needs a drop-down list fordata validation (cell B2, in this example).

3. On the Data tab, in the Data Toolsgroup, click Data Validation:

Down

4. In the Data Validation dialog box, onthe Settings tab:

Shortcut
  • In the Allow drop-down list, select the List item.
  • In the Source box, specify the range that contains the drop-down list items(in this example, the range is E1:E8).
  • Check In-Cell Dropdown option to show the drop-down list. Otherwise, Excelvalidates your data entry but does not show the drop-down button to select itemsfrom the list.

Keyboard Shortcut For Drop Down Box Excel 2016 Mac Download

Create shortcut for excel 2016

5. Click OK.

Keyboard Shortcut For Drop Down Box Excel 2016 MacMac

Keyboard Shortcut For Drop Down Box Excel 2016 Mac Quick Analysis Button Location Youtube

Notes:

  • You can hide the range of values used in the Source box or create it onthe protected sheet that you can hide.
  • You can add the drop-down list to multiple cells by selecting the appropriatecells or copy/paste the cell with a list.
  • If the list is short, you can avoid Step 1. Instead, type your list items(separated by commas) in the Source box in the Data Validationdialog box:
  • If you plan to share your workbook with users of Excel 2007 or earlier, makesure that the list is on the same sheet as the drop-down list. Alternatively,you can use a named range.

See also this tip in French:Création d’une liste déroulante dans une cellule.