Sequential dating in excel cells


If, for some reason, you don't want to start with a selection of two cells, you could simply select one cell (A2) and hold down the Ctrl key as you drag the fill handle downward.Auto Fill will override its normal determination (copy the selected value downward) by forcing a series of numbers into the filled cells.A linear series can consist of decimals (1.5, 2.5, 3.5, 4.5), decreasing values (100, 98, 96, 94), or negative numbers (-1,-2,-3,-4).But in each case we ADD (or subtract) the constant or step value.(For example, if you only want to use even numbers for some reason, then in my example you would enter a 2 in A1 and enter: =A1 2 in cell A2.) Hello Satiria This is my understanding of the question, when someone enters information in a column, then the cell next to it will automatically add numbers.If this is the case, I have added a spreadsheet that I refer back to in order to accomplish it.

For example, enter the value 1 into cell A1 and the value 2 into cell A2.

If you select cell A2 and use the Auto Fill handle to drag downward, what happens is that Excel fills each of the cells with the value 2. Because you only started by selecting a single cell.

On the other hand, if you select cells A1: A2 and then drag down, Auto Fill will increment the value placed into each of the cells. Because it can analyze the information you started to enter in the cells and use it to determine how to fill the remaining cells with a series of values.

If you're still having problems, make sure that your filters are clear.

If filters are turned on, they may cause the same number to repeat, even when selecting more than one cell.

Deb is trying to Auto Fill record numbers in a column of her worksheet; record 1 in the first cell, record 2 in the second cell, etc.

You must have an account to comment. Please register or login here!