Using entire row and entire column references

- If you're writing formulas in Excel that refer to data…in a row or column, sometimes it's going to be…more efficient to actually refer to the data…by its row number or column letter.…In this particular worksheet called RowReferences,…we're about to put in a total in cell B16 for the…Boston and New York entries up above,…those are the Eastern cities.…So all we need to do is put in a sum.…Now anytime you're using Sum, it's worth a least…stopping to consider, use the AutoSum button found…on the Formulas tab, also found in the Formatting toolbar,…or possibly its keystroke equivalent Command Shift T,…saves us a little bit of time in terms of typing.…

Now we don't want to be adding up the data here, but we do…want to be adding up the data from rows two and three.…Now there's nothing in rows two and three other than…what we're seeing on the screen.…There's no data to the right of column M in either case.…So if we simply drag across rows two and three, like this,…the indicator here says 2:3, and this means add up the data…