In this quick video tip from Infinite Skills trainer Guy Vaccaro, you’ll learn how to quickly select entire rows or columns for inclusion in a formula.
While ordinarily you might choose your known range of values with a colon (such as A2:A12), it’s not always convenient or correct. Columns or rows can become enormous, and many times you’d like to create formulas that will allow for the addition of new entries. Guy shows both how to make a full row and column selection and how to select a range of multiple rows and columns, in just a few keystrokes or clicks.
This featured MS Excel tutorial is from our Advanced Excel Formulas and Functions video course, which you can purchase on its own or in a comprehensive bundle.
How to Reference Full Rows and Columns and Ranges in a Formula