[supabill]

It is there in Excel and Google Docs already :)

[btcoal]

Guh. Right you are: named ranges (http://www.contextures.com/xlnames01.html).

I learned about this feature years and years ago and never used it. Maybe it wouldn't actually be all that helpful afterall. If only I could downvote myself.