Hold Ctrl while you click to select multiple cells in Excel on Windows. On a Mac, hold Command and click to select multiple items. You can also hold Shift-click the first cell and then Shift-click the last cell to select all of the cells in between as well. Now, select the cell into which you want to add a drop-down list and click the “DataStep 1: Navigate to the Ribbon Open Excel and look for the Ribbon menu at the top of the screen. The Ribbon is divided into tabs, and each tab is devoted to a specific area of functionality. Depending on the version of Excel you’re using, you may see a different set of tabs. Step 2: Click the File Menu Find out Merge and Center button in Ribbon if you do not have Classic Menu for Office. Although there is no toolbar any longer, you can also find out the Merge and Center button in Microsoft Excel 2007/2010/2013/2016/2019 Ribbon: Click the Home tab; Go to the Alignment group; Then you will view the Merge and Center button there.
Activate focus on the menu bar. Select different menu headings with left or right keys and open a menu with the down key. Ctrl + Tab. Cycle through all open visual basic windows. Ctrl + Space Bar. Auto complete current word. Ctrl + Back Space. Delete one word to the left of the cursor. Ctrl + Insert.
