How to Convert Kg to Lbs in Excel (4 Easy Methods)

Looking for ways to know how to convert kg to lbs? Then, this is the right place for you. Sometimes, we need to change kg to lbs. Such as, to calculate BMI some calculators want the values of weights in lbs. Here, you will find 4 different step-by-step explained ways to convert kg to lbs in Excel.

Download Practice workbook


4 Ways to Convert Kg to Lbs in Excel

Here, we have the following dataset containing the Age and Weight of some Children. Weights are given in Kilogram(kg). You can convert these kilograms (kg) values to Pound(lbs) by using the following methods.

Convert kg to lbs in Excel


1. Using Generic Formula to Convert Kg to Lbs

To convert kg to lbs we will use the Generic Formula. In other words, we will multiply the kg value by 2.20462.

Steps:

  • First, select Cell E5.
  • Then, insert the following formula.
=D5*2.20462

Convert kg to lbs in Excel Using Generic Formula

  • Now, press ENTER.
  • Then, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells.

  • Finally, values are now converted into lbs from kg.

Converting kg to lbs in Excel Using Generic Formula


2. Use of Paste Special Feature to Convert Kg to Lbs

We can also convert kg to lbs by using the Paste Specific Feature. To use this method, we inserted 2.20462 in Cell C13 as we know 1kg= 2.20462lbs.

Steps:

  • First, Copy the values of the Cells D5:D10 by using the keyboard shortcut CTRL+C.

Converting kg to lbs in Excel Using Paste Special Feature

  • Now, Paste the values in Cells E5:E10 by using the keyboard shortcut CTRL+V.

  • After that, Copy Cell C13 and select the Cells E5:E10.

Converting kg to lbs in Excel Using Paste Special Feature

  • Then, open the Home tab >> click on Paste >> select Paste Special.

Converting kg to lbs in Excel Using Paste Special Feature

  • The Paste Special box will open.
  • Then, select Multiply.
  • After that, press OK.

  • Finally, values are now converted into lbs from kg.

Converting kg to lbs in Excel Using Paste Special Feature


Similar Readings


3. Using CONVERT Function to Convert Kg to Lbs

Besides these two methods, we can convert kg to lbs using the CONVERT Function too. This function can convert units units of different measurement systems.

Steps:

  • To begin with, select Cell E5.
  • Then, type the following formula.
=CONVERT(D5,"kg","lbm")

Converting kg to lbs in Excel Using Convert Function

  • Now, press ENTER to get the value in lbs.
  • Then, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells.

  • Finally, the weights are converted to lbs from kg.

Converting kg to lbs in Excel Using Convert Function


4. Excel VBA to Convert Kg to Lbs

For the final step, we will use VBA to convert kg to lbs. VBA is a programming language. When you run the macros, you can see the result in the resultant cell.

Steps:

  • First, open the Developer tab >> click on Visual Basic.

Otherwise, you can use the keyboard shortcut ALT+F11 to do this too.

Converting kg to lbs in Excel Using VBA

  • Microsoft Visual Basic for Application bar will appear.
  • Then, from Insert >> select Module.

  • After that, a Module will open.

Converting kg to lbs in Excel Using VBA

  • Write the following code in the Module.
Option Explicit
Sub Convert_Kg_lbs()
Dim row_number As Integer
For row_number = 5 To 10
    Cells(row_number, 5).Value = Cells(row_number, 4).Value * 2.20462
Next
End Sub

Code Breakdown

  • First, we created Sub Procedure as Convert_Kg_lbs().
  • Then, we declared a variable row_number as Integer.
  • Next, we used a For Loop to go through from row 5 to row 10.
  • Then, within the For Loop used Cells.Value property to refer to the cell value of Column 4. Where Converted the Kg to Lbs by multiplying the value by 2.20462.
  • Finally kept the converted values in Column 5 by using Cells.Value property.

  • Finally, Save the code and go back to your sheet to execute your code.
  • First, from the Developer tab >> select Macros.

Converting kg to lbs in Excel Using VBA

  • The Macro dialogue box will open up.
  • Inside the box choose your Macro. In our case, we chose Convert_Kg_Ibs code.
  • Then, press Run.

  • Finally, the weights are converted from kg to lbs.

Converting kg to lbs in Excel Using VBA


Practice Section

In this section, we are giving you the dataset to practice on your own and learn to use these methods.

Practice Converting kg to lbs in Excel


Conclusion

So, in this article, you will find 4 ways to convert kilogram (kg) to Pound (lbs) in Excel. Use any of these ways to accomplish the result in this regard. Hope you find this article helpful and informative. Feel free to comment if something seems difficult to understand. Let us know any other approaches which we might have missed here. And, visit ExcelDemy for many more articles like this. Thank you!


Related Articles

Arin

Arin

Hello, I'm Arin. I graduated from Khulna University of Engineering and Technology (KUET) from the Department of Civil Engineering. I am passionate about learning new things and increasing my data analysis knowledge as well as critical thinking. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo