how to extend drop down menu in excel 2016

You can write your own error alert message in the boxes on the right-hand side of the dialogue box if you wish. If you don't want anything else being written in these boxes, go to the 'Error Alert' tab and make sure the box is ticked next to the words 'Show error alert after invalid data is entered'.The dialogue box will appear in full again.

Excel 2016 hangs when trying to change the font color in any cell. Highlight your list of options, then click on the little button with the red arrow again. What comes up is a list of COM-Add Ins that are loaded and running. Go to Sheet 2 or wherever you wrote your list of options in step 1. On the right-hand side of the 'Source' box, there is a little button showing a red arrow.Sonora wants to extend the cells to be added in her formula. Click on the formula bar above the cells. Click on the Insert tab in the ribbon and then Equation. Click on the Function Library group and Insert Function.

This will create a box entitled 'Source' below. Click on the Function Library group and select a function from the drop-down menu. A dialogue box will appear.Under the 'Settings' tab, select the drop-down option 'List'. Thanks Osman Spice (1) flag Report 2 found this helpful thumbup thumbdown lock This topic has been locked by an administrator and is no longer open for commenting. The options for your list should then appear.

Select the cells you want the drop-down list to appear in. When on the cell, press and hold down the Alt key until the you see shortcut letter appears in the Excel Ribbon, then hit the down arrow.

Go back to the table you want the drop-down menu to be in.

Go to Sheet 2 (or a blank sheet) and write a list of the options you want to see in your drop-down menu.

How to extend drop down menu in excel 2016