How to Make a Submenu for Excel

By Chang Lin

The Microsoft Excel program allows users to easily input, modify, organize and track data with spreadsheet documents. Due to Excel's functionality and flexibility, people in offices worldwide use it to manage inventory, store data entry, organize finances and more. If you want to add a submenu to a cell or cells, the "Data Validation" feature within Excel allows you to create one in a matter of minutes.

Step 1

Launch Excel and create a new spreadsheet or open an existing one.

Step 2

Left-click on the cell where you want to create your submenu. A selected cell will display a bold, dark border.

Step 3

Click on the "Data" tab across the top of the Excel window and click on the "Validation" option from the drop-down menu.

Step 4

Select the "Settings" tab located across the top of the "Data Validation" window. In the "Allow" section, choose "List" from the drop-down menu.

Step 5

Place check marks beside the "Ignore Blank" and "In-cell drop-down" options.

Step 6

Type in the submenu options in the "Source" section of the "Data Validation" window. You can enter as many sources as you want while separating each submenu option with a comma. After you are finished, click the "OK" button in the bottom right corner to save and apply the changes.

References

Writer Bio