View Full Version : Excel - Merge Cells
Capuchin
Jan 10, 2007, 02:27 AM
Any way to merge a number of cells into one cell, for example the title of many columns in a table?
colbtech
Jan 10, 2007, 02:45 AM
Try concat this function joins strings, you can add " " between arguments.
See attached zip
Capuchin
Jan 10, 2007, 03:00 AM
I mean merge the cells so that more than one column is headed by a single cell, I know you can do it with word tables, but I can't find the option in excel. Maybe you can't do it because spreadsheets are less of a presentation tool.. :/
colbtech
Jan 10, 2007, 03:51 AM
Select the 2 or more cells in the header row and then Format, Cells, Alignment, Check the Merge Cells.