O Excel, as it is known, brings several resources that can facilitate work, however the lack of knowledge of such resources can make the day to day of users become repetitive and even tedious.
One of these features is the fill handle, which, despite its simplicity of use, can be used on several occasions. In this way, we separate some tips and ways to use this feature to facilitate and avoid repetitive work. See below for more details:
The fill handle is basically a feature that aims to convey a logical sequence of data in a spreadsheet, facilitating the insertion of such data. For a better understanding, let's use a practical example:
A user, for some reason must create a sequential number list, so for a small list the work would be irrelevant, but if it is an extensive list, the work becomes difficult. Thus, by using the fill handle feature, simply insert an initial sequence, select it and drag it to complete it.
See the images below for a better understanding:
Use on days of the week
We can use the fill handle to enter days of the week. In the example below, we enter only the days "Monday" and "Tuesday". After selecting the days inserted, drag with the fill handle represented by the sign "+" in the lower right corner of the selected cells.
Use in months of the year
In the example below, we enter only the month of January in the first cell, and then we drag the selection to the other cells until the other months are completed.
Use in formulas
There is also the possibility of repeating formulas by means of the fill handle. See the example below:
In the above example, we need to calculate the average of a class. In this way, we only calculate the average of the first student by means of the AVERAGE formula based on his grades obtained. Then we drag the result of the function to the other students and this way the function will be repeated for each student.
Use in random sequences
When you want to repeat a sequence of data that does not have a logic, simply create the terms to be repeated, select the information and then follow the standard procedure with the fill tab as shown below:
Use in logical sequences
In addition to using traditional sequences, it is also possible to vary the various types of combinations. In the example below we perform a logical sequence with even numbers, and another sequence with days of the week counted every two days.
In some cases, it is necessary to use the cell lock feature so that the use of the fill handle does not return errors in the other copies. See below for a practical example for better understanding:
The image below shows the ratio of overtime of a company, calculating as base the value of R $ 9,50 for each overtime. In this way, each employee will receive a value relative to the hours worked.
Note that if we do the traditional calculation by multiplying the number of hours worked by the overtime value and then using the fill handle to complete the other employees in the list, we will have the following error:
This is because Excel interprets autocompletion, referring to the cells below the cell that we want to keep default. That is, for the employee 2, the value of hours worked with cell A3 and so on for the other fills will be multiplied.
To correct this error, simply insert the cell lock option with the $ symbol. Thus, after calculating the overtime of the first employee, enter a dollar sign to lock the time reference and the cell to be copied according to the example below:
Therefore, when using the fill handle, the overtime values of each employee will be calculated correctly.
As simple as the fill handle feature in Excel, there are numerous possibilities for day-to-day use. In this way, knowledge of this feature brings the facility to fill sequence data on many occasions.
This tip was helpful to you? Keep following our blog to learn even more about Excel!