How to Square a Number in Excel (Two Most Common Ways)

How to Square a Number in Excel

In this tutorial we’re going to go through two most common ways how to square a number in Excel.

Keep watching to learn more!

Would you rather watch this tutorial? Click the play button below!

To square a number simply means to multiply the number by itself or, in other words, to raise it to the power of two.

First Way – How to Multiply the Number by Itself

Let’s have a look at the first way, which is how to multiply the number by itself.

Select the target cell and type in the equal sign.

How to Square a Number in Excel - type in the equal sign

Then click on the cell containing the number you want to multiply, in our case it’s B3. Then type in the asterisk, which is the sign for multiplication in Excel and click on the cell containing the number again. This way Excel will multiply the number in B3 by itself.

How to Square a Number in Excel - click on the cell containing the number you want to multiply
How to Square a Number in Excel - type in the asterisk

Now press Enter and here comes the result! One multiplied by one equals one.

How to Square a Number in Excel - press Enter and here comes the result

To copy the formula, simply drag the bottom right corner of the cell across all the cells below, which will square all the numbers in the data table.

How to Square a Number in Excel - drag the bottom right corner of the cell

Let’s move on now.

Second Way – How to Square the Numbers using “POWER” function

Delete the results and we’ll go through the second way how to square the numbers, but now we’ll use a function.

So, click on the target cell again, type in the equal sign and start typing ‘POWER’. Select the suggested function and now you’ll need two details.

How to Square a Number in Excel - Select the suggested function

The first one is ‘Number’ and the other one is ‘Power’.

How to Square a Number in Excel - you’ll need two details - number and power

‘Number’ is the number we want to raise to an exponent. Here it’s the number in B3.

How to Square a Number in Excel - Number’ is the number we want to raise to an exponent

Now we’ll add a comma and define the ‘Power’.

How to Square a Number in Excel - add comma

‘Power’ here will be represented by the exponent to the power of which we want to raise the number. In this case we want to square the number, so the ‘Power’ will be two. To raise the number to the power of three, we would need to enter 3, and so on. We’re squaring the number now, so we’ll leave the ‘Power’ at two.

How to Square a Number in Excel - the ‘Power’ will be two

Both details have been specified, so close the brackets, press Enter and that’s it! Quick, right?

How to Square a Number in Excel - close the brackets
How to Square a Number in Excel - result

Now you can copy the function by dragging the bottom right corner of the cell to fill the formula in the rest of the table and you’ll get the results for all the numbers.

How to Square a Number in Excel - copy the formula

Don’t miss out a great opportunity to learn:

If you found this tutorial helpful, give us a like and watch other tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers!

Thanks for watching and I’ll see you in the next tutorial!

Comments

Add comment

Your email address will not be published.

Your personal information will only be used for the purpose of processing this comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.