Insert stock information

1. Select some cells that contain stock tickers or company names.

2. On the Data tab, select  Stocks.

3. Excel converts the tickers or names into Stock data types if recognized. If not, select the correct result from the Data Selector pane. The cell displays   and the name once recognized. 

4. Select the cell and the  Add column button, then choose a field, like Price.

   

For more info, see Get a stock quote.

1. Select some cells that contain stock tickers or company names.

2. On the Data tab, select  Stocks in the Data Types gallery.

3. Excel converts the tickers or names into Stock data types if recognized. If not, select the correct result from the Data Selector pane. The cell displays   and the name once recognized. 

4. Select the cell and the  Add column button, then choose a field, like Price.

5. 

For more info, see Get a stock quote.