This download accompanies our Excel 2016 and 2019 cheat sheet. See that article for detailed information on how to get the most out of Excel 2016 and Excel 2019 for Windows.

Excel should automatically pick the entire range of said data (provided you don’t have any blank columns interrupting your dataset), and convert this into an editable, table-as-you-go kind of setup.

In the Excel sheet below, in the first table, you can see two numbers 10 and 5, which is our data. In the other table, you can see the operations to be carried out by applying appropriate formulas.