Here are two relevant features to explore when dealing with a concept o
"splitting cells." These actually treat selected cells in a row a
ONE, therefore JOINING, not SPLITTING.
-FORMAT... CELLS... ALIGNMENT... CENTER ACROSS SELECTION
or
-FORMAT... CELLS... ALIGNMENT... MERGE CELLS
If all you want to do is some heading formatting (putting a headin
across multiple columns), use CENTER ACROSS SELECTION-- it doesn't ge
in the way when moving cells or when cut/paste the way MERGE CELL
does. In fact, I am able avoid MERGE CELLS entirely in some ver
complex and good-looking spreadsheets
