In this article, we'll show you how to apply a formula to an entire column in Google Sheets on Windows and Mac OS X computers.
Step 1. Go to https://sheets.google.com in your web browser
If you are already logged in, your documents (tables) will be displayed on the screen.
If you are not already signed in to your Google Account, sign in now
Step 2. Open the required table
- You can also click on the icon
to create a new table.
Step 3. Enter the formula in the first cell of the column
If the table contains a row with headers, do not enter the formula in the cell with headers
Step 4. Select a cell
To do this, click on it.
Step 5. Copy the formula to other cells in the column
To do this, press and hold the small square icon in the lower right corner of the formula cell, and then drag this icon to the last cell you want. When you release the mouse button, the formula that is in the first cell will be displayed in all the required cells.
Step 6. Use the keyboard shortcut
Do this if there are so many cells that dragging the cell with the formula becomes a problem, or if the formula needs to be copied to all the cells in the column at once:
- Click on the cell with the formula.
- Click on the letter of the column (it is above the column).
- Press Ctrl + D (Windows) or ⌘ Command + D (Mac).