Now, use the fill handle to apply the same relative formula to cells B4 to B6. To finish this section, copy and paste the formula into cell E3, and use the fill handle again.

However, when you're creating a spreadsheet in Microsoft Excel, the double-click shortcut can be just as useful. In this guide, I'll share 11 of my favorite double-click Excel tricks. After typing a ...

Click on the formula bar and close the bracket. Hit Enter. When you are done, use the Fill Handle to copy the formula to all the cells.