DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

How to Convert Between Various Measurement Units in Excel Office 365?

In this article, we are going to see how to Convert Between Various Measurements Units without using Formulas in Excel Office 365 using Kutools. Let’s step into this article!! Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Note: kutools for Excel has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

Convert Degrees to Radians:

Here, we are going to see the steps to convert degrees to radians using the Unit Conversion feature of Kutools.

  • First, you need to select the data that you want to convert to radians.

Example
Example

  • Then, go to the Kutools Tab, select the Content option, choose the Unit Conversion option from the menu.

Kutools Tab
Kutools Tab

  • It will display the Unit Conversion Dialog box.
  • Units drop-down list – You need to select the Angle option.
  • Then, you need to select the Degree in the left list box, select the Radian option in the right list box.
  • You can see the preview results in the Preview Pane.

Unit Conversion Dialog box
Unit Conversion Dialog box

  • Finally, click the OK button to get the output as shown in the below image.

Output
Output

Note:

  • Add result as comment – You can check this option if you want to insert the output as comments not the original cells.

Steps to Convert Meters to Feet, Inches, Miles, or Yards:

To convert meters to feet, inches, miles, or yards in Excel, follow the below steps.

  • You need to select the range that you want to convert.

Input Range
Input Range

  • On to the Kutools Tab, select the Content option, choose the Unit Conversion option from the menu.

Kutools Tab
Kutools Tab

  • It will open the Unit Conversion Dialog box.
  • Units drop-down list – ** You need to **select the Distance option.
  • Then, you need to select the Meter in the left list box, select the Foot option in the right list box.
  • You can see the preview results in the Preview Pane.

Click OK button
Click OK button

  • At last, hit the OK button to get the result. Refer to the below screenshot.

Output
Output

Note:

  • Metric prefix – You can click this drop-down list to choose the units that you need.
  • Add result as comment – You can check this option if you want to insert the output as comments not the original cells.

Convert Celsius to Fahrenheit/Kelvin:

If you want to convert Celsius to Fahrenheit or Kelvin, then follow the below steps.

  • First, you need to select the input range that you want to convert.

Select the range
Select the range

  • Go to the Kutools Tab, select the Content option, choose the Unit Conversion option from the menu.

Kutools Tab
Kutools Tab

  • It will display the Unit Conversion Dialog box.
  • Units drop-down list – ** You need to **select the Temperature option.
  • Then, you need to select the Celsius in the left list box, select the Fahrenheit or Kelvin option in the right list box.
  • You can see the preview results in the Preview Pane.

Unit Conversion Dialog box
Unit Conversion Dialog box

  • Finally, click the OK button to see the result as shown in the below image.

Result
Result

Summary:

In the above article, you can easily understand the steps to Convert Between Various Measurements Units without using Formulas in Excel Office 365 using Kutools. ** Don’t forget to share your **feedback with us. Thanks for visiting Geek Excel. Keep Learning!

Read Also:

Top comments (0)