Create a drop down menu in Excel to specify consolidation method

Learn how to execute a sequence of actions involving multiple clicks and keyboard inputs. This guide covers techniques for interacting with elements on a screen through a combination of mouse and keyboard operations.

Kate Ruff
10 steps
28 seconds

Microsoft Excel

Add a column called "Consolidation Method"

Go to the Data menu

Select Data Tools

Select Data Validation

Go to Settings

Click the down arrow

Choose List

Type the consolidation options that you will have in your data set. Common ones are sum, max, most recent and average.

Copy and paste the conditions to all your rows

Your options will appear when you click this arrow