Incrementing values in Microsoft Excel 2019

Entering a number— for example, 15—into a cell, and then holding downthe Ctrl key while dragging the fill handle will create anincremented series. Notice that when holding down the Ctrl key,a second + is shown above the existing+ fill handle. This indicates that youwill increment values as you drag using the mouse. Instead of typing 1,2, 3… into separate cells, simply type 1 into a cell, then hold downthe Ctrl key and drag the AutoFill icon to increment thevalues, as illustrated in the following screenshot:

ms office 643

Once the values are entered into the cells, the AutoFill options iconis displayed, where further data customization can be selected.

Leave a Comment