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 or something.
So, my question is: Is there a better way use semantic and describe semantic table related information in Excel?