Excel Fill Handle in Formulas In the image given below, we want to multiply the numbers in column B with 5, so we can type the formula such as =B3*5 for cell B3 and other cells of the column B, but this is not possible with long lists. In such cases, we use Fill handle…
Read more
Excel Creating Formulas In cell C5 enter the number 20, now in cell E5 type the formula: =C5+5 then press the Enter key. You will get the result. The formula says 5 is added to the value entered in the cell C5 as the value is 20 the result is 25. See the image: In…
Read more
Excel Fill Handle with Dates Fill handle can be used to fill dates in multiple cells. If you need to enter a complete month in worksheet, you don’t need to type each date separately. Just choose a cell, type the date and using fill handle carry it over other cells, Excel will enter the subsequent…
Read more
Excel Fill Handle with Text and Numbers Fill handle also works with cells containing both text and number. In this case, the text does not change but the number increases by one for every cell you select. See the images:
Excel Fill Handle with Text Fill handle works in a similar way with texts. It helps repeat the text to desired range of cells. See the images shown below: The text is selected and then copied to other cells using fill handle.
Excel Fill Handle The fill handle is a convenient Excel tool that is used to fill data with a specific pattern. You can extend a series of numbers, dates and text combinations to desired number of cells. To use fill handle bring the mouse cursor at right bottom corner of the cell it will change…
Read more
Using Sigma Button to calculate average in Excel Select the cell to display the result. In the Home tab click on the small arrow next to the Sigma button and left click on the Average option. You will see the image shown below. Then press the Enter key to get the result.
How to calculate average in Excel Select the cell to display the result e.g. cell C9 in the image shown below. Now type “=” sign in the cell and type “average” then type opening parenthesis. Now select the data, cells from C4 to C7 then press the Enter key to get the result.
How to do subtraction in Excel It is similar to addition just replace the plus “+” sign with minus sign “-“. Choose the cell where you want the result to appear as cell C6 in this example. Then type = sign in the cell, now select first cell C3 then type “-” sign then select…
Read more
Using Sigma Button to do addition in Excel Select the cell to display the result then in Home tab click on the Sigma button, on the right end of the ribbon. You will see the image given below: Now select the list of data you want to add. You will see the image shown below,…
Read more