| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to put a line between each group?
If they are sorted, you can use the Data-Subtotals command. It won't put in
a blank line though - it'll add a new line with a formula "Holly" wrote: My file has over 1000 lines by sku & customr, I need to add line between each sku group. This is a data file, I don't want to pivot table to add line, instead of manually add line between each sku, does excel have a formular to add line? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to group bars showing counts and overlay line compliance chart | Charts and Charting in Excel | |||
| Pivot tables - Group Label on each line | Excel Discussion (Misc queries) | |||
| Pivot table reports - repeat the group name on each line | Excel Discussion (Misc queries) | |||
| excel 'begin a group' menu line color | Excel Discussion (Misc queries) | |||
| Converting a group of lines into one line without merging | Excel Discussion (Misc queries) | |||
Threaded Mode
