How to Convert Inches to Cm in Excel (2 Quick Ways)

Get FREE Advanced Excel Exercises with Solutions!

Conversion of units is very common in any kind of calculation in mathematics, engineering, and other fields. This is because different unit standards are available. One of the easiest ways is to multiply or divide them with the corresponding value and convert them to the desired unit. Without this technique, other techniques are also available. In this article, we will show 2 techniques to convert inches to cm in Excel with proper explanations.

How to Convert Inches to Cm in Excel: 2 Ways

Here, we will show a total of 3 techniques to convert from inches to cm in Excel. For this purpose, we took a dataset of measurement of a box of 3 dimensions. Now we will convert them into centimeters (Cm) from Inches in Excel.

1. Multiply by Conversion Rate

In the first method, we will show the use of multiplication by conversion rate to get inches value in centimeters. We can do this in the following ways.

1.1 Using Direct Multiplication Formula

We can convert inches to cm by simple multiplication. It is the conventional way to convert from one unit to another. We already know that,

1 inch=2.54 cm

So, if we multiply inches values by 2.54., we will easily get values in centimeters. Now, follow the steps further.

📌 Steps:

  • We added a column named Centimeter for the converted values.
  • Now, go to Cell D4 of the Centimeter column.
  • Put the following formula based on simple multiplication.

Multiply by Conversion Rate in Excel

  • Now, press the Enter button.

We get the converted value of the corresponding Cell C4.

  • Now, copy the formula downwards.

Multiply by Conversion Rate in Excel

All dimensions are converted into centimeters now.

Read More: How to Convert Millimeters (mm) to Inches (in) in Excel

1.2 Using Paste Special Tool

You can also use the Paste Special to convert from Inch to Cm by multiplication. Follow the steps to the end.

📌 Steps:

  • First, write the conversion rate in Cell C8.

We input the conversion value of Inch and Cm. Cell C8 contains 2.54, which is equivalent to 1 inch.

  • Now, copy Cells C4 to C6 by pressing Ctrl+C.

Excel Paste Special Feature to Convert Inches to Cm

  • Paste the values on Cells D4 to D6 by pressing Ctrl+V.

Excel Paste Special Feature to Convert Inches to Cm

Here, we applied the simple copy-and-paste method.

  • Now, copy Cell C8.
  • Then, select Cells D4:D6.
  • Now, press the right button of the mouse and get the Context Menu.
  • Choose the Paste Special option from the Context Menu.

Excel Paste Special Feature to Convert Inches to Cm

  • The Paste Special window will appear.
  • Check the Multiply option from the Operation section.

Excel Paste Special Feature to Convert Inches to Cm

  • Finally, press OK.

We get the converted values successfully.

Read More: How to Convert Inches to Meters in Excel

2. Use Excel CONVERT Function

In this section, we will use the CONVERT function. This CONVERT function can disciple from one unit to another unit with one click.

The CONVERT function converts a number from one measurement system to another.

📌 Steps:

  • Go to Cell D4 and put the formula based on the CONVERT function.

Excel CONVERT Function for conversion of Inches to Cm

  • Press the Enter button.

Inch has converted to Cm here.

  • Pull the Fill Handle icon downwards.

We get the desired result.

Read More: How to Convert Units in Excel 

Convert Inches to Cm and Other Units with a Dynamic Excel Formula

So far, we have learned 2 quick methods to convert inches to centimeters in this article. Now I will show you a formula that can be used not only to convert inches to cm, but it allows many more unit-conversion tasks. This technique involves the use of data validation and the VLOOKUP function along with the previously used CONVERT function.

The VLOOKUP function looks for the value at the leftmost column of a table and then returns a value in the row from a column you specify. By default, the table must be in ascending order.

📌 Steps:

  • First, we create a list of units of Length on another sheet named Units.

Convert Inches to Cm and Other Units with a Dynamic Excel Formula

  • We added rows for Unit conversion.

One side is From and the other side is To.

  • Now, select Cell B5.
  • Choose Data Tools from the Data tab.
  • Finally, select the Data Validation option.

Convert Inches to Cm and Other Units with a Dynamic Excel Formula

  • Data Validation window will appear.
  • Select List as Allow.
  • Then, click on the Source box.
  • Choose the cells of the Units sheet.

Convert Inches to Cm and Other Units with a Dynamic Excel Formula

  • We can see an arrow sign on Cell B5.

  • Similarly, apply this to Cell D5.

  • Now, click the arrow on Cell B5. Choose the desired unit from the list. We choose “in” here.

Convert Inches to Cm and Other Units with a Dynamic Excel Formula

  • Similarly, choose “cm” on Cell D5.

  • Now, put the following formula at Cell D4.

Convert Inches to Cm and Other Units with a Dynamic Excel Formula

  • Now, hit the Enter button.

We see “0” on Cell D4.

  • Now, put any value on Cell B4 and get the converted value on Cell D4.

Read More: How to Convert inch to mm in Excel

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


In this article, we described how to convert inches to cm in Excel. We added formulas and other techniques as well. I hope this will satisfy your needs. If you have any questions or suggestions regarding the article, feel free to let us know in the comment box.

Related Articles

<< Go Back to Excel CONVERT Function | Excel Functions | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Alok Paul
Alok Paul

Alok Paul has completed his B.Sc. in Electronics and Telecommunication Engineering from East West University. He has been working on the ExcelDemy project for more than 2 years. He has written 220+ articles and replied to numerous comments. He is experienced in Microsoft Office, especially in Excel. He also led some teams on Excel and VBA content development. He has a keen interest in Advanced Excel, Data analysis, Excel Pivot Table, Charts, and Dashboard. He loves to research... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF