想知道如何使用Microsoft Excel中的(Microsoft Excel)自动数据类型(Automatic Data Type)功能吗?Excel 的自动数据类型(Automatic Data Type)功能允许您自动插入城市、食品、音乐、动物、人物等的详细信息。您无需打开 Web 浏览器、手动搜索详细信息,然后将结果复制并粘贴到Excel工作表中。
假设您要添加有关化学元素的信息,您可以使用此自动工具并输入各种信息,例如原子质量、符号、原子序数、CAS 编号、基团、电子亲和力(atomic mass, symbol, atomic number, CAS number, group, electron affinity,)等。同样,对于食品,您可以添加卡路里、胆固醇、脂肪、钙、营养(calories, cholesterol, fat, calcium, nutrition, )等。等等。
如果您不知道Excel的此功能并且想知道如何开始使用它,请不要担心。本教程将指导您使用Microsoft Excel中的(Microsoft Excel)自动数据类型(Automatic Data Type)功能。开始吧!
如何在Excel中使用(Excel)自动数据类型(Automatic Data Type)功能
在开始本教程之前,请记住使用此功能需要有效的 Internet 连接。它从网络上获取所有细节和信息。因此,请确保您已连接到 Internet,然后使用以下步骤在Excel中使用自动功能:
首先,插入要自动添加详细信息的数据类型。它可以是动物、城市、食品、名人、书名、音乐、化学元素等的名称。
添加数据后,选择所有单元格,然后转到“数据(Data)”选项卡。在此选项卡中,您将找到数据类型( Data Types)部分,您将在其中看到数据类型选项列表,包括地理(Geography)、解剖学、货币、动物、股票、植物、化学(Geography, Anatomy, Currencies, Animals, Stocks, Plants, Chemistries,)等。在此列表中找到自动(Automatic)功能并单击它。
当您单击“自动( Automatic)”选项时,它将开始识别每个选定单元格数据的数据类型,并在每个数据类型之前显示相关符号。
如果无法为特定字段选择数据类型,它将在单元格的开头显示一个问号 (?) 符号。单击(Click)此符号,它将在右侧打开一个数据选择器(Data Selector)窗口,其中包含数据类型选项列表。只需(Simply)点击它所属的数据类型,然后单击“选择(Select)”按钮。
现在,您将在选择单元格时看到一个列表符号。(list)这基本上是自动向单元格添加特定细节的插入数据选项。(Insert Data)
单击插入数据( Insert Data)选项,将打开各种相关字段的列表。例如,对于城市、国家或地点,您可以添加人口、土地面积、按年龄分组的人口、首都、犯罪率、图像(population, land area, population grouped by age, capital city, rate of crime, image,)等字段。
单击(Click)您要添加的信息,它将自动获取并将相应的值输入到单元格中。
您可以通过重复使用“插入数据( Insert Data)”选项将多个数据字段添加到每个单元格。
现在,许多细节随着时间的推移不断更新,例如人口。因此(Hence),有必要不断更新您在工作表中使用的详细信息。
要更新这些值,请转到“数据(Data)”选项卡,您将找到“查询和连接( Querries & Connections)”部分。在此部分中,单击“全部刷新”(Refresh All)按钮,如果有任何更改,它将更新详细信息。
如果您想更新选定数据项的值,请点击全部刷新(Refresh All)下拉按钮,然后点击刷新(Refresh)选项。
本指南向您展示了在Microsoft Excel中使用(Microsoft Excel)自动数据类型( Automatic Data Type)功能的步骤。使用它并自动将详细信息添加到多种类型的数据中,而无需网络浏览器。
相关阅读:(Related Read:) 如何在 Excel 中使用从图片插入数据功能。(How to use Insert Data from Picture feature in Excel.)
How to use Automatic Data Type feature in Excel
Want to know how to υse the Automatic Data Type feature present in Microsoft Excel? Excel’s Automatic Data Type feature allows you to insert details of cities, food items, music, animals, persons, and many more automatically. You don’t need to open a web browser, search for details manually, and then copy and paste results to your Excel sheet.
Let’s say you want to add information about a chemical element, you can use this Automatic tool and enter various information like atomic mass, symbol, atomic number, CAS number, group, electron affinity, etc. Similarly, for food items, you can add calories, cholesterol, fat, calcium, nutrition, etc. And, so on.
If you were unaware of this feature of Excel and wondering how to get started with it, no worries. This tutorial will guide you to use the Automatic Data Type feature in Microsoft Excel. Let’s start!
How to use Automatic Data Type feature in Excel
Before I start with the tutorial, do remember that an active internet connection is required to use this feature. It fetches all the details and information from the web. So, make sure you are connected to the internet and then use the below steps to use the Automatic feature in Excel:
Firstly, insert data types to which you want to add details automatically. It can be names of animals, cities, food items, celebrities, book titles, music, chemical elements, and more.
After adding data, select all the cells and then go to the Data tab. In this tab, you will find a Data Types section where you will see a list of data type options including Geography, Anatomy, Currencies, Animals, Stocks, Plants, Chemistries, etc. Locate the Automatic feature in this list and click on it.
As you click on the Automatic option, it will start identifying data types for each selected cell data and display related symbols before each data type.
In case it is unable to select a data type for a particular field, it will show a question mark (?) symbol at the start of the cell. Click on this symbol and it will open up a Data Selector window at the right with a list of data type options. Simply tap on the data type it belongs to and then click on the Select button.
Now, you will see a list symbol on selecting a cell. This is basically the Insert Data option to automatically add a particular detail to a cell.
Click on the Insert Data option and a list of various related fields will open up. For example, for a city, country, or location, you can add fields like population, land area, population grouped by age, capital city, rate of crime, image, and many more.
Click on the information you want to add and it will automatically fetch and enter the respective value to the cell.
You can add multiple data fields to each cell by using the Insert Data option repeatedly.
Now, many of the details keep updating over time, e.g., population. Hence, it becomes necessary to keep updating the details you have used in your sheet.
To update the values, go to the Data tab and you will find a Querries & Connections section. From this section, click on the Refresh All button and it will update the details, if there has been any change.
In case you want to update values of a selected data item, tap on Refresh All drop button and then click on the Refresh option.
This guide shows you steps to use the Automatic Data Type feature in Microsoft Excel. Use it and automatically add details to several types of data without needing a web browser.
Related Read: How to use Insert Data from Picture feature in Excel.