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 put the initial value in A1 and press enter](https://howtech.tv/wp-content/images/001760/01.jpg)
Go back to A1 by clicking once.
![go back to A1 by clicking once go back to A1 by clicking once](https://howtech.tv/wp-content/images/001760/02.jpg)
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](https://howtech.tv/wp-content/images/001760/03.jpg)
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](https://howtech.tv/wp-content/images/001760/04.jpg)