Question

How to apply a function to all cells in sheets?

Answer 1

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 intoevery cell in your selection.