My problem is with documenting Excel "tables".

Suppose for example that E2:F13 is a "table" describing the number of legs a number of 4-legged dogs have (just returned from visiting my son't recovering-from-an-operation dog :). So E2 and F2 are the title columns, with E2 saying "Number Of Dogs" and F2 saying "Number of Legs". Than E3:E13 contains the numbers 1 to 10, and F3 to F13 containing the formulas ="the value in the cell that's in my row one column to my left" * 4. For example, F4 contains "=E4 * 4", F5 contains "=E5 * 4" and so on.

This notation gets full support from Excel, of course, so that when you drag the box down it completes for F10 the the value "=E10 * 4"

However, I am not aware of any "Table semantics. I ** can** give cell names and say that the formula in cell "NumberOfLegsOfFourDogs" is ="the value in the cell named 4Dogs * 4", but I can't figure out how to say that "NumberOfLegsOfDogs[4]" = [4]*4 or something.

So, my question is: **Is there a better way use semantic and describe semantic table related information in Excel?**

`NumberOfLegsOfFourDogs`

and can reference them through pointer math as`NumberOfLegsOfFourDogs[4] = NumberOfDogs[4]*4`

. But as it is, it seems much more like a hypothetical question rather than a real problem needing to be solved. – Doktoro Reichard Aug 31 '13 at 18:54