How to convert text to a linked data type in Excel | Microsoft
Getting reliable data into your Excel workbook about subjects like cities, foods, animals, constellations, and more, has never been easier. With linked data types, you can insert and work with reliable data from trusted online data sources, just like the Stocks and geography data types. Microsoft has partnered with Wolfram Alpha to provide rich, interesting facts and data on numerous subjects that you can use and refresh—all without leaving Excel.
1. In an Excel workbook, enter specific identifying text into separate cells. We recommend grouping subjects together in a single column with a header row.
2. Select the cells and go to Insert -- Table to convert to a table. Check the box for My table has headers if you've added them.
3. Select the text to convert in the table. Go to Data and in the Data Types group, select Automatic.
Support article: https://support.microsoft.com/en-us/o...
Смотрите видео How to convert text to a linked data type in Excel | Microsoft онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Microsoft Helps 01 Март 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,66 раз и оно понравилось 4 людям.