Sunday 20 January 2013

AutoSum Shortcut Key

Auto Sum Short Key

Instead of using the AutoSum button from the toolbar,
you can press Alt and = to achieve the same result.


Jan Feb Mar Total
North 10 50 90 150
South 20 60 100 180
East 30 70 200 300
West 40 80 300 420
Total 100 260 690 1050



Formula  Alt+=

 Syntax   =SUM(D12:D15)

No comments:

Post a Comment