skip to main
|
skip to sidebar
Excel Tips
Just another excel tips blog. Enjoy and hope you get something from my blog!
Home
About
Contact
Log In
Popular Posts
Excel through the years
Minimum Value Excluding Zero ("MinIf" function)
Copy as Picture in Excel
Highlight All Cells Referenced by a Formula
Add Bullets in Excel
How to increase or decrease values in excel without using formulas
Hiding the Excel 2007 Ribbon Shortcut
5 Useful excel formulas for manipulating text
Automatically Insert Current Time and Date in a Worksheet
Autosum shortcut
Blog Archive
▼
2011
(15)
▼
May
(12)
How to increase or decrease values in excel withou...
Excel through the years
Autosum shortcut
5 Useful excel formulas for manipulating text
Add a Drop-Down List in Excel 2007,2010
Automatically Insert Current Time and Date in a Wo...
How to use Excel VLOOKUP
Quick Auto Sum in Excel
Quick Navigation in Excel (Control Key)
Highlight All Cells Referenced by a Formula
Add Bullets in Excel
Display all formulas in a sheet with a single key ...
►
January
(3)
►
2010
(4)
►
January
(4)
►
2009
(1)
►
January
(1)
►
2008
(4)
►
September
(4)
Powered by
Blogger
.
Friday, May 20, 2011
Quick Auto Sum in Excel
Want to use a keyboard shortcut to quickly sum up a column or row of data? Here's how:
Go to the end of the row or column (first cell with no values)
Press Alt-= (Alt and equal sign)
Auto sum is immediately inserted.
Done!
Quick. Effective. Simple.
Happy Computing!
Related Posts :
Formulas, Shortcuts
Tweet
0 comments:
Post a Comment
Newer Post
Older Post
Home
Search This Blog
Labels
Audit
(1)
Excel 2003
(2)
Excel 2007
(2)
Formatting
(1)
Formulas
(6)
Links
(2)
Navigation
(1)
Shortcuts
(12)
Template
(1)
Tips
(10)
Trivia
(1)
0 comments:
Post a Comment