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
How to move data in Excel Select the data you want to move, right click on it then select the cut option then select the cell where you want to shift the data. Right click on the selected cell and select paste option. Data will be moved to the desired location.
How to delete data, rows and columns in Excel How to Delete Data Select the data you want to delete, right click on it then select delete option from the menu. You can also delete it by pressing Delete key on the keyboard. See the image: How to Delete a Row Select the row by…
Read more
How to select data in Excel There are various options to select data. The most common way is a left click on the cell then dragging the mouse over the data you want to select. Start from the upper-left cell of the data, as cell B3 in the image given below:
How to enter data in Excel Select a cell with a single click where you want to enter data; cell B3 is selected in the image given below. Then double click in the cell to enter data. You can enter text, numbers and formulas in the cell. After entering data, you can press Tab key…
Read more
Moving across the worksheet in Excel There are multiple options to move across the worksheet using mouse and keyboard. You can scroll the work sheet up or down by rolling mouse wheel or using vertical scroll bar. In a similar way, you can use horizontal scroll bar to move the work sheet horizontally towards left…
Read more
Worksheet, Rows, Columns and Cells in Excel Worksheet Worksheet is also called spreadsheet. It is made up of rows, columns and cells. Rows Rows run horizontally across the worksheet and ranges from 1 to 1048576. A row is identified by the number that is on left side of the row, from where the row originates.…
Read more