| Instead of using the AutoSum button from the toolbar, | |||||||
| you can press Alt and = to achieve the same result. | |||||||
| Try it here : | |||||||
| Move to a blank cell in the Total row or column, then press Alt and =. | |||||||
| or | |||||||
| Select a row, column or all cells and then press Alt and =. | |||||||
| Jan | Feb | Mar | Total | ||||
| North | 10 | 50 | 90 | 150 | |||
| South | 20 | 60 | 100 | 180 | |||
| East | 30 | 70 | 200 | 330 | |||
| West | 40 | 80 | 300 | 420 | |||
| Total | 100 | 260 | 690 | 1050 | |||
Digital Marketing Consultant - Google Adwords, Bing Ads, Facebook Ads, Linkedin Ads, Also consultant with SEO, SMM & SMO Services
Monday, 2 June 2014
Auto Sum Formula in MS Excel
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment