| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blank line after control break
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Blank line after control break
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| blank row after control break | Excel Discussion (Misc queries) | |||
| Break cell into multiple lines by line break | Excel Discussion (Misc queries) | |||
| Skipping line on control break | Excel Discussion (Misc queries) | |||
| Cannot Control - Break out of VBA | Excel Discussion (Misc queries) | |||
| Line Break | Excel Discussion (Misc queries) | |||
Linear Mode
