Jumping to a Table Row

by Allen Wyatt
(last updated June 27, 2015)

2

Maren has a document that has a very large table in it, spanning many pages. She would like the ability to jump to a specific row in the table, so she wonders if it is possible to use the Go To feature to jump to a particular row number, such as row 80.

The Go To dialog box (which is displayed by pressing F5) allows you to jump to lots of different places in a document. (How you use the dialog box has been covered in other issues of WordTips.) It is actually possible for it to be used with table rows, with one huge caveat.

If your document only contains a table, you can jump to rows by following these steps:

  1. Press F5. Word displays the Go To tab of the Find and Replace dialog box.
  2. At the left side of the dialog box choose Line. (See Figure 1.)
  3. Figure 1. The Go To tab of the Find and Replace dialog box.

  4. Enter the row number to which you want to move.
  5. Click on Next, or press Enter.

This works because Word apparently considers each row in the table a "line." (It isn't affected, either, but rows that contain wrapped lines or multiple paragraphs.) This brings me to the caveat: If your document contains more than a table—especially text before the table—then the line jumping will be off because Word counts the non-table text in its line count calculations.

In that case, you'll need to use a macro to jump to the row you want. The following is an example of one that could be used.

Sub GoToTableRow()
    Dim RowNum As Integer
    Dim LastRow As Integer
    Dim Question As String

    If Selection.Information(wdWithInTable) Then
        LastRow = Selection.Tables(1).Rows.Count
        Question = "Enter a number from 1 to " & LastRow
        RowNum = InputBox(Question, 1)
        If (RowNum < 1) Or (RowNum > LastRow) Then
            MsgBox "That's an invalid row number"
            Exit Sub
        End If
        Selection.Tables(1).Rows(RowNum).Cells(1).Select
    Else
        MsgBox "Not in table"
    End If
End Sub

The macro first checks to make sure the insertion point is within a table. If so, it asks the user which row number he or she would like to jump to. Assuming that the row number is in the range of available row numbers, the row is then jumped to.

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

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

Working With OLE Graphics

An explanation of the way Word imports graphics.

Discover More

Editing an AutoText Entry

Once you've created an AutoText entry, you may believe that it is "set in stone" and cannot be changed. Not so! You can ...

Discover More

Selecting Columns in VBA when Cells are Merged

If you have a macro that selects different columns in a worksheet while processing information, you may get some ...

Discover More

Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!

More WordTips (ribbon)

Setting Table Values to Three Decimal Places

If you import information into a document from another program, the values you import may not be exactly to your liking. ...

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

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
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}] 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 one more than 2?

2017-11-09 09:16:48

mat

Statement:

Selection.Tables(1).Rows(RowNum).Cells(1).Select

does not work in case of vertically merged cells in the table.

Any other solution?


2015-06-29 08:18:11

rpurosky

Why memorize F5 for Go To when Ctrl+G does the same and is much more intuitive?


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.

Newest Tips
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.