Do you mean that you want to physically merge those cells, so effectively you have only one cell covering 7 columns ? If so, you will need a macro to do that.

Pete