Merged Cells

  • Thread starter Thread starter Jon Robertson
  • Start date Start date
J

Jon Robertson

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!

Thanks
 
Jon,

Try to avoid the merged cells, if you can. They are quite troublesome later
on.

If you instead use Center across Selection (Format - Cells - Alignment),
you'll avoid the problems associated with merged cells. Also, you can
simply select the two columns, apply the formatting, and each row will
center, unlike merging cells, where the whole thing wants to merge into one
cell. No macro needed. If you insert a row, the new one will have the
center
across selection.

You'll have the same problem with the Used Range. I think there's info on
that at www.contextures.com.
 
Back
Top