Sequential dating in excel cells

When you release the mouse button, you’ll notice that the value has been copied into the cells over which you dragged the fill handle.Why didn’t it fill the linear series (1, 2, 3, 4, 5 in our example)?

However, this might not always be feasible for discontinuous cells or increments created from dates that are subject to change.You can type the first number, press Enter to get to the next row in that column, and enter the next number, and so on.Very tedious and time consuming, especially for large amounts of data.In each linear series, you add (or subtract) the same step value.Let’s say we want to create a column of sequential numbers, increasing by one in each cell.

Leave a Reply