In this post, we will explore about the Microsoft Excel Fill handle.
What is Excel Fill Handle?
The Excel Fill Handle tool is a very useful tool that is used to fill data as per the specific pattern. By default, the fill handle and drag-and-drop editing are turned on in Excel.

How to Enable/ Disable Excel Fill Handle?
Click on the 'FILE' > Options. In the Advanced category, under Editing options, tick the checkbox "Enable fill handle and cell drag-and-drop check box" to enable it if you want to disable it untick the checkbox and click on the 'OK'.

Excel Fill Handle [With Examples]
Fill Numbers: To fill the number first type the start number and then press the ‘CTRL’ key and drag till the last number you want. You can use it vertically or horizontally as per the need.

Fill Numbers: We saw above one way now we will see the other way first type start number and then the 2nd number like 1 and 2 the difference between them 1 the excel will follow the same pattern. select both cells and drag till the last number. You can use it vertically or horizontally as per the need.

FAQs
What is Excel Fill Handle?

How to Enable Excel Fill Handle?

Where Can I Learn More About the Excel Fill Handle?
For Latest Updates & Learning Join Our YouTube Channel: Join Now
Also read other articles @ EduTaxTuber
If you want to make the lower case, The Excel LOWER function Converts all uppercase letters in a text string to lowercase. It ignores space, numbers, and punctuation. Visit this link – Excel LOWER Function.
The Excel PROPER function Capitalizes the first letter in a text string and any other letters in the text that follow any character other than a letter. It Converts all other letters to lowercase letters. Visit this link – Excel PROPER Function
How To Check PM- Kisan Samman Nidhi Yojna Beneficiary Status
In this article we will see in detail how to check “PM- Kisan Samman Nidhi Yojna” beneficiary status i.e. whether money is received or not. You can check it Online. You can check in three ways i.e using 1. Aadhar Number, 2. Bank Account Number, and 3. Mobile Number.…. Read More