Sum many ranges with ALT=

I just found a very good tip at Chandoo's blog, how you can sum many ranges with multi-select.

Excel ranges

You have to select each sum-row with CTRL and press ALT + = (ALT & Shift & 0). Now every sum-row has it own =sum() formula.

Excel sum
Analysis Office - The Comprehensive Guide
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.3 and contains 227 Pages.
29,99 €
Analysis Office - The Comprehensive Guide 2nd edit
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.4 and contains 243 pages.
39,99 €

Write a comment

Comments: 0