|Posted by:||Jon Robertson (firstname.lastname@example.org)|
|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!