Can you do a drop down list in Excel?

Create a drop-down list

Select the cells that you want to contain the lists.
On the ribbon, click DATA > Data Validation.
In the dialog, set Allow to List.
Click in Source, type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list, and click OK.

How do I sort excel by country?

How to Sort Data in Excel?

Select the data that we want to sort.
Go to Data tab > Sort.
Now make sure the “My data has headers” checkbox has ticked.
Click on Sort by drop-down list and select the word Country.
Click on Sort On.
Finally, select the Order.
Final SORT of dialogue box should look like this.

How do I find country data in Excel?

Use the Geography data type

Type some text in cells.
Then select the cells.
Although it’s not required, we recommend creating an Excel table.
With the cells still selected, go to the Data tab, and then click Geography.

How do I create a big drop-down list in Excel?

In your Excel workbook, select the cells that you want to apply the drop down menu to. Click on the Data Validation menu (in the Data tab in the Excel Ribbon), or use the shortcut Alt-A-V-V. In the “Allow:” dropdown menu, select “List”. In the “Source:” box, enter in your values separated by commas.

How do I sort by city in Excel?

Name and City are the least important fields in the sorting process, so they can be sorted first.

Select all the cells in the list.
Choose Data>Sort.
From the Sort by dropdown, select City.
From the Then by dropdown, select Name.
Click OK.

How do I create a drop down sort list in Excel?

Follow these steps:

Select the columns to sort.
In the ribbon, click Data > Sort.
In the Sort popup window, in the Sort by drop-down, choose the column on which you need to sort.
From the Order drop-down, select Custom List.
In the Custom Lists box, select the list that you want, and then click OK to sort the worksheet.

How can I insert Indian map in Excel?

Now it’s time to create a map chart, so select any cell within the data range, then go to the Insert tab > Charts > Maps > Filled Map. If the preview looks good, then press OK. Depending on your data, Excel will insert either a value or category map.

Can you do a drop down list in Excel?