Ten Minute Guide to Excel 97

Merging Cells

In Excel 97, you can merge the data in one cell with other cells to form a big cell that is easier to work with. Merging cells is especially handy when creating a decorative title for the top of your worksheet (see Figure 13.2 for an example). Within a single merged cell, you can quickly change the font, point size, color and border style of your title. (See Lessons 17, 18, and 19 to learn more about formatting cells.)

To create a title with merged cells, follow these steps:

1. Type your title in the upper-left cell of the range you want to use for your heading. If you have a multi-line title, like the one in Figure 13.2, press Alt+Enter to insert each new line.

   Figure 13.2. Merge cells to form a single cell.

2. Select the range in ...