Create a Linear Series of Values in Excel
Here’s how to use Auto Fill to create a series of values:
1. Create the initial series. In a Microsoft Office Excel workbook, type 1 in the A1 cell and 2 in the A2 cell.
2. Select cells A1 and A2.
3. Click the Auto Fill handle (the little black box in the lower-right corner of the selection) and drag to A15 to fill the cells with the numbers 1 through 15. You can create different series of numbers, odd and even numbers, or even dates.
Here’s how to use Auto Fill to create a series of values:
1. Create the initial series. In a Microsoft Office Excel workbook, type 1 in the A1 cell and 2 in the A2 cell.
2. Select cells A1 and A2.
3. Click the Auto Fill handle (the little black box in the lower-right corner of the selection) and drag to A15 to fill the cells with the numbers 1 through 15. You can create different series of numbers, odd and even numbers, or even dates.
Tidak ada komentar:
Posting Komentar