Скачать или смотреть How to use the fill handle in MS Excel - the easiest way ever!

Learn: The Quick & easy way How to use the fill handle in ms Excel

In this video, you will learn:
1. How to use the fill handle in ms Excel
2. Excel Fill handle

In my last video tutorial, I talked about How to Insert Radio Button In Excel
In today's video tutorial, I am going to show you How to use the fill handle in ms Excel

Fill Handle in excel is used to fill up the data by creating a series of values that either follows a pattern or check if the values we entered are of series. It is very easy to implement. Fill Handle is available at the right bottom of any cell. Just enter some values such as numbers or alphabets, or dates in at least 3 cells to have a pattern. Select the cells with values and then either drag the Fill Handle or double click will also work here.
In the active cell of the worksheet, the fill handle is a small black box at the bottom right corner.

A basic level of knowledge about fill handle in excel could save you tons of productive time at your workplace.
It is a tool, which can be used to autocomplete a series of lists in excel. Generally, in excel, we enter serial numbers. Let us say serial numbers from 1 to 10 from cells A1:A12. We usually type 1, 2, 3, 4… Like that, isn't it?

Instead of manual typing, we can use an excel fill handle to auto-fill the series of numbers, dates, days, etc.…
Let's delve into How to Enable the fill handle if you cannot find the fill handle in Excel
If you do not find a fill handle in excel, you need to do some settings here. We can enable the fill handle option, although it is enabled by default, it may happen that you disable it by mistake.

Step 1: Go to File.
Step 2: Go to Options.
Step 3: Select Advanced.
Step 4: Make sure that you have enabled the fill handle and cell drag-and-drop option checked.


How to Use Fill Handle in Excel

Fill handle in excel is very simple and easy to use. Let us understand the working of Excel Fill handle by some examples.

Assume you want to fill the numbers from 1 to 15 from cell A1 to A15. Here are the steps to auto-fill your series of numbers.
Step 1: Enter numbers 1 and 2 from A1:A2 and select those two cells.
Step 2: Hover the mouse over the bottom-right edge of the selection; you will see a plus icon appear – and drag until you find cell A15.

In the above case, you need to drag until you find your desired cell.
However, if there is a value in the adjacent column, you can hover the mouse over the right edge of the selection and double-click. It will automatically fill the list to the last cell based on the data in the adjacent column.

Now, let's look at the second table here where I have SERIAL numbers and MONTHS as my table head. Let me fill the cell F2 to cell F13 with Months. i.e Jan, Feb, etc. Now I need to insert serial numbers from Cell E2 to E13.
I just need to type 1 and 2, select the two numbers, and double-click. It will fill until cell E13.

Also,

Autofill Numbers that Decrement by 1
Just like I have done in the previous example, we can auto-fill numbers incremented by one. Similarly, we can insert numbers decremented by 1.
Step 1: Type 10 and 9 in the cells J1:J2.
Step 2: Since we do not have a value in the adjacent column, we cannot double-click on the fill handle. Instead, drag until cell J10 is filled
Step 3: Now, it will insert the numbers for you.
However, we can also use the fill handle in Excel to autocomplete weekday names, Autofill Dates, Autofill Weekdays Dates, and many more.

……………………………………………………………………………………………………………………….
Share this video:    • How to use the fill handle in MS Excel - t...  

For more simple and easy to follow How to videos,

Click the Link Below to subscribe:
   / @learnexcelwitht  

Join this channel to get access to the perks:

   / @learnexcelwitht  

#excelfillhandle #copyformula # #flashfill

LearnexcelwithT