Creating a drop down các mục in Excel 2010 is something that seems like it should be fairly simple, as its a helpful tòa tháp lớn have, & there are a lot of uses for it.

Bạn đang xem: Download excel 2010

But if you’ve ever tried to make a dropdown in Excel, then you may have sầu found that it’s a little more complicated that it seems.

If you are entering data into a spreadsheet, or if you are creating a spreadsheet for others to lớn use, then it is typically a good idea khổng lồ make everything as easy as possible. One good way to vì chưng this is with the inclusion of drop-down lists.

When you have sầu a cell that can only have sầu a few different options, such as a month, day of the week, or even a really long option that you do not want lớn re-type repeatedly, then a drop-down danh sách cannot only save sầu you time, but also help lớn avoid any misspellings or typos. Our guide below will show you how to create a drop-down các mục in Microsoft Excel 2010.

How to Make a Drop Down in Excel 2010

Create the danh mục for the dropdownSelect the items, enter a name, then press Enter.Cliông chồng the cell where the dropdown should be.Choose the Data tab.Clichồng Data Validation.Choose the List optionType an “=” sign, then the Name from step 2.Cliông chồng the OK button.

There are some other settings you can or should apply khổng lồ the danh sách, which we discuss below. Our article continues below with more information & pictures for these steps.

Adding a Drop-Down List in Excel 2010

The steps in the article below will result in a drop-down các mục that you can cliông chồng to lớn select an option. This is ideally used in situations where you are looking for a specific value or type of text khổng lồ occur in a cell, and you want khổng lồ avoid problems that can arise when people manually enter the values themselves.

Step 1: Open your spreadsheet in Excel 2010.

Xem thêm: Lương Bao Nhiêu Là Cao Mà Vẫn Nghèo? Thu Nhập Bao Nhiêu Thì Được Gọi Là Cao

Step 2: Type the items that you want khổng lồ include in the các mục into lớn a column in your spreadsheet. It does not need to be the first column. It can be any column you wish.


You can make changes khổng lồ the drop-down list by clicking the cell to lớn select it, then clicking the Data Validation button on the Data tab.

The first few times you create a dropdown menu it’s likely that you will discover that there are some things you want to change. For example, if other people are going to lớn be entering data, then you are probably going khổng lồ want lớn customize the settings marked as “optional” above.

These various alerts and validation settings help lớn reduce errors and eliminate confusion, which you may discover is a very important element of Excel dropdown menus.

Do you need to lớn print your spreadsheet, but there’s one column that is printing on its’ own page? This guide will show you how to force all of your columns to print on one page & save sầu yourself some pages.

See also

Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites và been read over 50 million times.

After receiving his Bachelor’s & Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.

His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photocửa hàng, but he has also written about many other tech topics as well.