PDA

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.