Techshristi's Forum

Author Topic: Delete Blank Cell and Auto Sum in Excel  (Read 997 times)

0 Members and 1 Guest are viewing this topic.

Offline TechShristi

  • Welclome to Techshristi
  • Administrator
  • *****
  • Posts: 556
    • techshristi
Delete Blank Cell and Auto Sum in Excel
« on: December 22, 2016, 11:38:12 PM »
Hello Friends


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]

Techshristi's Forum

Delete Blank Cell and Auto Sum in Excel
« on: December 22, 2016, 11:38:12 PM »

 
Sitemap 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18