sum of column in Word for Office X?

[Fritz]

use to be in 5.1a, you could mark a column of numbers, even if they
weren't all lined up, and get them to sum with a keystroke.
I can't figure out how to do that with Office X (not 2004).
Anyone have an idea?

 

[JE McGimpsey]

use to be in 5.1a, you could mark a column of numbers, even if they
weren't all lined up, and get them to sum with a keystroke.
I can't figure out how to do that with Office X (not 2004).
Anyone have an idea?

With Word v.X you can assign a keyboard shortcut to the TableAutoSum
command. Choose Tools/Customize..., click the Keyboard button. Select
All Commands in the left-hand listbox and scroll down and select
TableAutoSum in the right-hand listbox. Enter a keyboard shortcut, and
click Add.

The same function is provided by the AutoSum button control on the
Tables toolbar.

 

[Bill Weylock]

I've been going through the Paste Function routine. Thanks!

 

[phlicle]

With Word v.X you can assign a keyboard shortcut to the TableAutoSum
command. Choose Tools/Customize..., click the Keyboard button. Select
All Commands in the left-hand listbox and scroll down and select
TableAutoSum in the right-hand listbox. Enter a keyboard shortcut, and
click Add.

The same function is provided by the AutoSum button control on the
Tables toolbar.

that doesn't do it. Let me explain a bit more.
In 5.1a, I could "option" highlight the "column" of numbers on my
invoice.
That "column" wasn't in table format, per se. I just lined it up with
a decimal tab in the template.
After "option" highlighting the column, I'd hit •= and the sum would
appear in the lower left hand corner of the border. I could then
highlight the space I wanted it in and paste it in.

thanks for your help.

 

[Matt Centurión [MS]]

In MacWord 2004:
1. Choose "Tools | Customize | Customize Keyboard..."
2. Select "All Commands" category
3. Select "ToolsCalculate" from the command
4. Assign it a keyboard shortcut
5. Ok dialog
6. Presto! Use the assigned command as before.

You can also put a toolbar button that does the same by going to "Customize
Toolbars..." instead

Matt
MacWord Testing
Macintosh Business Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email directly to this e-mail address. It is for
newsgroup purposes only.

Find out everything about Microsoft Mac Newsgroups at:
[http://www.microsoft.com/mac/community/community.aspx?pid=newsgroups]
Check out product updates and news & info at:
[http://www.microsoft.com/mac]

 

[JE McGimpsey]

In MacWord 2004:
1. Choose "Tools | Customize | Customize Keyboard..."
2. Select "All Commands" category
3. Select "ToolsCalculate" from the command
4. Assign it a keyboard shortcut
5. Ok dialog
6. Presto! Use the assigned command as before.

You can also put a toolbar button that does the same by going to "Customize
Toolbars..." instead

Thanks, Matt, for following up - I didn't see the OP's reply.

I've got that control on my custom toolbar. The main thing I don't like
about it is the overhead - it toggles state depending on whether there
is a selection of one or more characters. Seems unnecessarily expensive
to me. Let it return 0 if there's nothing selected.

I also don't like the non-intuitive error that it generates:

!Unexpected End of Formula

if the selection includes only text (unless the selection contains a !,
in which case it returns "!Syntax Error, !"). It should, IMNSHO, ignore
*all* text and return 0.

 

[Bill Weylock]

I hesitate to offer any suggestions to someone who seems to know more than I
do about the program, but have you tried just inserting a sum-above function
in the bottom cell? There was a keyboard shortcut in 5.1 that I used all the
time (or maybe it was W6), but I can't remember it.

 

[JE McGimpsey]

I hesitate to offer any suggestions to someone who seems to know more than I
do about the program, but have you tried just inserting a sum-above function
in the bottom cell? There was a keyboard shortcut in 5.1 that I used all the
time (or maybe it was W6), but I can't remember it.

That will work with tables (I originally missed the OP's requirements
and suggested something similar). With values outside tables, the Tools
Calculate command is the way to go.

Please don't hesitate to add to the discussion. The worst that can
happen is that you'll be wrong. Happens to me all the time.

 

[Bill Weylock]

Thanks!

Now you have me curious about something else. What characteristics have to
be present for ToolsCalculate to work on them. Do they have to be in the
same tab column, in separate paragraphs as single items? Or can the be
scattered throughout the document and available for summing if selected with
Cmd-click?

In Word 5 (and 6 I think), I could select a column of figures aligned by the
same tab stop and total them. I think it was Opt-drag and then some keyboard
command I've long forgotten.

Thanks for the reassurance. I thought the worst that could happen was
ridicule and not having any of my questions answered.

Seriously, I do appreciate the kind word.

 

[JE McGimpsey]

Now you have me curious about something else. What characteristics have to
be present for ToolsCalculate to work on them. Do they have to be in the
same tab column, in separate paragraphs as single items? Or can the be
scattered throughout the document and available for summing if selected with
Cmd-click?

The values (or expressions), AFAICT, have to be within the same
selection - paragraph and tabs don't seem to matter. If there are
multiple selections, only the first seems to be evaluated.

In Word 5 (and 6 I think), I could select a column of figures aligned by the
same tab stop and total them. I think it was Opt-drag and then some keyboard
command I've long forgotten.

Same thing works in Word04. Opt-drag to select your columns, then choose
Tools Calculate (set a keyboard shortcut, or drag the command to a
toolbar).

 

[Bill Weylock]

Thanks.

I doubt I'll ever use it again, since tables are so much better to manage.
Nice to know it's there, however.


Best,


- Bill

 

[JE McGimpsey]

The advantage of the ToolsCalculate command is that it can cope with having
a blank cell or paragraph mark, whereas the Tools AutoSum can¹t

Another advantage is that ToolsCalculate handles formulas more complex
than just a sum (including subtraction, multiplication, division, and
powers).

 

[Clive Huggan]

Another advantage is that ToolsCalculate handles formulas more complex
than just a sum (including subtraction, multiplication, division, and
powers).

Thank you, JE -- a great advantage that I completely forgot about in my wish
to stagger off to my antipodean bed.

Clive

 

[Bill Weylock]

I've heard about them beds! Expensive?

Thank you, JE -- a great advantage that I completely forgot about in my wish
to stagger off to my antipodean bed.

Clive

 

[Clive Huggan]

Not in Australia! ;-)
CH

I've heard about them beds! Expensive?