Pages

Search

Microsoft Word - Insert Sum Formula into all Tables

Microsoft Word - Insert Sum Formula into all Tables


Insert Sum Formula into all Tables

Posted: 07 Feb 2013 08:26 AM PST

Hello, I am trying to insert a sum formula into the first cell of each table. However, when I run the macro,the values are not summed. See my code below

 

Sub InsertSumFormula()
    Dim T As Table
    'if any tables exist, loop through each table in collection
    For Each T In ActiveDocument.Tables
        T.Cell(1, 1).Select
        Selection.InsertFormula Formula:="sum(right)"
       
    Next T
End Sub

 

Thoughts?

Thanks!

MERGE SECTION

Posted: 07 Feb 2013 04:17 AM PST

I have many section in my word file for using mail merge. i cant use page number in my document for that i want to have only one section. how can i would be appreciate help me how can i  merge my sections to one section for using page number in file.

How do I get the "cell outlines" to show in Word 2013?

Posted: 06 Feb 2013 10:58 AM PST

Updated to 2013 Word. In my 2010 version, the "cell" (tables) outlines show in the body of the document (where I paste photos into) but they do not print onto the page when printed. When I open the same document in 2013 Word, the outlines do not show. I go the INSERT menu, table tab pull down and  then click draw table and the outlines show in document. I save document template, and the lines disappear. 

There must be a way to have them show by default, but I have not found it. I have tried to save the document in the new 2013 format, but nothing seems to allow them to show when i open the template. Any help would be appreicated..

Tom

need font in quick style to format as all lowercase

Posted: 06 Feb 2013 08:09 AM PST

I'm using Word 2007 currently on a laptop running Windows XP SP3.  Will be moving back to my Windows 7 once the PC gets back from shop.  But my question remains the same for both systems.  I have a Quick Style that I need to set up so that when applied everything is lowercase.  I can't seem to find a way to set it up for that.  This style is for chapter headings and right now I get "Chapter one" and have to go back and set the C to lowercase manually.  Does anyone know if there's a way to do this?  All I can find under font format is all Strikethrough, Double strikethrough, Superscript, Subscript, Shadow, Outline, Emboss, Engrave, Small caps, All caps, and Hidden.

Any help would be greatly appreciated.

Word 2013 shuts down when loading saved information and gives error message

Posted: 06 Feb 2013 06:56 AM PST

Word 2013 shuts down when loading saved information and gives error message

In Word, saved photos are clear, look good, until I save the document as web page, then they look bumpy. How can I correct this?

Posted: 05 Feb 2013 07:51 PM PST

Saved documents with photos look good, photos are clear. Photos are usually 280x190 pixels, not big. When the document is saved as a web page, the quality of the photos changes, they appear to be textured, or "bumpy". I cannot find a place or way to keep this from happening.
Thanks for any help!

Nested Equations Don't work

Posted: 05 Feb 2013 07:10 PM PST

Nested Equations in Word used to work wonderfully in Office 2010 but have stopped working in Office 2013.

Steps to reproduce:

1. Ctrl + F9
2. Type 'EQ \F('
3. Ctrl + F9
4. Type 'EQ \R(2)'
5. Shift + F9
6. Type ',2)'
7. Shift + F9

Error shows up in Word 2013 but it used to display proper equation in Word 2010. Is this a bug am I looking at?

I am using Office 365 Home Premium.

My MS Word 2010 (PC version) just started displaying my font and paragraph information in pixels. How do I reset it to display in points?

Posted: 05 Feb 2013 02:56 PM PST

My MS Word 2010 (PC version) just started displaying my font and paragraph information in pixels. How do I reset it to display in points? (Instead of seeing 12 pt, I am seeing 12 px. I can't find anything in the Help files to change it.

Updates to a Word Document are not showing up when printing or on print preview

Posted: 05 Feb 2013 06:39 AM PST

I have a computer that is running Office 2007 and in word I have a document that contains a list of addresses to create labels.  I recently updated the file by adding more names to the list.  Whenever I open print preview the changes made do not show up in the preview but anything made before the changes still show up.  The same thing occurs when I print.  Any help would be appreciated.  Thanks.

New documents cannot be opened by double-clicking

Posted: 05 Feb 2013 03:49 AM PST

I just bought a Windows 8 PC and Office 2010.  Old documents open fine from within Word or by double-clicking.  All new documents open fine from within Word, but new document icons are not Word icons, they are orange icons.  Double-clicking them throws up this error message:

The Microsoft Office product is not installed on this computer (Yes, it is, and I paid good money for it!)

Then I click Activate and get this error message:

You cannot install the 32-bit version because you already installed the 64-bit version. (Makes no sense because what I installed otherwise works fine.)