Excel · 1 min

Stop retyping: fill a column in one move

Copy a formula down a whole column with a double click.

Type your formula in the first cell. Then put your mouse on the small square at the bottom right corner of that cell.

Double click on that square. Excel fills the whole column for you, down to the last row of your data.

Why it helps: no more copy and paste, and no cell forgotten.

Mark as read