In this post, we will explore about the Excel Fill Handle With Text and Numbers.
Excel Fill Handle With Text and Numbers
Excel Fill Handle works with both text and numbers. For example, we want to add ‘Product 1’ in a cell and drag with the fill handle the text will remain the same but the number will be incremented by 1. It will work both ways horizontally and vertically.
For example, you want to start with the ‘The Year 2019’ and drag it with the help of Fill Handle.
Excel Fill Handle – Months
To fill the month series in excel using the Excel Fill Handle type the starting month and then drag it to fill the month series. Both horizontally and vertically.
Excel Fill Handle – Week
Start with the day you want and drag with the help of Excel Fill Handle – both horizontally and vertically.
FAQs
Yes, you can Try it like ‘The Year 2019’ and drag it with the help of the 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