Every Excel users, from 1995 to 2016 knows that you can move your cursor to the bottom right of a cell and drag down to copy the formula to the cells below. However, what would you do if you have, says, thousands of rows to copy the formula to? Dragging the cursor seems to be a tedious task.
Don’t worry if you have many rows to copy the formula to. You can move your cursor to the bottom right of the cell you wan to copy the formula as you did before. However, instead of dragging, simply double click on that corner, the formula will be copied to all the cells below.
This simple tip can save you a lot of time when working with excel. Now, you don’t need to keep dragging the cursor thousands row down.
I hope the tip is helpful to you. Feel free to check our excel suggestion tool. It is a tool that help you quickly fill data from a pre-defined list. Entering data with excel is no longer a difficult and time-consuming task.