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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|