If you work in a field like carpentry, engineering, architecture, or technology, you probably are! Squaring a number is the mathematical operation of multiplying a number by itself. As an example, a square-sized bedroom measuring 10 feet wide and 10 feet long could be expressed as 100 square feet by multiplying 10 by 10. This post explores all the different ways to square a number in Microsoft Excel.
Square a Number with the Multiplication Operator
The most straightforward way to square a number is to multiply it by itself using the traditional multiplication operator. The above formula will multiply the number in cell B3 by itself. The asterisk (*) is the operator for multiplication. You’ve just squared your number from cell B3! To apply your formula to your other numbers, hover over the lower-right corner of the formula’s cell until your cursor turns to a plus (+), then double-click.
Square a Number with the Carat Operator
The carat operator (^) in Excel is designed for the specific operation of raising a number to a given power such as a square. To implement the carat operator on your number in cell B3, select an empty cell and paste the above formula into the formula bar. The above value 2 following the carat operator is called the exponent of your number. Specifying 2 as your exponent will square the number. Your number has been squared! Hover the cursor over the active cell fill handle and double-click to fill the formula down.
Square a Number with the POWER Function
The POWER function is an expert way to calculate a number involving an exponent. To square your number from cell B3 using the POWER function, select an empty cell and paste the above formula into the formula bar. The second argument is 2. This is the exponent of your number, so always specify 2 here for squaring. Press Enter when done and see how your number gets squared! To apply your formula to your other numbers, hover over the lower-right corner of the formula’s cell until your cursor turns to a plus (+), then double-click.
Square a Number with the PRODUCT Function
The PRODUCT function provides general multiplication of values in Excel. Because squaring is just a specific case of multiplication, you can use PRODUCT to square your number. To use PRODUCT against your number in cell B3, select an empty cell and paste the above formula into the formula bar. Your cell B3 is specified twice in the above formula because you’d like to multiply the B3 number by itself. Press Enter to calculate the square of your number! Double-click on the active cell fill handle to copy and paste the formula down your column.
Square a Number with the SUMSQ Function
Though the SUMSQ function is generally used for the summation of squared numbers, its summation feature is optional, leaving you the ability to simply square a single number. To leverage SUMSQ for a number in cell B3, select an empty cell and paste the above formula into the formula bar. You only need to provide your value from the cell B3 and SUMSQ will square it. Press Enter and behold your squared number! Double-click on the fill handle to copy down the formula.
Square a Number with Paste Special
Excel has a paste special feature that allows you to multiply copied numbers. To square numbers using this feature, you copy your numbers to the clipboard, then paste over it with an instruction to multiply it by the clipboard contents. Here’s how it works for a range of numbers. Alternatively, you can simply press Ctrl + Alt + V. This will open the Paste Special menu. Each number in your selected range has now been squared!
Square a Number with Power Query
Power Query is a powerful data transformation tool for Excel table data. Once your numbers are arranged in a table, you can create a query that dynamically squares your numbers by using a Power Query formula. Follow these steps to get started. Your numbers have now been squared! You can then place the squared numbers on your sheet. Now your squared numbers appear as a range alongside your original numbers!
Square a Number with VBA
VBA is the code responsible for automating tasks in Excel. If you’d like to square numbers in a range based on what is currently selected, VBA would be a good way to do that. Here’s how to explore this option. The code will retrieve each cell in the currently-selected range selectedRange. The cell’s value will get updated to a multiple of itself, effectively squaring the number. The Len() function is used to skip blank cells to which squaring does not apply. Tada! Your numbers have been squared in place!
Square a Number with Office Scripts
Office Scripts is the latest automation language available in Excel for the web if you have a Microsoft 365 business plan. With Office Scripts, you can create a reusable script to automate the squaring of your numbers in a selected range. Follow these steps to start your script. The script gets the currently-selected range and loops through each cell. The cell’s value gets updated to a multiple of itself. This squares the number before moving to the next cell. This avoids updating blank cells by checking the length of the cell value before multiplying the value. You can then run your script. The script has now replaced all your selected numbers with their squares!
Conclusions
In this post, you’ve seen many different options to square a number in Excel. For a workbook whose calculations need to be easily understood, a traditional multiplication operator is a good option. Whereas the carat operator can offer a more concise formula. The POWER, PRODUCT, or SUMSQ functions will get the job done and integrate better into a workbook that takes advantage of its unique design features. The paste special option is an interesting way to square numbers in place on your sheet. The Power Query option could be useful to square numbers as part of a larger workbook data transformation. Finally, for a fully automated solution that reacts to changing range selections, VBA or Office Scripts is a good option. The choice will generally depend on which Excel app you’re using. Office Scripts is best for the web, while VBA is a good desktop alternative. Which method do you use when you need to perform square calculations? Let me know in the comments!
