Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I did some calculations with a "data table" in Excel, but to me it looks like the same calculations could be done just copying the formula across rows and columns with a mix of absolute (using $) and relative references.

Are there any unique features of data tables, that can not be reproduced by other means?

share|improve this question
up vote 2 down vote accepted

Simple answer: No, you can reproduce exactly the same results using formulas.

They are there for your convenience, to save you the time of having to set-up everything yourself.

You can use data tables to see how different input values affect the results of a formula. By doing so, you can test different input values for a formula without having to retype or copy the formula for each value.

-An overview of data tables in Excel 2003 and in Excel 2007

share|improve this answer
Ok, looks to me to be indeed very useful when there are not only different input values, but where the formula is changed as well – grojo May 10 '11 at 7:04

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .