Image: AndreyPopov, Getty Images/iStockphoto. The data you want to use in an Excel drop down list usually won’t be in the same sheet as the drop down. The good news is that identifying a list on ...

How to use AutoSum in Excel. AutoSum works best when you have a column or row of numbers you want to add up. 1. Click the empty cell underneath the column of numbers that you want to add up.