How to Convert Currency in Microsoft Excel
Manual conversion
How to Convert Currency in Microsoft Excel Picture 1
Look up the current conversion rate. Open a web browser and type currency converter or currency converter in the address bar, then select the currency you want to compare in the drop-down boxes at the top of the search engine results. This will help you to know the current rate.
For example, if you want to see the dollar to euro exchange rate, you need to select Dollars in the upper box and Euros in the lower box.
How to Convert Currency in Microsoft Excel Picture 2
Open Microsoft Excel. The app is green with a white "X" inside.
How to Convert Currency in Microsoft Excel Picture 3
Click Blank workbook . This option is in the upper left of the window.
On Mac, you need to click the New tab and then select Blank Workbook.
How to Convert Currency in Microsoft Excel Picture 4
Create a chart with currency conversion information by:
Enter the name of the first currency in cell A1 (for example, "Dollars").
Enter the value of the first currency in cell B1. This value should be "1".
Enter the name of the second currency in cell A2 (for example, "Euros").
Enter the conversion rate in cell B2.
How to Convert Currency in Microsoft Excel Picture 5
Enter the name of the currency to be converted into cell D1. For example, if you are converting dollars to euros, enter "Dollars" in cell D1.
How to Convert Currency in Microsoft Excel Picture 6
Enter the currency value you want to convert in the "D" column. For example, if you have 10 dollar values to convert to euros, enter each dollar value in cells D2 through D11.
How to Convert Currency in Microsoft Excel Picture 7
Enter the name of the currency to be converted into cell E1. To use the previous example, you need to enter "Euros" here.
How to Convert Currency in Microsoft Excel Picture 8
Click E2, then type =$B$2*D2 and press ↵ Enter. The converted equivalent of the original currency will appear in cell E2 to the right of the original converted value.
How to Convert Currency in Microsoft Excel Picture 9
Apply the formula to the rest of the second currency column. Click E2 again to select it, then double-click the small green square shown in the lower-right corner of cell E2. The column of the second currency will be filled with the conversion values of the currency value in the original column.
Using Kutools for Excel
How to Convert Currency in Microsoft Excel Picture 10
Visit the Kutools download page. Go to https://www.extendoffice.com/download/kutools-for-excel.html using a web browser. Kutools is only available with Windows.
How to Convert Currency in Microsoft Excel Picture 11
Click Free Download Now (Download now). This link is in the middle of the page. Kutools will download to your computer, but you need to click Save or choose where to save (depending on the browser).
How to Convert Currency in Microsoft Excel Picture 12
Double click on the Kutools setup file with the brown box icon.
How to Convert Currency in Microsoft Excel Picture 13
Select the language and then click OK . Click the drop-down box to select the language.
How to Convert Currency in Microsoft Excel Picture 14
Follow the on-screen instructions to complete the installation of Kutools:
Click Next.
Click the "Accept" box and then click Next.
Click Next twice.
Click Install.
How to Convert Currency in Microsoft Excel Picture 15
Open Microsoft Excel with a green icon with a white "X" inside.
How to Convert Currency in Microsoft Excel Picture 16
Click Blank workbook . This option is in the upper left of the window.
How to Convert Currency in Microsoft Excel Picture 17
Enter initial currency values in column "A". For example, if you have 20 dollar values to convert, enter each value separately in cells A1 through A20.
How to Convert Currency in Microsoft Excel Picture 18
Select the starting currency data. Click on cell A1 and drag down to the last cell.
How to Convert Currency in Microsoft Excel Picture 19
Copy data. Click the Home tab and then select Copy from the "Clipboard" section on the left side of the toolbar.
How to Convert Currency in Microsoft Excel Picture 20
Paste the data into column "B". Click cell B1, then click the Paste button. This button is shaped like a clipboard and is located to the left of the Home toolbar.
You need to make sure you click on the clipboard icon and not the arrow below it.
How to Convert Currency in Microsoft Excel Picture 21
Select the data in column "B". Just click on the column B header to select all the cells that are in column "B".
How to Convert Currency in Microsoft Excel Picture 22
Click the Kutools tab near the top of the Excel window.
How to Convert Currency in Microsoft Excel Picture 23
Click Currency Conversion located in the "Ranges & Content" option group at the top of the page.
How to Convert Currency in Microsoft Excel Picture 24
Click Update rate . This button is at the top left of the Currency Conversion page. That way your currency rate will be as accurate as possible.
The computer needs an Internet connection to perform this operation.
How to Convert Currency in Microsoft Excel Picture 25
Select the currency for the data in the left pane of the Currency Conversion page.
For example, if converting from dollars to euros, you need to select Dollars here.
How to Convert Currency in Microsoft Excel Picture 26
In the window to the right of the Currency Conversion page, select the currency you want to convert the data to.
For example, if converting from dollars to euros, select Euros here.
How to Convert Currency in Microsoft Excel Picture 27
Click OK . The value in column "B" will convert to the currency you selected for conversion.
Kutools is not free for life. If you want to continue using the plug-in, you need to purchase it from the Extended Office store.
You should read it
- Link download Microsoft Excel 2019
- 5 useful Microsoft Excel formulas for calculating taxes
- Summary of expensive shortcuts in Microsoft Excel
- Complete guide to Excel 2016 (Part 1): Get familiar with Microsoft Excel
- How to Use Excel
- Guide to full Excel 2016 (Part 2): Learn about OneDrive
- Link Download Microsoft Excel Viewer 12.0.6611.1000
- MS Excel - Lesson 11: Solving the problem of Excel Help feature?
- Ways to install Microsoft Excel on Linux
- 5 best alternatives for Microsoft Excel
- How to Download Microsoft Excel
- Compare Microsoft Excel and Power BI