How to auto update exchange rate in Excel?
If you are working in a financial enterprise, sometimes, you may use Excel worksheet to list all different currencies and convert them based on the exchange rates. And it will be very convenient for you if Excel supports to auto update exchange rates. This tutorial introduces the ways for solving this job.
Auto update exchange rates in Excel 365
Get exchange rates by Kutools for Excel in any Microsoft Excel versions
Note: the methods provided in this tutorial are tested in Excel 2021, there may be some different in different Excel verisions.
If you are in Excel 365, with the Currencies data type you can easily get the real-time exchange rate.
1. Select a cell and type the currency pair separated by “/” or “:”, for example, convert AUD to USD, type AUD/USD or AUD:USD. See screenshot:
2. Keep the cell selected, go to Data tab, and click Currencies in the Data Type group to change the data type to currencies.
3. Now you can extract the information such as the last time price, currency, from currency, change, last trade time by clicking on the Insert Data icon, then in the Field list, click the information you want to add beside the currency pair.
Note:
1. Click Price will insert the exchange rate in the next cell, you can change the decimal number of the rates as you need.
2. Click the Show Card icon or press Shift + Ctrl + F5 will show the data card.
3. Click Data > Refresh All to update all exchange rates at once.
If you are in other Excel versions (Microsoft), there is no Currencies data type for you to quickly get the exchange rates. In this case, the Currency Conversion of Kutools for Excel can quickly convert the currency and insert the exchange rates as comments.
1. Select the data that you want to convert currency, then click Kutools > Content > Currency Conversion. 
Tip: If you cannot see Currency Conversion in Contents group, please click Kutools > Conversion > Currency Conversion.
And to change the Toolbar Mode as you need, please click Kutools > Help > Help > Toolbar Mode.
2. In the Currency Conversion dialog, choose the currency pair you want to use, then click Update rate button to use the latest rate, then click Fill options to set the filling type and contents.
3. In the Fill options dialog, choose the options as you need:
1) Only cells. will only output the converted result into the active cells;
2) Only comment, will output the conversion value, currencies, rate, and output date (you can specify the contents you want to output from these four options) as the comment;
3) Cells and comment, will output the converted result into the active cells; and insert comments with the conversion value, currencies, rate, and output date (you can specify the contents you want to output from these four options)
4. Click Ok or Apply.
For more details about Currency Conversion, please visit the tutorial.
For free download the Kutools for Excel,please click DOWNLOAD.
Other Operations (Articles)
How To Turn Off Auto Complete
Here is an option in Excel that can stop the auto complete.
How To Reduce Excel File Size?
Sometimes, it will take minutes to open or save if the Excel file is too large. For solving this problem, here in this tutorial, it tells you how to reduce the Excel file size by removing the contents or formats which are unnecessary or never used.
How To Auto Complete Cells From Another Table
In this tutorial, it is talking about how to auto complete other column cells from a table in another sheet after entering one column value.
How to apply shading to odd or even (alternative) rows/columns in Excel?
While designing a worksheet, many people tend to apply shading to odd or even (alternative) rows or columns in order to make the worksheet more visual. This article will show you two methods to apply shading to odd or even rows/columns in Excel.
The Best Office Productivity Tools
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
- Merge Cells/Rows/Columns and Keeping Data; Split Cells Content; Combine Duplicate Rows and Sum/Average... Prevent Duplicate Cells; Compare Ranges...
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
- Favorite and Quickly Insert Formulas, Ranges, Charts and Pictures; Encrypt Cells with password; Create Mailing List and send emails...
- Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
- Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
- Pivot Table Grouping by week number, day of week and more... Show Unlocked, Locked Cells by different colors; Highlight Cells That Have Formula/Name...
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
