How to Excel Populate Cells Automatically

To populate Excel cells automatically, put the initial value in A1, then press tab or enter.
put the initial value in A1 and press enter

Go back to A1 by clicking once.

In the bottom right corner of the cell you will see a plus sign; click and drag the plus sign horizontally across columns or vertically across rows.
In bottom corner, drag the plus icon down or to the right

In bottom corner, drag the plus icon down or to the right

The auto population will end at the cell you release the click. This will automatically populate Excel Cells.
Auto population will happen as you drag your cursor across the spreadsheet

Auto population will happen as you drag your cursor across the spreadsheet

HowTech