A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to add functionality to a a colum of cells in a table Word 200



 
 
Thread Tools Display Modes
  #1  
Old December 12th, 2008, 07:01 AM posted to microsoft.public.word.tables
drumz
external usenet poster
 
Posts: 51
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  
Old December 12th, 2008, 03:35 PM posted to microsoft.public.word.tables
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
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  
Old December 12th, 2008, 07:39 PM posted to microsoft.public.word.tables
drumz
external usenet poster
 
Posts: 51
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  
Old December 12th, 2008, 11:43 PM posted to microsoft.public.word.tables
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
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!








 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:44 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.