Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Identifying cells
How do you identify unconnected cells in a Word Table to create an accurate
formula? I have a Table where not all cells are numerical, but broken up by cells with text in them. thanks, ronduke |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Identifying cells
In formulas cells are referenced by an alpa-numberic index. A1 is the first
column first row. Z26 is the 26th column and 26th row So if you wanted to add A1 to Z26 you would used {=(A1+Z26)} -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~ Greg Maxey - Word MVP My web site http://gregmaxey.mvps.org Word MVP web site http://word.mvps.org ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ronduke wrote: How do you identify unconnected cells in a Word Table to create an accurate formula? I have a Table where not all cells are numerical, but broken up by cells with text in them. thanks, ronduke |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Identifying cells
Greg,
Thanks for responding. However, that doesn't answer my question. There are no precise columns as the rows have differing numbers of cells, some text and some currency and other numbers. With no clear cut columns, how do I identify specific cells? "Greg Maxey" wrote: In formulas cells are referenced by an alpa-numberic index. A1 is the first column first row. Z26 is the 26th column and 26th row So if you wanted to add A1 to Z26 you would used {=(A1+Z26)} -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~ Greg Maxey - Word MVP My web site http://gregmaxey.mvps.org Word MVP web site http://word.mvps.org ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ronduke wrote: How do you identify unconnected cells in a Word Table to create an accurate formula? I have a Table where not all cells are numerical, but broken up by cells with text in them. thanks, ronduke |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Identifying cells
See http://gregmaxey.mvps.org/Table_Cell_Data.htm
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "ronduke" wrote in message ... Greg, Thanks for responding. However, that doesn't answer my question. There are no precise columns as the rows have differing numbers of cells, some text and some currency and other numbers. With no clear cut columns, how do I identify specific cells? "Greg Maxey" wrote: In formulas cells are referenced by an alpa-numberic index. A1 is the first column first row. Z26 is the 26th column and 26th row So if you wanted to add A1 to Z26 you would used {=(A1+Z26)} -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~ Greg Maxey - Word MVP My web site http://gregmaxey.mvps.org Word MVP web site http://word.mvps.org ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ronduke wrote: How do you identify unconnected cells in a Word Table to create an accurate formula? I have a Table where not all cells are numerical, but broken up by cells with text in them. thanks, ronduke |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identifying macros | Microsoft Word Help | |||
identifying a specific table in a macro? | Tables | |||
Identifying a wmf file | Page Layout | |||
Identifying reveal formatting marks | Microsoft Word Help | |||
Identifying reveal formatting marks | Microsoft Word Help |