75 Essential Excel tips - CBS Interactive

You don't need to use cell names to build formulas. You can take advantage of Excel's support for natural language formulas to use label names instead. For example, suppose you had three columns of data labeled Region, Sales, and Percent of Sales. Below that, you have four rows, one row for each region, labeled East, West, North, and South. ................
................