When working with tables, you may not want the rows in the table to break across pages. In other words, you want everything in each row to be on the same page. This is easy enough to do manually—you just adjust the table properties in this manner:
Figure 1. The Row tab of the Table Properties dialog box.
Now each row will stay on its own page. The table will still break across pages, but individual rows in the table will not.
While this seems easy enough, it can be tiresome to go through this same process for lots of tables in a document. For example, if you've got 50 tables, then you'd have to go through the above steps 50 times. Argh!
The answer is to use a macro to change the Allow Row to Break Across Pages setting for all the tables. The following will do the trick:
Sub StopRowBreaking()
Dim tbl As Table
For Each tbl In ActiveDocument.Tables
tbl.Rows.AllowBreakAcrossPages = False
Next
End Sub
The macro works because it steps through each table and clears the setting (the AllowBreakAcrossPages property) for all the table's rows as a group. It is very quick, even if you have 50 or more tables in your document.
Note:
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (13339) applies to Microsoft Word 2007, 2010, and 2013.
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!
If you've adjusted the height of your table and the rows within the table, you might want to later return all those rows ...
Discover MoreNeed a way to make sure your text fits within the space available in a table cell? Word has a handy setting that will ...
Discover MoreOne of the most common ways to format information in a table is to apply some sort of alignment to the contents of table ...
Discover MoreFREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
2018-08-21 10:59:24
Maddy Scientist, Jr
Very useful. The only thing I would add is be sure to add "Set tbl = Nothing" at the end to release the object from memory. Like this:
Public Sub StopRowBreaking()
Dim tbl As Table
For Each tbl In ActiveDocument.Tables
tbl.Rows.AllowBreakAcrossPages = False
Next tbl
Set tbl = Nothing
End Sub ' StopRowBreaking
2014-12-20 23:25:28
Art Osgatharp
For more granular control, change ActiveDocument.Tables to Selection.Tables. Click and drag, or otherwise select, the part of the document containing the table or tables to process, then run the macro. The macro will process each table in the selection, leaving un-selected tables in the document unaffected.
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.
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2019 Sharon Parq Associates, Inc.
Comments