How to Square a Number in Excel

If you want to square a number in Excel, you can use two easy ways to follow methods, and both methods work in the same way. You need to specify the number for which you want to calculate the square and specify 2 as you want to calculate the square.

Ahead in this tutorial, we will use an example to understand it.

Using POWER to Calculate Square

  1. Enter the POWER function in the cell.
  2. Refer to the cell where you have the number for which you need to calculate the square.
  3. In the second argument, enter 2 as you need to raise the power to 2.
  4. Close the function and hit enter.

The moment you need to hit enter the function returns the square as you can see in the above example.

Using to the Power Operator (^)

In the same way, you also use to the power operator (^) to get the square of a number in Excel. And in this method, you don’t need to use any function. Here’s the method:

  1. Refer to the cell where you have a number for which you want to calculate the square.
  2. Enter a ^ using the keyboard (you can find it on number key 6).
  3. Type 2, which tells Excel to raise its power to 2.
  4. Hit enter to get the result.

As I said, both functions work in the same way and are quite easy to use. But you can choose one according to your need.