| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Where is the "AutoSum" command in Mircosoft Office Work 2007
|
|
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Where is the "AutoSum" command in Mircosoft Office Work 2007
After you have created a table, you will have two contextual table tabs:
Design and Layout. On the Layout tab, in the Data group, there is a Formula button that opens the Formula dialog, where you can select the Sum function. If you want it to be Sum(Above) or Sum(Left), as created by the AutoSum button, you'll have to type this in yourself. Not quite the answer you wanted, is it? So click on the arrow at the end of the QAT, choose More Commands..., select Commands Not in the Ribbon, scroll down to Sum, and click Add . -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "Rickh957" wrote in message ... |
|
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Where is the "AutoSum" command in Mircosoft Office Work 2007
Suzanne S. Barnhill wrote:
If you want it to be Sum(Above) or Sum(Left), as created by the AutoSum button, you'll have to type this in yourself. Word will offer Sum(Above) or Sum(Left) as the default choice for the autosum button if there is an unambiguous choice of numbers to the left or above. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
|
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Where is the "AutoSum" command in Mircosoft Office Work 2007
You didn't read the whole reply, did you? Yes, the AutoSum button will do
this. My point was that the Formula dialog doesn't: it doesn't replicate the behavior of the AutoSum button and consequently is a very inefficient substitute. My reply explained how to insert a Sum(Above) or Sum(Left) field in Word 2007 (where the AutoSum button is not, by default, available); it then explained how to add the AutoSum button to the QAT. For the benefit of others who may be coming in late, here's the whole message: "After you have created a table, you will have two contextual table tabs: Design and Layout. On the Layout tab, in the Data group, there is a Formula button that opens the Formula dialog, where you can select the Sum function. If you want it to be Sum(Above) or Sum(Left), as created by the AutoSum button, you'll have to type this in yourself. "Not quite the answer you wanted, is it? So click on the arrow at the end of the QAT, choose More Commands..., select Commands Not in the Ribbon, scroll down to Sum, and click Add ." I should probably have preface this by saying: "Word 2007 doesn't have an AutoSum button by default; the procedure that replaces it is quite tedious." -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "Graham Mayor" wrote in message ... Suzanne S. Barnhill wrote: If you want it to be Sum(Above) or Sum(Left), as created by the AutoSum button, you'll have to type this in yourself. Word will offer Sum(Above) or Sum(Left) as the default choice for the autosum button if there is an unambiguous choice of numbers to the left or above. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
|
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Where is the "AutoSum" command in Mircosoft Office Work 2007
I had read your reply. The point of my response was that the *formula*
button *does* offer Sum(Above) or Sum(Left) as the default entry, if there is content in the row or the column adjacent to where you wish to place the formula. What it doesn't do (which the autosum button does) is enter the formula directly iunto the table ie you need two clicks to the autosum button's one. In the whole scheme of things I didn't feel that two clicks instead of one amounted to 'quite tedious', but each to his own  You don't have to type in the formula dialog unless the table is empty. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Suzanne S. Barnhill wrote: You didn't read the whole reply, did you? Yes, the AutoSum button will do this. My point was that the Formula dialog doesn't: it doesn't replicate the behavior of the AutoSum button and consequently is a very inefficient substitute. My reply explained how to insert a Sum(Above) or Sum(Left) field in Word 2007 (where the AutoSum button is not, by default, available); it then explained how to add the AutoSum button to the QAT. For the benefit of others who may be coming in late, here's the whole message: "After you have created a table, you will have two contextual table tabs: Design and Layout. On the Layout tab, in the Data group, there is a Formula button that opens the Formula dialog, where you can select the Sum function. If you want it to be Sum(Above) or Sum(Left), as created by the AutoSum button, you'll have to type this in yourself. "Not quite the answer you wanted, is it? So click on the arrow at the end of the QAT, choose More Commands..., select Commands Not in the Ribbon, scroll down to Sum, and click Add ." I should probably have preface this by saying: "Word 2007 doesn't have an AutoSum button by default; the procedure that replaces it is quite tedious." "Graham Mayor" wrote in message ... Suzanne S. Barnhill wrote: If you want it to be Sum(Above) or Sum(Left), as created by the AutoSum button, you'll have to type this in yourself. Word will offer Sum(Above) or Sum(Left) as the default choice for the autosum button if there is an unambiguous choice of numbers to the left or above. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
|
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Where is the "AutoSum" command in Mircosoft Office Work 2007
Ah, okay, I confess I was trying it with an empty table, just to find where
the commands were. Having now tried it with numbers in the cells, I see that SUM(ABOVE) is offered as the default formula. My apologies. OTOH, it actually requires three clicks in some instances. If you have just inserted a table and typed in it, the Table Tools | Design tab is on top. You have to select the Layout tab before you can access the Formula button, then click to insert the formula. If you use AutoSum a lot, it might be worth a button on the QAT to save a couple of clicks. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "Graham Mayor" wrote in message ... I had read your reply. The point of my response was that the *formula* button *does* offer Sum(Above) or Sum(Left) as the default entry, if there is content in the row or the column adjacent to where you wish to place the formula. What it doesn't do (which the autosum button does) is enter the formula directly iunto the table ie you need two clicks to the autosum button's one. In the whole scheme of things I didn't feel that two clicks instead of one amounted to 'quite tedious', but each to his own You don't have to type in the formula dialog unless the table is empty. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Suzanne S. Barnhill wrote: You didn't read the whole reply, did you? Yes, the AutoSum button will do this. My point was that the Formula dialog doesn't: it doesn't replicate the behavior of the AutoSum button and consequently is a very inefficient substitute. My reply explained how to insert a Sum(Above) or Sum(Left) field in Word 2007 (where the AutoSum button is not, by default, available); it then explained how to add the AutoSum button to the QAT. For the benefit of others who may be coming in late, here's the whole message: "After you have created a table, you will have two contextual table tabs: Design and Layout. On the Layout tab, in the Data group, there is a Formula button that opens the Formula dialog, where you can select the Sum function. If you want it to be Sum(Above) or Sum(Left), as created by the AutoSum button, you'll have to type this in yourself. "Not quite the answer you wanted, is it? So click on the arrow at the end of the QAT, choose More Commands..., select Commands Not in the Ribbon, scroll down to Sum, and click Add ." I should probably have preface this by saying: "Word 2007 doesn't have an AutoSum button by default; the procedure that replaces it is quite tedious." "Graham Mayor" wrote in message ... Suzanne S. Barnhill wrote: If you want it to be Sum(Above) or Sum(Left), as created by the AutoSum button, you'll have to type this in yourself. Word will offer Sum(Above) or Sum(Left) as the default choice for the autosum button if there is an unambiguous choice of numbers to the left or above. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
|
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Where is the "AutoSum" command in Mircosoft Office Work 2007
I agree the QAT will save time if you use this a lot.
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Suzanne S. Barnhill wrote: Ah, okay, I confess I was trying it with an empty table, just to find where the commands were. Having now tried it with numbers in the cells, I see that SUM(ABOVE) is offered as the default formula. My apologies. OTOH, it actually requires three clicks in some instances. If you have just inserted a table and typed in it, the Table Tools | Design tab is on top. You have to select the Layout tab before you can access the Formula button, then click to insert the formula. If you use AutoSum a lot, it might be worth a button on the QAT to save a couple of clicks. "Graham Mayor" wrote in message ... I had read your reply. The point of my response was that the *formula* button *does* offer Sum(Above) or Sum(Left) as the default entry, if there is content in the row or the column adjacent to where you wish to place the formula. What it doesn't do (which the autosum button does) is enter the formula directly iunto the table ie you need two clicks to the autosum button's one. In the whole scheme of things I didn't feel that two clicks instead of one amounted to 'quite tedious', but each to his own You don't have to type in the formula dialog unless the table is empty. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Suzanne S. Barnhill wrote: You didn't read the whole reply, did you? Yes, the AutoSum button will do this. My point was that the Formula dialog doesn't: it doesn't replicate the behavior of the AutoSum button and consequently is a very inefficient substitute. My reply explained how to insert a Sum(Above) or Sum(Left) field in Word 2007 (where the AutoSum button is not, by default, available); it then explained how to add the AutoSum button to the QAT. For the benefit of others who may be coming in late, here's the whole message: "After you have created a table, you will have two contextual table tabs: Design and Layout. On the Layout tab, in the Data group, there is a Formula button that opens the Formula dialog, where you can select the Sum function. If you want it to be Sum(Above) or Sum(Left), as created by the AutoSum button, you'll have to type this in yourself. "Not quite the answer you wanted, is it? So click on the arrow at the end of the QAT, choose More Commands..., select Commands Not in the Ribbon, scroll down to Sum, and click Add ." I should probably have preface this by saying: "Word 2007 doesn't have an AutoSum button by default; the procedure that replaces it is quite tedious." "Graham Mayor" wrote in message ... Suzanne S. Barnhill wrote: If you want it to be Sum(Above) or Sum(Left), as created by the AutoSum button, you'll have to type this in yourself. Word will offer Sum(Above) or Sum(Left) as the default choice for the autosum button if there is an unambiguous choice of numbers to the left or above. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
|
#8
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Where is the "AutoSum" command in Mircosoft Office Work 2007
The problem is still not solved. If password protected and emailed to a
customer and the customer add numbers in fields, the sum functions are not operating at all! What then is the purpouse of creating all these functions or whatever for use in words! Does someone have ab abswer that will automaticly ipdate formula fields in protect mode if numbers are changed or added? Something simular to the book-keeping template/form on the online templates page. Problem is this form is protected. Cannot see formula! How do you remove the password? -- Wllem Nel "Graham Mayor" wrote: I agree the QAT will save time if you use this a lot. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Suzanne S. Barnhill wrote: Ah, okay, I confess I was trying it with an empty table, just to find where the commands were. Having now tried it with numbers in the cells, I see that SUM(ABOVE) is offered as the default formula. My apologies. OTOH, it actually requires three clicks in some instances. If you have just inserted a table and typed in it, the Table Tools | Design tab is on top. You have to select the Layout tab before you can access the Formula button, then click to insert the formula. If you use AutoSum a lot, it might be worth a button on the QAT to save a couple of clicks. "Graham Mayor" wrote in message ... I had read your reply. The point of my response was that the *formula* button *does* offer Sum(Above) or Sum(Left) as the default entry, if there is content in the row or the column adjacent to where you wish to place the formula. What it doesn't do (which the autosum button does) is enter the formula directly iunto the table ie you need two clicks to the autosum button's one. In the whole scheme of things I didn't feel that two clicks instead of one amounted to 'quite tedious', but each to his own You don't have to type in the formula dialog unless the table is empty. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Suzanne S. Barnhill wrote: You didn't read the whole reply, did you? Yes, the AutoSum button will do this. My point was that the Formula dialog doesn't: it doesn't replicate the behavior of the AutoSum button and consequently is a very inefficient substitute. My reply explained how to insert a Sum(Above) or Sum(Left) field in Word 2007 (where the AutoSum button is not, by default, available); it then explained how to add the AutoSum button to the QAT. For the benefit of others who may be coming in late, here's the whole message: "After you have created a table, you will have two contextual table tabs: Design and Layout. On the Layout tab, in the Data group, there is a Formula button that opens the Formula dialog, where you can select the Sum function. If you want it to be Sum(Above) or Sum(Left), as created by the AutoSum button, you'll have to type this in yourself. "Not quite the answer you wanted, is it? So click on the arrow at the end of the QAT, choose More Commands..., select Commands Not in the Ribbon, scroll down to Sum, and click Add ." I should probably have preface this by saying: "Word 2007 doesn't have an AutoSum button by default; the procedure that replaces it is quite tedious." "Graham Mayor" wrote in message ... Suzanne S. Barnhill wrote: If you want it to be Sum(Above) or Sum(Left), as created by the AutoSum button, you'll have to type this in yourself. Word will offer Sum(Above) or Sum(Left) as the default choice for the autosum button if there is an unambiguous choice of numbers to the left or above. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
|
#9
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Where is the "AutoSum" command in Mircosoft Office Work 2007
In order to update related fields when you change the content of a form
field, you must check the calculate on exit check boxes of the fields contributing to the calculation. The calculated fields then update when you tab out of the form fields, provided the calculated fields are in the text layer of the document, which in the case of a table, they will be. You can unlock the form from the developer tab. http://gregmaxey.mvps.org/Classic%20Form%20Controls.htm will give you the familiar forms command set. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Willem Nel wrote: The problem is still not solved. If password protected and emailed to a customer and the customer add numbers in fields, the sum functions are not operating at all! What then is the purpouse of creating all these functions or whatever for use in words! Does someone have ab abswer that will automaticly ipdate formula fields in protect mode if numbers are changed or added? Something simular to the book-keeping template/form on the online templates page. Problem is this form is protected. Cannot see formula! How do you remove the password? I agree the QAT will save time if you use this a lot. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Suzanne S. Barnhill wrote: Ah, okay, I confess I was trying it with an empty table, just to find where the commands were. Having now tried it with numbers in the cells, I see that SUM(ABOVE) is offered as the default formula. My apologies. OTOH, it actually requires three clicks in some instances. If you have just inserted a table and typed in it, the Table Tools | Design tab is on top. You have to select the Layout tab before you can access the Formula button, then click to insert the formula. If you use AutoSum a lot, it might be worth a button on the QAT to save a couple of clicks. "Graham Mayor" wrote in message ... I had read your reply. The point of my response was that the *formula* button *does* offer Sum(Above) or Sum(Left) as the default entry, if there is content in the row or the column adjacent to where you wish to place the formula. What it doesn't do (which the autosum button does) is enter the formula directly iunto the table ie you need two clicks to the autosum button's one. In the whole scheme of things I didn't feel that two clicks instead of one amounted to 'quite tedious', but each to his own You don't have to type in the formula dialog unless the table is empty. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Suzanne S. Barnhill wrote: You didn't read the whole reply, did you? Yes, the AutoSum button will do this. My point was that the Formula dialog doesn't: it doesn't replicate the behavior of the AutoSum button and consequently is a very inefficient substitute. My reply explained how to insert a Sum(Above) or Sum(Left) field in Word 2007 (where the AutoSum button is not, by default, available); it then explained how to add the AutoSum button to the QAT. For the benefit of others who may be coming in late, here's the whole message: "After you have created a table, you will have two contextual table tabs: Design and Layout. On the Layout tab, in the Data group, there is a Formula button that opens the Formula dialog, where you can select the Sum function. If you want it to be Sum(Above) or Sum(Left), as created by the AutoSum button, you'll have to type this in yourself. "Not quite the answer you wanted, is it? So click on the arrow at the end of the QAT, choose More Commands..., select Commands Not in the Ribbon, scroll down to Sum, and click Add ." I should probably have preface this by saying: "Word 2007 doesn't have an AutoSum button by default; the procedure that replaces it is quite tedious." "Graham Mayor" wrote in message ... Suzanne S. Barnhill wrote: If you want it to be Sum(Above) or Sum(Left), as created by the AutoSum button, you'll have to type this in yourself. Word will offer Sum(Above) or Sum(Left) as the default choice for the autosum button if there is an unambiguous choice of numbers to the left or above. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
|
#10
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Where is the "AutoSum" command in Mircosoft Office Work 2007
I have a question... I am looking for a way to use a 'shortcut' for the autosum button rather than using my mouse. Example~ Ctrl + I = Italic Is there one I can use for Autosum? |
|
#11
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Where is the "AutoSum" command in Mircosoft Office Work 2007
I have this on my QAT, where it's labeled "Sum," which is the name under
which I found it in the All Commands section of Customize. In the Customize Keyboard dialog, however, you will have to look (under All Commands) for TableAutoSum. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Jenn" wrote in message ... I have a question... I am looking for a way to use a 'shortcut' for the autosum button rather than using my mouse. Example~ Ctrl + I = Italic Is there one I can use for Autosum? |
|
#12
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Where is the "AutoSum" command in Mircosoft Office Work 2007
you also have to use default number=0, because if there are blank cells in
the range, autosum won't recognize the whole column above (or row to left) as cells to be included in the calculation "Graham Mayor" wrote: In order to update related fields when you change the content of a form field, you must check the calculate on exit check boxes of the fields contributing to the calculation. The calculated fields then update when you tab out of the form fields, provided the calculated fields are in the text layer of the document, which in the case of a table, they will be. You can unlock the form from the developer tab. http://gregmaxey.mvps.org/Classic%20Form%20Controls.htm will give you the familiar forms command set. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Willem Nel wrote: The problem is still not solved. If password protected and emailed to a customer and the customer add numbers in fields, the sum functions are not operating at all! What then is the purpouse of creating all these functions or whatever for use in words! Does someone have ab abswer that will automaticly ipdate formula fields in protect mode if numbers are changed or added? Something simular to the book-keeping template/form on the online templates page. Problem is this form is protected. Cannot see formula! How do you remove the password? I agree the QAT will save time if you use this a lot. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Suzanne S. Barnhill wrote: Ah, okay, I confess I was trying it with an empty table, just to find where the commands were. Having now tried it with numbers in the cells, I see that SUM(ABOVE) is offered as the default formula. My apologies. OTOH, it actually requires three clicks in some instances. If you have just inserted a table and typed in it, the Table Tools | Design tab is on top. You have to select the Layout tab before you can access the Formula button, then click to insert the formula. If you use AutoSum a lot, it might be worth a button on the QAT to save a couple of clicks. "Graham Mayor" wrote in message ... I had read your reply. The point of my response was that the *formula* button *does* offer Sum(Above) or Sum(Left) as the default entry, if there is content in the row or the column adjacent to where you wish to place the formula. What it doesn't do (which the autosum button does) is enter the formula directly iunto the table ie you need two clicks to the autosum button's one. In the whole scheme of things I didn't feel that two clicks instead of one amounted to 'quite tedious', but each to his own You don't have to type in the formula dialog unless the table is empty. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Suzanne S. Barnhill wrote: You didn't read the whole reply, did you? Yes, the AutoSum button will do this. My point was that the Formula dialog doesn't: it doesn't replicate the behavior of the AutoSum button and consequently is a very inefficient substitute. My reply explained how to insert a Sum(Above) or Sum(Left) field in Word 2007 (where the AutoSum button is not, by default, available); it then explained how to add the AutoSum button to the QAT. For the benefit of others who may be coming in late, here's the whole message: "After you have created a table, you will have two contextual table tabs: Design and Layout. On the Layout tab, in the Data group, there is a Formula button that opens the Formula dialog, where you can select the Sum function. If you want it to be Sum(Above) or Sum(Left), as created by the AutoSum button, you'll have to type this in yourself. "Not quite the answer you wanted, is it? So click on the arrow at the end of the QAT, choose More Commands..., select Commands Not in the Ribbon, scroll down to Sum, and click Add ." I should probably have preface this by saying: "Word 2007 doesn't have an AutoSum button by default; the procedure that replaces it is quite tedious." "Graham Mayor" wrote in message ... Suzanne S. Barnhill wrote: If you want it to be Sum(Above) or Sum(Left), as created by the AutoSum button, you'll have to type this in yourself. Word will offer Sum(Above) or Sum(Left) as the default choice for the autosum button if there is an unambiguous choice of numbers to the left or above. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "automatic" AutoSum - can I insert a button? | Tables | |||
| How do I get the command "Convert" on the the office button menu? | New Users | |||
| office 2007 "send to email" does not work with outlook express | Microsoft Word Help | |||
| How do I get the "work folder" command into the toolbar? | Microsoft Word Help | |||
| How do I turn off the "final showing mark up" in Mircosoft Word? | New Users | |||
Linear Mode
