Also visit: Autolust | Molly and Jake | 164mph

Boxxet Home   |   Log in or Register

Reference Cell Ranges by Label [Excel Tip] external link

Rate   Lifehacker | by Gina Trapani | Thu, Aug 23

Thumbnail

Thu, Aug 23 While you're writing formulas in Excel, you can refer to cell ranges not only by hard-to-read row and column numbers and letters but by label. So instead of totaling a column using =SUM(B2:B5), you can write the formula =SUM('Widgets Cranked'). After I mentioned this is a nice feature in Ap...

[Read original...]

Source:  Lifehacker
Search B5
Also of Interest...
Do you publish a blog? If so, consider joining the Boxxet Network and see your great content showcased and rewarded! Learn more...