How to Square a Number in Excel? 2 ways

Squaring a number in Excel is quick and easy, and you can do it in just a couple of ways. Whether you want to multiply the number by itself or use a special formula, both methods will give you the answer you need. In this blog, you’ll learn two simple ways to square a number in Excel, so you can handle calculations faster and make your work even easier.

---

Method 1: Use the Caret (^) Operator

This is probably the fastest way to square a number in Excel. The caret symbol (^) represents exponentiation — so raising something to the power 2 will square it.

How to do it:

1. Suppose you have a number in cell A1.
2. In another cell (say B1), type the formula: =A1^2
3. Press Enter. Excel will calculate the square of the number in A1.
4. If you have a list of numbers, just drag the fill-handle (bottom-right corner of B1) down — Excel will apply the same formula to the other cells.

This method is very intuitive and works well when you’re doing simple calculations.

---

Method 2: Use the POWER Function

If you prefer using functions or want a formula that is more descriptive, the POWER function is a great option.

How to do it:

1. Assume your base number is in cell A1.
2. In cell B1 (or any other cell), type: =POWER(A1, 2) Here, A1 is your number, and 2 is the exponent (because you want to square it).
3. Press Enter. The result will be the square of the value in A1.
4. Just like before, drag the formula down if you need to apply it to multiple cells.

Using POWER is especially helpful if you want to raise a number to different powers.

---

Bonus: Multiplying the Number by Itself

Although the user asked for 2 ways, it’s worth knowing a third method which is conceptually very simple:

• You can directly multiply the number by itself using: =A1 * A1 This works the same as squaring it

---

Conclusion

Squaring a number in Excel is easy and can be done in two main ways: using the caret operator (^) or using the POWER function. Both are efficient and useful — which one you choose depends on your preference and the complexity of your task. Try both and pick the one that suits your workflow!