How to Square a Number in Excel

How to Square a Number in Excel

"Squaring a number" is a well-known mathematical function. You may use it in Excel spreadsheets. For example, a squared number has been multiplied by itself. People create this operation to make n-fold multiplication calculations more accessible and convenient. For example, if you need to increase a number to a higher power.

There are various simple techniques to square a number in seconds. This post will go you through the entire process. 

  • Use the Caret Operator.

  • Use the POWER function.

  • Use the Multiplication Operator.

How to Square a Number in Excel

Use The Caret Operator.

A straightforward way of squaring a number using only one symbol is the "caret" (‘^’). This method also includes calculating with a basic formula.

To use the Caret Operator correctly, follow these steps:

1. Choose the cell that you want the result to appear (B1) there.

2. Type the formula "=A12" in the Formula Bar, where...

The cell holds the number you wish to square "A1," The caret number is "2."


3. On your keyboard, press the Enter or Tab key.


You have your result in B1 and are ready to go! 

Use the POWER Function.

Excel has a function to raise a number to a specified power. The POWER function increases one number to the power, like an exponent in a traditional mathematical equation.

The POWER function has the following syntax:

= POWER (number, power)


  • Number is the number to be raised to an exponent.

  • Power is the exponent you wish to use when growing a number to a higher power.

So, to use the POWER function to calculate the square of an integer, like the value in cell A2, you must first raise it to the power of 2 as seen: =POWER(A2,2). So, here are the steps to finding the square of each number in our given dataset:

1. Choose the cell in which you want the first result to appear (cell B2).

2. Enter the following formula: =POWER (A2,2).

3. Hit the return key.

4. The result in cell B2 should now be the square of the number in A2.


5. Drag the fill handle (the small square in the bottom right corner of cell B2) until you reach your dataset's end.

6. Each cell in column B should now have the square of the matching number in column A. 


Use The Multiplication Operator.

There is one more function that can be useful when multiplying numbers. The Multiplication Operator is represented by the asterisk symbol "*." Let's go over the procedure for this one:

1. Choose the cell where you want the result to appear (B1).

2. On the Formula Bar, enter the formula "=A1*A1," where "A1" is the cell containing the number to be multiplied by itself.


3. To view the result, use the Enter or Tab key on your computer.


It's that simple! You've completed the task!

Note: If you wish to square an entire column of numbers at once, you can do so with a single click. To square the last row, choose the corner icon in the cell containing the formula (in this case, B1). And drag the pointer down the list. If you select many cells, the procedure will be pasted into them! 


1. In Excel, how do you create a power formula?

Insert a caret "^" into the formula bar, followed by the power. For example, to multiply 3 to the power of 4, type "34" and hit "Enter" to finish the formula.

2. In Excel, what is the square root function?

The SQRT function in Excel returns the square root of a positive value.

If the number is negative, SQRT returns an error. It is because the SQRT function accepts one argument, a number, which must be a number.

3. In Excel, how do you write root 3?

You can use Excel's caret operator (^) and 1/3 as the exponent to find the cube root of a value. For example, the procedure =D3(1/3) is used to get the cube root of 216, which is 6. 


Above are three ways we provide you to square a number in Excel. We hope it is easy for you to do. And it would be fantastic if you could gain more knowledge about Excel from this article. 

1 ratings
Jessica Vieira
Jessica Vieira
Jessica Vieira is ProductReviews's senior media reporter, covering the intersection of entertainment and technology.