Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Example

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 stackoverflow.com Feb 15 '11 at 16:07

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

2 Answers 2

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

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

Your Answer

 
discard

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