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


2   2   =A1*B1

produces correct result, but when copied to a new row the formula make static reference to Row1.

I tried this and it works

2   2   =PRODUCT(LEFT)

BUT must be able to explicitly select which column in the formula.

Can anyone tell me a specific keyword or have some other formula to use a cell reference on the same row as the formula?

share|improve this question

migrated from Feb 15 '11 at 16:07

This question came from our site for professional and enthusiast programmers.

Word tables have very limited formula handling capabilities and must be recalculated by hand. I think you would be better off creating a spreadsheet in Excel (if you have it) and then either copy & paste the rows and columns of data from one program to the other OR save the spreadsheet as an Excel file and then insert that into your Word document.

share|improve this answer

I agree with @martineau, Excel is the way. You can insert an Excel sheet into a Word doc without creating a separate excel file:

In 2003 - From Insert/Object Create New... Microsoft Excel Worksheet

In 2007 - Insert - Table - Excel Spreadsheet

share|improve this answer

You must log in to answer this question.