Here in this tutorial we will discuss about the auto sum and delete cell option in the excel.
To auto sum the amount, Press Alt+= key on the key board. This will automatically add the sum to the selected cell. In the attached file, at the add of the marks received, press Alt+= key, it will gave you the sum total amounting 821.
You can also use the auto sum option given in the top menu bar.
Now coming back to delete the blank cell.To delete the blank cell, select the column where you want to delete the cell. Once you select the column, press Ctrl+G, it will open the below diagolue box
Now,click on the special option or press Alt+S key on the keyboard. Now, it will open the below dialogue box
Select the Blank Options and click OK. This will select the blank cell. Now simply press the delete or Ctrl+- key on the key broad to delete the selected blank cell.
Please refer the attached file for practicing this excel formula.
[smg id=130 type=av]