Tables offer a lot, but my favorite feature is the formula auto-fill. Normally, you enter a formula and use the fill handle to copy the formula as needed.

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 ...

Add a column to any data set in an Excel spreadsheet and fill it with random numbers generated with RAND () b_y dragging the _RAND formula down the column.