Say you want to fill column A, starting in cell A2, with the values 1, 2, and so on up to 1000. There is an easy way.
To fill a column range with a series:
Enter the first value in the first cell (1 in cell A2). With the cursor in the starting cell (A2), select the Fill dropdown and then select the Series option to obtain a dialog box. (The Fill dropdown is in the Editing group of the Home ribbon.) Change the Rows setting to Columns, make sure the Type setting is Linear, make sure 1 is in the Step Value box, enter the final value (1000) in the Stop Value box, and click on OK.
As you can guess from this dialog box, many other options are possible. Don’t be afraid to experiment with them.
Try it! The series of days in column A should go from 1 to 25, in column D it should go from 26 to 50.
Dostları ilə paylaş: |
