Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.