• Practice
  • About 12 min
  • 5 practice questions

Tables and mail merge in depth

Count cells after merging and splitting, use table commands correctly, and list the parts and steps of a mail merge.

If something looks wrong, please tell us.

Tables and mail merge give a steady flow of questions that need a little counting and clear vocabulary. The first lesson on layout gave the basic terms. Here we go deeper into the operations and into how a mail merge actually works.

Table operations

Common table commands
OperationEffect
Insert row or columnAdds a new row above or below, or a column left or right
Delete row or columnRemoves it along with its contents
Merge cellsJoins selected cells into one larger cell
Split cellsDivides one cell into a chosen number of rows and columns
AutoFitAdjusts column width to the content or the window
SortArranges rows alphabetically, numerically or by date
Borders and shadingLines around cells and background colour inside them
Convert text to tableTurns text separated by tabs or commas into rows and columns

The Table Tools tabs (Design and Layout) appear only when the cursor is inside a table. Gridlines are faint guide lines that show cell edges on screen but do not print, while borders do print.

How a mail merge works

A mail merge has three parts: the main document (the letter with fixed text), the data source (a table or spreadsheet of names and addresses; each row is a record and each column is a field), and the merge fields placed in the letter, such as the name or the city. When the merge is run, the word processor produces one copy of the letter for every record.

  • Write or open the main document.
  • Choose or create the recipient list (the data source).
  • Insert merge fields where the personal details should appear.
  • Preview the results to check the merge.
  • Finish: print the letters, save them or send them by e-mail.

Worked examples

Example 1. A table has 5 rows and 4 columns, so it has 5 x 4 = 20 cells. The two cells in the first row, columns 1 and 2, are merged into one. Number of cells now = 20 - 1 = 19, because merging two cells leaves one. If another cell is split into 3 pieces, the count rises by 3 - 1 = 2, giving 21.

Example 2. A school keeps a list of 250 parents in a spreadsheet and has 1 invitation letter. A mail merge makes 250 letters, one for each record. The letter file is the main document, the spreadsheet is the data source, and the column holding the parent's name is a field. If 10 records are removed from the list before merging, only 240 letters are produced.

Example 3. A student pastes names separated by commas, such as Asha,Ravi,Mohit, and wants them as three cells in a row. Select the text and use Convert Text to Table, choosing comma as the separator. One row with 3 columns is created.

A mail merge makes one copy for every record: main document + data source + merge fields.

Key takeaways. Merging cells reduces the cell count, splitting increases it. Record means row, field means column. A mail merge needs a main document, a data source and merge fields, and produces as many letters as there are records.

Check your understanding

  1. 1. In a mail merge, each row of the data source is called a:

    1. Field
    2. Record
    3. Cell
    4. Section
    Show answer

    Answer: B. A row holds all details of one person and is a record. A column, such as the name, is a field.

  2. 2. A table of 6 rows and 3 columns has two cells merged into one. How many cells remain?

    1. 18
    2. 15
    3. 16
    4. 17
    Show answer

    Answer: D. 6 x 3 = 18 cells. Merging two cells into one leaves one cell fewer, so 18 - 1 = 17.

  3. 3. Which command divides one cell into several rows or columns?

    1. Merge Cells
    2. Split Cells
    3. AutoFit
    4. Sort
    Show answer

    Answer: B. Split Cells divides a cell. Merge Cells does the reverse, and AutoFit only adjusts widths.

  4. 4. A data source has 180 records and the main letter is merged with all of them. How many letters are produced?

    1. 180
    2. 1
    3. 18
    4. 360
    Show answer

    Answer: A. One letter is produced for each record, so 180 letters in all.

  5. 5. Which lines show cell edges on screen but do not appear in print?

    1. Borders
    2. Gridlines
    3. Underlines
    4. Margins
    Show answer

    Answer: B. Gridlines are only a guide on the screen. Borders are real lines and are printed.

Privacy · Terms · Refunds · Delivery