Merged Cells

Giganews Newsgroups
Subject: Merged Cells
Posted by:  Jon Robertson (
Date: Tue, 04 May 2004

I want to create a spreadsheet where the first two columns (A & B) are
merged in every row EXCEPT the first row.  I want the two columns
separate in the first row.  The best I came up with was to merge the
columns in rows 2 - 999 (with the help of a macro).  But I have two
complaints about this method.

My first complaint is that Excel "thinks" that my spreadsheet has 1,000
rows, although I only have data in about 160 rows right now.

My second complaint is that if I insert a row, the cells on the new row
are not merged.

It is almost as though I really want to split the "A" column for the
first row only.

Any suggestions would be greatly appreciated.  Any suggestions that
avoid macros would be appreciated even more!