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.

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 (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

Linking Comments to Multiple Cells

In Excel, single comments are associated with single cells. If you want to have a comment be linked to multiple cells, ...

Discover More

Friendly and Informative Error Handling

When creating macros, it is helpful to know what is going on within the macro itself in case an error crops up. Here's ...

Discover More

Adding Automatic Lines

Want an easy way to add lines in your document? You can do it by making sure Word is using one of its AutoFormat features.

Discover More

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!

More WordTips (ribbon)

Summing a Table Column

Need to add a sum to a column of figures in a table? Word makes it relatively easy to provide the sum you need.

Discover More

Jumping to Tables

If your document contains quite a few tables, you may find it helpful to jump quickly from one table to another. There ...

Discover More

Displaying Table Gridlines

For those times when you remove the borders from your tables, Word provides a way that you can display non-printing ...

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 5 + 9?

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.