Monday, July 25, 2011

How to Merge Cells on an Excel Spreadsheet


1. Click the 'Home' tab on the command ribbon.
2. Click and drag to select two or more adjacent cells. A black border surrounds the range of cells. The highlighted cells display one white cell in the upper-left corner and one or more blue cells. Only this white cell retains its data.
3. Click the down-arrow in the 'Merge Center' command in the 'Alignment' group. The three merge options include 'Merge Center,' 'Merge Across' and 'Merge Cells.'
4. Click the preferred merge option. The cells become one larger cell.

Blogger news