Excel data types: Stocks and geography - Microsoft Support
You can get stock and geographic data in Excel. It's as easy as typing text into a cell, and converting it to the Stocks data type, or the Geography data type. These two data types are considered linked data types because they have a connection to an online data source.
Get a stock quote - Microsoft Support
To get a stock quote, you need to add a linked record for a company or fund. Then you can use another column to extract the price. This article explains how.
About the Stocks financial data sources - Microsoft Support
When you use the Stocks data type or the STOCKHISTORY function to obtain stock prices and other company information, that information is provided by another company. Fundamental company data, historical data, real-time and delayed prices, fund summary and performance data are provided by Refinitiv.
STOCKHISTORY function - Microsoft Support
The STOCKHISTORY function retrieves historical data about a financial instrument and loads it as an array, which will spill if it's the final result of a formula. This means that Excel will dynamically create the appropriate sized array range when you press ENTER.
VLOOKUP function - Microsoft Support
Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID. In its simplest form, the VLOOKUP function says:
Hide or Unhide worksheets - Microsoft Support
Learn to hide (or unhide) worksheet tabs or workbooks in Excel. Worksheet names appear on the tabs along the bottom of a workbook.
Turn off Scroll Lock - Microsoft Support
To disable scroll lock, press the Scroll Lock key (often labeled as ScrLk) on your keyboard. If your computer does not have a Scroll Lock key, do one of the following: If your keyboard does not have a Scroll Lock key, on your computer, click Start > Settings > Accessibility > Keyboard. Click the On-Screen keyboard button to turn it on.