Insert stock information

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 tickers or names into Stock data types. If not recognized, select the correct result from the Data Selector pane. The cell displays   and the name once recognized.

4. Press the CTRL key, and 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.

3. Excel converts tickers or names into Stock data types. If not recognized, 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 tickers or names into Stock data types. If not recognized, 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.