How to Use the Built-In Geography Feature in Microsoft Excel

Configurare noua (How To)

Situatie

To check out the Geography data type in Microsoft Excel, simply select and add what you need. Then, if you want to expand it, you can create a table or use formulas.

Solutie

Pasi de urmat

Select a cell in your spreadsheet and type a location. This can be a city, state, region, territory, or country. With the cell selected, click “Data,” and then click “Geography” in the “Data Types” section of the ribbon.

Click "Data," and then click "Geography."

Within a few seconds, you might see a question mark appear next to the location name in the cell and the “Data Selector” sidebar will open. This occurs if a location cannot be found, or if more than one location with the same name is available. Click “Select” below the correct location on the right. If you don’t see the location you want, you can type it in the Search box at the top of the sidebar to look further.

Canada in Excel's Geography "Data Selector."

After you select a location in the Data Selector, you’ll see a map icon next to the location name and the sidebar will disappear. Now, it’s time to pull in the data you need.

Click the cell that contains the location name, if necessary, and then click the Insert Data icon that appears next to the cell. This will display a scrollable list of data from which you can make selections. The data available here will depend on the kind of location you’ve selected. For example, if you type a country, you’ll see more options than you would for a city. You can select an abbreviation, area, total tax or unemployment rate, urban population, and more.

The Insert Data menu for "Canada."

When you select something from the list, it will appear in the cell to the right of your location immediately. You can continue to add data from the list, and they’ll populate in subsequent cells on the right. If you add several items for your location, though, and don’t label them with column headers, it’s easy to forget what each is for. Just click the cell containing the data to see what it is in the Formula Bar.

Click a cell to see what type of data it contains in the Formula Bar.

Tip solutie

Permanent

Voteaza

(5 din 14 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?