I have a .xls file in which the contents Column A is repeated for several
rows before it changes. Columns B, C, D are different for each row. How do I
get a blank row after each break in the contents of column A

I would make sure that the data was sorted (and had headers), then use:
Data|subtotals
(in xl2003 menus)

You'll be able to get the control break and some subtotals!

GregNga wrote:
>
> I have a .xls file in which the contents Column A is repeated for several
> rows before it changes. Columns B, C, D are different for each row. How do I
> get a blank row after each break in the contents of column A

--

Dave Peterson