Leading the way in Microsoft Office Development

If you want to split an existing table into two tables click in the row you want to become the first row of the second table and choose (Tables > Split Table)

If your table continues for several pages and you want the same heading to repeat itself on each page select the heading rows and choose (Table > Heading Rows Repeat).

If a table appears at the top of the first page and you need to add text before it click in the top left cell and choose (Tables > Split Table). This will create a carriage return before the table.

To prevent rows breaking across pages select the rows, right click select (Table > Table Properties) (Row tab, and clear the “Allow Row to break across pages” checkbox. Widow and Orphan lines are not recommended. With this unchecked any rows that do not fit entirely on the page are moved to the next page.

The properties of a table can be accessed from (Table > Table Properties). This gives you more options for formatting the table rows, columns and cells.

A lot of table formatting tools do not allow you to format a table if cells have been merged. Using the IBE Table Formatter merged cells do not cause a problem

Any table with any amount of merged cells / heading rows formatted consistently

Quick Numbering

Highlight the column you want the numbers to appear in.

Press the Numbering button on the Formatting toolbar.

Example – summing rows and columns

Click anywhere on your table

click on Table > Sort)

Select Region in the sort by field

Select text because you are sorting text

Select ascending

Select the top row in the column you wish to sort by

Select header row

Example – Using the sum function

Place your cursor in the relevant cell

Press the Tab to create a new row

Table > Formula, Enter

Type Sum(above)

Select #,##0 in the number format

OK

If you have a table containing merged cells and there is a cell with merged cells in its row then when text within that cell spills over to the next page the extra test is not visible.

Heading Rows

To add a row for column headings, place the pointer in the top left-hand corner and use (Table > Insert Rows)

To repeat heading rows at the top of a table that spans more than one page use (Table > Repeat Heading Rows)