Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
drumz drumz is offline
external usenet poster
 
Posts: 4
Default How to add functionality to a a colum of cells in a table Word 200

I was using a template for ayear or more that after adding numbers to a cells
in a row a cell would show the total of those cells. Now that I have Office
2007 when I try to open this file I had saved as a template in Word 2003 I
get the prompt that OfficeReady 3.0 needs to be installed. OfficeReady 3.0 is
for Word 2K (tried installing but doesn't work) so I need to figure out how
to add that functionality to this doc and save it as a template.

Thanks in advance!
  #2   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default How to add functionality to a a colum of cells in a table Word 200

You certainly don't need this add-in just to total a column of figures in a
table. You just need a SUM formula field; you can use SUM(ABOVE) if there
are no empty cells, and this is the default formula if you click the Formula
button in a cell at the bottom of a column of figures. The Formula button is
at the far right end of the Ribbon when you are displaying the Table Tools |
Layout tab.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"drumz" wrote in message
...
I was using a template for ayear or more that after adding numbers to a
cells
in a row a cell would show the total of those cells. Now that I have
Office
2007 when I try to open this file I had saved as a template in Word 2003 I
get the prompt that OfficeReady 3.0 needs to be installed. OfficeReady 3.0
is
for Word 2K (tried installing but doesn't work) so I need to figure out
how
to add that functionality to this doc and save it as a template.

Thanks in advance!




  #3   Report Post  
Posted to microsoft.public.word.tables
drumz drumz is offline
external usenet poster
 
Posts: 4
Default How to add functionality to a a colum of cells in a table Word

Thanks for your reply. I figured out that by adding a formula in the sum cell
=sum(d1:d5) and it works. I put formatting for the cells where I enter a
numeral but was wondering if I needed a formula in those cells too.
Because right now, I have to hit the formula button for the sum cell to
update. Where I was hoping that after moving off an entry cell that the sum
cell would automatically populate.

Thanks for your help!

"Suzanne S. Barnhill" wrote:

You certainly don't need this add-in just to total a column of figures in a
table. You just need a SUM formula field; you can use SUM(ABOVE) if there
are no empty cells, and this is the default formula if you click the Formula
button in a cell at the bottom of a column of figures. The Formula button is
at the far right end of the Ribbon when you are displaying the Table Tools |
Layout tab.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"drumz" wrote in message
...
I was using a template for ayear or more that after adding numbers to a
cells
in a row a cell would show the total of those cells. Now that I have
Office
2007 when I try to open this file I had saved as a template in Word 2003 I
get the prompt that OfficeReady 3.0 needs to be installed. OfficeReady 3.0
is
for Word 2K (tried installing but doesn't work) so I need to figure out
how
to add that functionality to this doc and save it as a template.

Thanks in advance!





  #4   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default How to add functionality to a a colum of cells in a table Word

If you are calculating form fields and check the box for "Calculate on exit"
in each form field, then the total will update automatically. If these are
just ordinary table cells, then you need to click the total and press F9 to
update it.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"drumz" wrote in message
...
Thanks for your reply. I figured out that by adding a formula in the sum
cell
=sum(d1:d5) and it works. I put formatting for the cells where I enter a
numeral but was wondering if I needed a formula in those cells too.
Because right now, I have to hit the formula button for the sum cell to
update. Where I was hoping that after moving off an entry cell that the
sum
cell would automatically populate.

Thanks for your help!

"Suzanne S. Barnhill" wrote:

You certainly don't need this add-in just to total a column of figures in
a
table. You just need a SUM formula field; you can use SUM(ABOVE) if there
are no empty cells, and this is the default formula if you click the
Formula
button in a cell at the bottom of a column of figures. The Formula button
is
at the far right end of the Ribbon when you are displaying the Table
Tools |
Layout tab.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"drumz" wrote in message
...
I was using a template for ayear or more that after adding numbers to a
cells
in a row a cell would show the total of those cells. Now that I have
Office
2007 when I try to open this file I had saved as a template in Word
2003 I
get the prompt that OfficeReady 3.0 needs to be installed. OfficeReady
3.0
is
for Word 2K (tried installing but doesn't work) so I need to figure out
how
to add that functionality to this doc and save it as a template.

Thanks in advance!








Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging Excel data into Word doc from 2 sections of the same colum Darren Ingram Mailmerge 3 November 21st 08 07:43 AM
Justify lines after changing from PDF 2 columns to word one colum need more shortcuts Microsoft Word Help 1 May 6th 08 04:29 AM
Resize Word table cells without moving/resizing the other cells? hoozieg Tables 2 October 4th 07 11:15 PM
want cells in a table to copy data from cells in another table Conrad D. Farner Tables 2 September 27th 06 04:21 PM
Cells in Word Table Libby Tables 1 January 20th 06 06:50 AM


All times are GMT +1. The time now is 02:36 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"