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