[mso] Re: Hmm..another MS Word number-calculating question

Hi Dan

All I can say is that as everybody else agrees, Excel is the way forward
for you.  Play with it, it's so robust that the worst thing you usually
have to do is click "undo"!  Modifying the table is always easy - drag
columns and rows to the size you want, format them for currency, numbers,
dates or whatever, Excel does it all so unbelievably easy.  Try not to
think of it as blank graph paper but more a scribble pad and just play.

As for your request for a quick way of doing what you want, try a couple
of things.

First try copying and pasting your Word table BACK into Excel then play
with the formatting.

Second - and you can do this either with your pasted Word table in Excel
or with a brand new Excel table - the cheat's way is probably to make sure
you have some blank rows below the end of your data before you have your
row that totals the data.  Excel usually gives you the option to "format
as row above" or "format as row below" - select "row above" and all your
formulae will be left untouched.

As these rows get filled up keep slotting in extra rows!

Just don't tell the Excel experts I said this, they will probably cringe!
LOL!!!  In time, look at protecting your formulae but for now spend an
hour or two tinkering and you will find you make huge progress.  I can
*almost* promise that.

Anne

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Dian D. Chapman
Sent: 16 November 2005 03:29
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Hmm..another MS Word number-calculating question



This IS a job for Excel! ;-)


Dian D. Chapman
Technical Consultant, Microsoft MVP
MOS Certified, Editor/TechTrax

Free MS Tutorials: http://www.mousetrax.com/techtrax
Free Word eBook: http://www.mousetrax.com/books.html
Optimize your business docs: http://www.mousetrax.com/consulting
Learn VBA the easy way: http://www.mousetrax.com/techcourses.html


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: