![easy numbering xcel easy numbering xcel](https://i.ytimg.com/vi/EXeZuO-jzM8/maxresdefault.jpg)
So to square the value in cell A2 you need to raise it to the power of 2. In Excel, you can raise one number to the power of another using the exponent operator, also known as a caret symbol (‘^’). Each cell in column B should now contain the square of the corresponding value in column A.Drag down the fill handle (the small square at the bottom right corner of cell B2) till you reach the last row of your dataset.The square of the value in A2 should now be displayed as the result in cell B2.
![easy numbering xcel easy numbering xcel](https://i.pinimg.com/originals/24/f9/b8/24f9b832cd068e7515eeb93dede7a8d9.png)
Select the cell where you want the first result to appear (cell B2).
![easy numbering xcel easy numbering xcel](https://cdn.educba.com/academy/wp-content/uploads/2019/02/Autonumbering-in-Excel-example-5-1.png)
Thus, here are the steps you can follow to find the square of each number in our given dataset : So to multiply the value in cell A2 with itself, you can use the formula: =A2 * A2 In Excel, you can multiply numbers using the multiplication operator, also known as an asterisk symbol (‘*’).
#Easy numbering xcel how to#
Let us see how to accomplish this in Excel. In this dataset, we want to find the square of each value of column A and display the result in column B. To understand how to quickly square numbers in Excel, we are going to use the following dataset: Two Quick Ways to Square a Number in Excel