Make drop-down menus that can be updated automatically in Excel

Excel in the "drop-down menu" function, I believe many people have been useful, but you have heard of, can automatically update the drop-down menu?

Ordinary drop-down menus cannot automatically update new content. After making drop-down menus, if you need to modify or add them later, it is a very troublesome thing. If you use the drop-down menu that updates automatically, it's easy to modify or add content later.

1. Ordinary drop-down menu Let's first take a look at the production of ordinary drop-down menu. Go to "Data"-"Data Tools"-"Validation"-"Settings", set it to "Sequence" in Allow, select the drop-down content cell in Source, and confirm to complete it. This is the most common way to create drop-down menus.

However, if you want to add some content to the drop-down menu, it is more difficult.

2, automatic update of the drop-down menu 1, want to make can automatically update the content of the drop-down menu, in fact, very simple, we first convert the table into a super table. Position the cursor to any cell of the department and press Ctrl + T to convert the normal table into a super table.

2. Select the following data cells of the department, and then enter "Formula"-"Defined Name"-"Defined Name", create a name in the name, here I will set it to "Menu" OK.

3, create a drop-down menu, we select the cells that need to add a drop-down menu, enter the "Data"-"Data Tools"-"Data Validation"-"Data Validation", set the permission to "Sequence", enter "= menu" in the source, OK, now our drop-down menu is ready.

Finally, let's look at it again. Add a new department to the department, and then check the drop-down menu. You can find that the drop-down list has been automatically updated with the new content.

This article comes from Weixin Official Accounts: Word Alliance (ID: Wordlm123), author: Wang Qi