How to Apply a Formula to an Entire Column on Google Sheets on PC or Mac
Go to https://sheets.google.com in a web browser.. Open a Google Sheet document from your list.. Enter the formula in the first cell of the column.
Steps
1
Go to https://sheets.google.com in a web browser.
Go to https://sheets.google.com in a web browser.
2
Open a Google Sheet document from your list.
Open a Google Sheet document from your list.
3
Enter the formula in the first cell of the column.
Enter the formula in the first cell of the column.
4
Click the cell to select it.
Click the cell to select it.
5
Drag the cell's handle to the bottom of your data in the column.
Drag the cell's handle to the bottom of your data in the column.
6
Use the keyboard shortcuts.
Use the keyboard shortcuts.
Comments (0)
No comments yet. Be the first to share your thoughts!