How to Split a Cell in Excel 2007. ... creators find this technique useful when they need to create a single cell that has a wide heading and place smaller cells under that heading.

Launch Microsoft Excel and open your spreadsheet. Select as many adjacent cells in a single row as you want to have columns under the header, starting with the cell you want to use as the header ...