Microsoft Excel Fill Handle With Text and Numbers

1 minute, 58 seconds Read

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.

Excel Fill handle with text and numbers- Edutaxtuber

For example, you want to start with the ‘The Year 2019’ and drag it with the help of Fill Handle.

Excel Fill Handle - Edutaxtuber

Excel Fill Handle – Months

Advertisements

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 Month series- Edutaxtuber

Excel Fill Handle – Week

Start with the day you want and drag with the help of Excel Fill Handle – both horizontally and vertically.

Excel Fill Handle Week series- Edutaxtuber


FAQs

Does Excel Fill Handle work with the Text and Numbers?


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

How To Create Multiple Ledgers in Tally Prime?
In this article, we will discuss that how we can create multiple ledgers in Tally Prime. If we create multiple ledgers then we can save our time on the other hand If we create a single ledger then it will …
TallyPrime: Important Shortcut Key ALT + G or GO To
In this article, we will discuss the new and unique shortcut key ALT + G or GO To in the TallyPrime. With the help of the ALT + G shortcut key, you can navigate in tally anywhere. ALT + G …

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

author

EduTaxTuber Team

We are here to help for every updates related to everything...👍📙👍📗

Similar Posts

Leave a Reply

Realme 10 Pro and 10 Pro+ Launched RBI Monetary Policy Highlights England vs Senegal: FIFA World Cup 2022 No Curfew in Mumbai: Section 144 Imposed to ensure Peace Elon Musk suspends Kanye West Twitter Account for inciting violence