How to Apply a Formula to an Entire Column on Google Sheets on PC or Mac

This wikiHow teaches you how to apply a formula to an entire column using the full desktop website of Google Sheets.

Steps

  1. Image titled Apply a Formula to an Entire Column on Google Sheets on PC or Mac Step 1
    1
    Go to https://sheets.google.com in a web browser. If you are logged into your Google account, this will show you a list of all the documents associated with your account.
  2. Image titled Apply a Formula to an Entire Column on Google Sheets on PC or Mac Step 2
    2
    Open a Google Sheet document from your list.
    Advertisement
  3. Image titled Apply a Formula to an Entire Column on Google Sheets on PC or Mac Step 3
    3
    Enter the formula in the first cell of the column.
    • If you have a header row with titles, don't put the formula in the header.
  4. Image titled Apply a Formula to an Entire Column on Google Sheets on PC or Mac Step 4
    4
    Click the cell to select it.
  5. Image titled Apply a Formula to an Entire Column on Google Sheets on PC or Mac Step 5
    5
    Drag the cell's handle to the bottom of your data in the column. Click the small blue square at the bottom-right of the cell and drag it down across all the cells you want to apply the formula to. When you release the click, the formula from the first cell will be copied into every cell in your selection.
  6. Image titled Apply a Formula to an Entire Column on Google Sheets on PC or Mac Step 6
    6
    Use the keyboard shortcuts. If the column is too long to drag or if you want to apply the formula to the entire column of the spreadsheet:
    • Click the cell with the formula.
    • Click the column letter at the top.
    • Press Ctrl+D (Windows) or ⌘ Command+D (Mac).
    7. Advertisement

Community Q&A

  • Question
    How to do this? For entire column D, I want it to do same formula, but per line. A1+B1+C1=D1, A2+B2+C2=D2, A3+B3+C3=D3, etc How do I add this formula to column D?
    Community Answer
    Community Answer
    In column D1, type "=A1+B1+C1", then hit enter. Next, click the bottom right corner of the D1 cell (known as the fill handle) , and drag it down the D column. Google sheets will add the correct formula to each cell that you drag the fill handle over.
  • Question
    Is Command+D is the Add Bookmark feature in Chrome?
    Community Answer
    Community Answer
    Yes. Command+D on Mac and Ctrl+D on Windows is the shortcut to add a bookmark.
  • Question
    How do I get a column in Google Sheet to automatically re-calculate?
    Community Answer
    Community Answer
    Google Sheets should already recalculate if you are using formulas. If you update cells contained in the formula, the column should recalculate.
Advertisement

You Might Also Like

Sign Out of Your Google Account on All Devices at Once
How to
Sign Out of Your Google Account on All Devices at Once
Turn Off Google Safesearch
How to
Turn Off Google Safesearch
Restore Google AuthenticatorHow to Restore Google Authenticator if You Lost or Reset Your Phone
Fix the "Google Play Store Has Stopped" Error
How to
Fix the "Google Play Store Has Stopped" Error
Google Sheets How to Insert Time in Cell Automatically4 Easy Ways to Add the Time and Date Automatically in Sheets
Write a Review on Google2 Ways to Write a Review on Google
Turn Off Google Ads
How to
Turn Off Google Ads
Get a Google Voice Phone NumberHow to Sign Up for a New Google Voice Phone Number
Search by Image on GoogleReverse Image Search in Google Lens: Android, iPhone, & Desktop
Make a Google Account5 Easy Steps to Create a Google Account on Any Device
Make a Time Slot Sign Up Sheet on Google FormsHow to Make a Sign Up Sheet with Time Slots in Google Forms
Do Google GravityHow to Do the Google Gravity Trick in Your Browser
Create a Website Using Google Sites
How to
Create a Website Using Google Sites
Use Google TranslateEasy Ways to Use Google Translate on Desktop and Mobile
Advertisement

About This Article

Travis Boylls
Written by:
Travis Boylls
wikiHow Technology Writer
This article was co-authored by wikiHow staff writer, Travis Boylls. Travis Boylls is a Technology Writer and Editor for wikiHow. Travis has experience writing technology-related articles, providing software customer service, and in graphic design. He specializes in Windows, macOS, Android, iOS, and Linux platforms. He studied graphic design at Pikes Peak Community College. This article has been viewed 228,582 times.
How helpful is this?
Co-authors: 4
Updated: February 9, 2023
Views: 228,582
Categories: Google Applications
Advertisement