Instead of typing out each individual cell reference, you can use =SUM(A1:A3) to quickly add the numbers in cells A1 through ...

Drop-down lists are one way to simplify data input within Excel, which is helpful where time is money. How to easily add drop ...