It’s a green app with a white “X” on it. You’ll find this option in the upper-left side of the window. On Mac, click the New tab and then click Blank Workbook. Create a chart with your currency conversion information. Type the first currency’s value into B1. Type the conversion rate into B2. Type your starting currency’s name into D1.
For example, if you’re converting dollars to euros, you would type “Dollars” into the D1 cell. Type the currency values you wish to convert into the “D” column. For example, if you have ten dollar amounts that you want to convert to euros, you would enter each dollar value in a cell from D2 through D11. Type the conversion currency’s name into E1.
To use the previous example, you might type “Euros” here. This will display the converted equivalent of your starting currency in cell E2, which is directly to the right of the starting currency equivalent. Apply the formula to the rest of the second currency’s column. Click E2 again to select it, then double-click the little green square that appears in the bottom-right corner of the E2 cell. Your second currency’s column will fill up with conversions of the currency values from the starting currency column.
Go to the Kutools download page. Kutools is only available for Windows. It’s a link in the middle of the page. Click the drop-down box to pick a language. Click the “Accept” box and click Next.
Enter your starting currency values in the “A” column. For example, if you have 20 dollar values you want to convert, you’ll place each individual value in cells A1 through A20. Click the A1 cell and drag all the way down to the last full cell. Click the Home tab, then click Copy in the “Clipboard” section on the left side of the toolbar. Paste the data into the “B” column. Click the B1 cell, then click the Paste button.
This button resembles a clipboard in the far-left side of the Home toolbar. Make sure you click the clipboard icon and not the arrow below it. Select the data in the “B” column. Simply click the B column header to select all cells in the “B” column. This is near the top of the Excel window. Content” group of options in the toolbar at the top of the page.