What is the Microsoft Excel Fill Handle?

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?

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 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

Where Can I Learn More About the Excel Fill Handle?

You can learn more about @ EduTaxTuber 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

Create TDS Nature of Payment

From the gateway of Tally press “C” then select “TDS Nature of Payments” under the Statutory Masters and press Enter. OR Press “ALT + G” select Create Master press Enter and select “TDS Nature of Payment” under the Statutory Masters and hit the enter button.

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