Home |
Search |
Today's Posts |
#6
Posted to microsoft.public.word.tables
|
|||
|
|||
Cell referencing in table formulas - just ONE adjacent cell
Hi Ngan,
There are workarounds that allow the use of relative referencing for formulae copied down Word table columns. See 'Relative Referencing In Tables' in my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 Cheers "Ngan" wrote in message ... Hi Greg, Thanks for your response. Sorry I failed to mention that I tried this method and even though it works, I can't copy this formula down the column since the cell references are absolute. That means I have to manually modify each cell to SUM(a1, 1), SUM(a2, 1), SUM(a3, 1) etc... and it's a pain when you have a lot of cells to fill ... I guess my question is more hypothetical than practical - if you can't have relative cell referencing in Word, are there not any keywords to reference adjacent cells besides ABOVE, BELOW, LEFT, and RIGHT? Thanks much again! -ngan "Greg Maxey" wrote: All tables cells have a reference. A1 is the first cell in the top left corner. B1 is to its right and A2 is below it. Just enter the cell reference of the cell above your cell holding the formula. For example, if you have a 5 by 5 table and want the formula in cell C3 then enter {=Sum(C2,1)} |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Table cell does not break across columns [multi-col page] | Tables | |||
Table cell does not break across columns [multi-col page] | Page Layout | |||
How to wrap text from cell to cell in a table. | Tables | |||
Placing 1st table into a cell within 2nd table | Tables | |||
word table cell resize or word table cell size change or word table change cell size | Tables |