how to insert a drop down menu in excel 2016

Under Top Option for Working with Excel, check the Show Developer tab in the Ribbon option.įigure 2: Add Developer Tab into Excel 2007 Ribbon.

Click the Excel Option button at the bottom, then you will enter the Excel Option window.

If you want to find Design Mode in Excel 2007 Ribbon, you need to add Developer tab into Excel 2007 firstly: Seek for the Design Mode on Ribbon if you do not have Classic Menu for Office Get Design Mode in Excel 2007 Ribbon if you do not have Classic Menu for Office

Then you will view the Design Mode command.įigure 1: get Design Mode from Classic Menu.

Click the Tools drop down menu under Menus tab.

With Classic Menu for Office, you can easily find out the Design Mode command stays in the same place as where it is in Excel 2003: It is quite easy to find out the Design Mode if you have Classic Menu for Office

Classic Menu for Office Home and Business.

Classic Menu for Office 2007 Applications.

Why would you like to remove the arrows from your sheet? Have you used macros before? Share your experience with the rest of the TechJunkie community.

In reality, the macros are not that hard to master and can help you quickly get rid of the arrows and do many other cool things.

Using macros is often considered intermediate or even advanced Excel knowledge. Put a few blank lines in the module, paste the entire code and just change the pf.EnableItemSelection line. When using macros, you can revert the changes by changing the value from = False to = True. The macros should also apply to newer software iterations but the tool layout might be a bit different.

It is worth noting that the steps apply to Excel versions from 2013 to 2016. Nevertheless, they should also work on much larger sheets. The methods have been tried and tested on a small sheet that contains 14 rows and 5 columns. The code might be a bit different if you want to remove another arrow. Note: For the purposes of this article, the macro is programmed to get rid of the first arrow that it encounters. 'remove the dropdown arrow tutorial by įrom here on, you should follow the steps 2 to 4 from the previous section. Removing One ArrowĪgain, this is the code that you can use to remove just one of the drop-down arrows. Select it, click Run, and all the arrows will disappear from the table.

How to insert a drop down menu in excel 2016