A Quick Way To Add In Excel


Q. I know I can add a column of numbers by writing a formula such as =sum(A1+A12 , or by clicking on AutoSum (  ). But is there a way to do this using a faster keyboard approach?

A. Yes, and the keyboard approach is much, much quicker. Just click on a cell at the bottom of any column you want to add (it can even be many cells below the last number), hold down the Alt key, type in = and then press Enter.

RESOURCES

Keeping you informed and prepared amid the coronavirus crisis

We’re gathering the latest news stories along with relevant columns, tips, podcasts, and videos on this page, along with curated items from our archives to help with uncertainty and disruption.

SPONSORED REPORT

Getting leases in line

ASC Topic 842 is a relatively simple standard that can mean profound changes for organizations with leases. This report examines what makes this standard challenging and describes new ways for CPAs to add value.