Quickly convert between various measurement units without using formula in Excel

Click Kutools >> Content >> Unit Conversion. See screenshot:

If you are in a widescreen, please apply this utility by clicking Kutools > Conversion > Unit Conversion.

Convert degrees to radians without using formula

Usually angles are measured in degrees, but sometimes you need to use radians to measure them. How do you convert degrees to radians or vise verse? With the Unit Conversion utility, you can quickly convert degrees to radians and other angle units without using formula or function.

1. Select a range of data that you want to convert to radians. Apply the utility by clicking Kutools > Content > Unit Conversion. (If you are in widescreen, click Kutools > Conversion > Unit Conversion.)

2. In the Unit Conversion dialog box, click the drop-down list under Units to choose Angle, and select Degree in left list box, then select Radian in right list box. At the same time, you can view the results from the Preview Pane. (Note: if you want to insert the results as comments of the original cells, please check Add results as comment.)

3. Then click OK or Apply. You will get the following changes. Tip: Click OK button will close the dialog box and apply the operation; but click Apply button will only apply the operation without closing the dialog box. See screenshots:

Overwrite the original values		Insert results as comment

Tip: with this Angle option, you can also do other conversions between this unit. Such as from Degree to Minute, from Radian to Second and so on.

Convert meters to feet, inches, miles or yards without using formula

As we all known, meter, yard or foot are widely used for length measurement in the word. So sometimes we need to do some conversions between them. With this Unit Conversion utility, you can quickly convert meters to feet, inches and other length units without using formula.

1. Select a range of data that you want to convert.

2. Go to the Unit Conversion dialog box, click the drop-down list under Units to choose Distance, and select Meter in left list box, then select Foot or other units that you need in right list box. Tip: If you want to insert the results as comments of the original cells, please check Add results as comment. See screenshot:

3. Then click OK or Apply. You will get the following changes.

Overwrite the original values		Insert results as comment

Tips:

 1. If you want to convert kilometers, centimeters, micrometers and so on to feet/inches/miles/yards, you can click the Metric prefix drop-down list to choose the units that you need.

2.with this option, you can also convert feet to inches, convert meters to yards and so on.

Convert Celsius to Fahrenheit or Kelvin without using formula

When you operate a worksheet, you are required to convert temperatures from Celsius to Fahrenheit or from Celsius to Kelvin or vise versa. If you have this utility Unit Conversion, you can easily convert between Celsius, Fahrenheit and Kelvin without formula.

1. Highlight the range of data that you want to change.

2. Go to the Unit Conversion dialog box, click the drop-down list under Units to choose Temperature, and select Celsius in left list box, then select Fahrenheit or Kelvin in right list box. Tip: if you want to insert the results as comments of the original cells, please check Add results as comment. See screenshot:

3. Then click OK or Apply. The data of Celsius have been converted to Fahrenheit. You will get the following changes.

Overwrite the original values		Insert results as comment

Notes:

1. You can press Undo (Ctrl+Z) to restore this operation immediately.

2. Conversion factor shows the conversion ratio between two units.

3. This is only a few examples of this tool, with this utility you can do many other unit conversions.

Demo: Quickly convert between various measurement units without using formula in Excel