This data type works better with data stored in tables in Excel, so select one cell in your range of companies and press Ctrl+T to format the data as a table. This icon indicates that additional information is available for the data stored in the cell. The company name might change in the cell (e.g., “Microsoft” would become “Microsoft Corp”) and the bank icon-which looks like a building with Roman columns-will appear to the left of each company. Select those cells and set their data type to Stocks from the Data Types gallery in the Data tab of the Excel ribbon.Įxcel will attempt to match each cell value to a company stock.
To begin, enter a list of company names or stock ticker symbols in some cells in Excel.
Since the data comes from the internet, you must be an Office 365 subscriber in order to have access to these features. As with the new Geography data type (see the December 2018 column, ), the Stocks data type isn’t supported for customers who purchased Excel 2019 or Excel 2016.
