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
How to do addition in Excel See the image, showing the addition of 10, 20 and 30. 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 second cell C4, again…
Read more
How to insert symbols and special characters in Excel Select the cell where you need the symbol. Then click on the Insert tab and select Symbol command, on the right end of the ribbon. It will display a number of symbols, choose the desired symbol and click on Insert option then close the box. Symbol…
Read more
How to use spell check in Excel Select the data then click on the review tab it will display spelling command in the left corner of the ribbon. Left click on it or press F7. If there is any spelling mistake in the data, the spell check will suggest corrections in the spelling dialogue box.…
Read more
How to copy paste data in Excel Select the data, right click on it then select Copy option. Now select the cell where you want to paste the data then right click on it and select Paste option. After selecting the data, you can also press Control+C to copy and Control+V to paste the data.…
Read more