Blank line after control break

G

GregNga

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
 
D

Dave Peterson

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!
 
Top