Now we get to the part where the spreadsheet comes in handy. Move your mouse so the cursor is over the little square of the bottom right corner of all the selected cells. You will notice it changes when you are directly over this little box. However, be sure you are over the little square, if you go over a line the cursor changes to something else.

 

If you are over a border line of the cells, the cursor changes to a 4 point arrow. That allows you to physically move the group of selected cells, which is not what we want to do. We want the little box in the lower right corner. Below I drew a red circle around it.



Click and drag it down about 20 rows. Then you will see the magic. If there is a number in a cell with some text, and you click-drag this box it will automatically increment. If there is only a number, it will simply copy the number. If there are two cells with two different numbers like 1,2 it will also increment those. Likewise, if the numbers are further apart such as 50, 100 the next number will be 150. This also works for sequential words such as January, February….Monday, Tuesday….

 

Once you have dragged this box down, you should see the following: