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.

Lesley Montoya

Update 24 February 2022