How to use fill handle on excel

August 3, 2022
151 Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

The function of fill handle is that it follows a pattern rule or copy cells how much you want it. But to properly use the function, you must know how to use fill handle on excel in different cases.

This example will explain multiple ways the fill handle can be used to fill the values in cells and will eventually put an end to your question how to use fill handle on excel. So let’s get started.


Case 1: Use fill handle to insert numbers in cells with single entry

1. Open a document that has a single number. Here is just one number is shown as example.

2. Click on the cell to highlight cursor with number.

3. Now hover over your mouse at the bottom right corner of cell. Notice it turns to + sign.

4. Now click, hold, and drag your mouse upto the required cells count. Now release the button. The numbers are filled in the cell.



Case 2: Use fill handle to insert numbers in cells with ascending numbers entry

This is useful when you have few numbers and they are discontinued in series and you want to complete the counting.

1. Open a document that has a single number. Here are few numbers shown as example.

2. Select cells that contains discontinued series of numbers.

3. Now hover over your mouse at the bottom right corner of cell. Notice it turns to + sign.

4. Now click, hold, and drag your mouse upto the required cells count. Now release the button. The numbers are filled in the cell.




Case 3: Use fill handle to insert days of a week.

1. Open a document that has a single or series of days mentioned. Here is just one day shown as an example.

2. Click on the cell to highlight cursor with day.

3. Now hover over your mouse at the bottom right corner of cell. Notice it turns to + sign.

4. Now click, hold, and drag your mouse upto the required cells count. Now release the button. The days are filled in the cell.



Case 4: Use fill handle to insert months of a year

1. Open a document that has a single or series of months mentioned. Here are name of some months shown as an example.

2. Click on the cells to highlight cursor with the month name.

3. Now hover over your mouse at the bottom right corner of cell. Notice it turns to + sign.

4. Now click, hold, and drag your mouse upto the required cells count. Now release the button. The month are filled in the cell.



Case 5: Use fill handle to insert items list

1. Open a document that has a single or series of items list. Here are few items list shown as an example.

2. Select the cells containing items list.

3. Now hover over your mouse at the bottom right corner of cell. Notice it turns to + sign.

4. Now click, hold, and drag your mouse upto the required cells count. Now release the button. The additional items numbers are filled with increasing order.

This is how to use fill handle on excel to carry out different tasks. Need to edit Word/Excel/PPT file free of charge? Download WPS Office edit files like without any cost. Download now! to get enjoyable working experience.