How to Square a Number in Google Sheets

Last Modified: January 13, 2024 - 2 min read

Julian Alvarado

TL;DR: Square numbers in Google Sheets using the POWER function (=POWER(number, 2)) or by multiplying the number by itself (=A1*A1). Drag the formula for multiple numbers.

Squaring numbers in Google Sheets is a basic yet essential function for various calculations, from financial modeling to data analysis. This guide provides a straightforward method to square numbers in your spreadsheet.

Step 1: Open Your Google Sheet

Begin by opening the Google Sheets document where you need to square numbers.

Step 2: Enter or Identify Your Number

Place the number you want to square in a cell. If the number is already in the sheet, locate the cell containing it.

Step 3: Using the POWER Function

The easiest way to square a number is to use the POWER function. Click on the cell where you want the squared result to appear. Type =POWER(number, 2), replacing ‘number’ with the cell reference or the actual number. Press Enter.

spreadsheet ai
Free AI-Powered Tools Right Within Your Spreadsheet

Supercharge your spreadsheets with GPT-powered AI tools for building formulas, charts, pivots, SQL and more. Simple prompts for automatic generation.

Step 4: Squaring a Number with Multiplication

Alternatively, you can square a number by multiplying it by itself. In a new cell, type =A1*A1 (assuming A1 is the cell with your number). Press Enter.

Step 5: Drag to Apply to Multiple Numbers

If you have a column of numbers to square, use the fill handle (a small square at the bottom right of the cell) to drag the formula down to other cells.

Tips for Squaring Numbers:

  1. Use Relative or Absolute References: Understand when to use relative (like A1) and absolute references (like $A$1) depending on whether you want the formula to change when copied to other cells.
  2. Check for Errors: Ensure your numbers are correctly formatted (as numbers, not text) to avoid errors in calculations.
  3. Combine with Other Functions: You can combine the squaring function with others for more complex calculations, like =SUM(A1:A10)^2 to square the sum of a range.

Sync Live Data into Your Spreadsheet

Connect Google Sheets or Excel to your business systems, import your data, and set it on a refresh schedule.

Try the Spreadsheet Automation Tool Over 350,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 350,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Julian Alvarado Content Marketing
Julian is a dynamic B2B marketer with 8+ years of experience creating full-funnel marketing journeys, leveraging an analytical background in biological sciences to examine customer needs.
350,000+ happy users
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies