How to use fill handle on excel
A free Office suite fully compatible with Microsoft Office
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.
Was this helpful?
Yes
No
Trending Tutorials
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. How to compare two excel sheets and highlight differences
- 3. Check if value is in list in Excel (3 easy methods)
- 4. How to copy file names in Excel from a folder?
- 5. How to color cell based on value in Excel?
- 6. How to add month name from date in Excel formula