PRACTICALS-2 FILL CELL AUTOMATICALLY

 

👉Fill Cells Automatically

You can use Microsoft Excel to fill cells automatically with a series. For example, you

can have Excel automatically fill your worksheet with days of the week, months of

the year, years, or other types of series.

💁 Fill Times

The following demonstrates filling time:

1. Type 1:00 into cell C1.

2. Grab the fill handle and drag with your mouse to highlight cells C1 to C14.

Note that each cell fills, using military time.

3. Press Esc and then click anywhere on the worksheet to remove the

highlighting.

To change the format of the time:

1. Select cells C1 to C14.

2. Choose the Home tab.

3. Click the down arrow next to the number format box . A menu

appears.

4. Click Time. Excel changes the format of the time.

💁Fill Numbers

You can also fill in numbers.

1. Type a 1 in cell D1.

2. Type a 2 in cell D2.

3. Select cells D1:D2

4. Grab the fill handle and drag with your mouse to highlight cells D1 to D14.

5. The cells fill as a series, starting with 1, 2, 3.