Setting a Standard Column Width

Written by Allen Wyatt (last updated October 30, 2023)
This tip applies to Word 2007, 2010, 2013, 2016, 2019, and 2021


Liz has several documents, each with multiple tables containing content. These tables are simple two-column tables with varying numbers of rows. Currently, the column widths of the tables vary depending on the content. Liz wants all the tables to have the same column widths (for example, 5.25" for the first column and 1.25" for the second column). She wonders if there is a way to accomplish this other than setting the column widths for each table one at a time.

If, as Liz describes, these are existing documents that contain a bunch of tables, then the only way to accomplish this task is to use a macro. The technique to use has actually been described in a different WordTip, which you can find here:

https://wordribbon.tips.net/T011693

While the technique described in that tip is applicable to Liz's situation, it can be made even more applicable by simply making a few changes. For instance, Liz indicates that all of the tables have two columns. However, if there is (for some reason) a table or two that have a different number of columns, a macro that expects two columns could play havoc with these other tables. Consider this macro, which simply skips any table that has a different number of columns:

Sub SetTableWidths()
    Dim t As Table
    Dim iFixed As Integer
    Dim iSkipped As Integer
    Dim sTemp As String

    iFixed = 0
    iSkipped = 0
    For Each t In ActiveDocument.Tables
        If t.Columns.Count = 2 Then
            t.Columns(1).Width = InchesToPoints(5.25)
            t.Columns(2).Width = InchesToPoints(1.25)
            iFixed = iFixed + 1
        Else
            iSkipped = iSkipped + 1
        End If
    Next t
    sTemp = "Tables Fixed: " & iFixed & vbCr
    sTemp = sTemp & "Tables Skipped: " & iSkipped
    MsgBox sTemp
End Sub

When you run the macro, it adjusts the width of all two-column tables in the document. When completed, it shows the number of tables that were fixed (the number of two-column tables) and the number of tables that were skipped (those that had fewer or more columns than two).

This macro-based approach works great for documents that already have tables in them. If you are creating new documents, though, you should consider creating a "standard" table and store it as a Building Block. This makes it very easy to put such a table in your document as you are developing it. The way you do this is covered in a different WordTip:

https://wordribbon.tips.net/T006076

Note:

If you would like to know how to use the macros described on this page (or on any other page on the WordTips sites), I've prepared a special page that includes helpful information. Click here to open that special page in a new browser tab.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (13749) applies to Microsoft Word 2007, 2010, 2013, 2016, 2019, and 2021.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Drop-Down List of Hyperlinks

Creating a drop-down list with Excel's data validation feature can be a nice touch for a worksheet. What if you want the ...

Discover More

Determining a Simple Moving Average

A moving average can be a great way to analyze a series of data points that you've collected over time. Setting up a ...

Discover More

Turning Off the Date and Time Shown in a Comment

When you add a comment to a document, Word helpfully includes the date and time that the comment was added. If you don't ...

Discover More

Create Custom Apps with VBA! Discover how to extend the capabilities of Office 365 applications with VBA programming. Written in clear terms and understandable language, the book includes systematic tutorials and contains both intermediate and advanced content for experienced VB developers. Designed to be comprehensive, the book addresses not just one Office application, but the entire Office suite. Check out Mastering VBA for Microsoft Office 365 today!

More WordTips (ribbon)

Converting Tables to Text

Need to convert all the tables in your document into plain text? This tip provides a macro that can make quick work of a ...

Discover More

Removing Whitespace from Table Cells

Do you have trailing whitespace characters in your table cells? There are several ways you can quickly attempt to remove ...

Discover More

Suppressing a Zero in a Calculated Sum

You can use fields to calculate a sum of values in a table column. Here are two ways you can modify what the fields ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] (all 7 characters, in the sequence shown) in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is five minus 1?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)


This Site

Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.

Videos
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.