I want to break a set of 52 columns (weeks) into relevant quarters using the
group and outline function, however, Exel in its wisdom automatically merges
adjacent groups.
This could be made to work by inserting blank columns or summary columns
between each quarter. However, many formulae use offsets to look into the
future columns.
Inserting columns of any sort will kaibosh the offset so it's not an option.
I would prefer not to use macros if possible (keeps it simple for when I
leave) but will do as a last resort.

Does anyone know how to get around or 'disable' the merging of columns.

You could select the first 12 weeks and group them. Week 13 will be
included as the summary week. Then, group weeks 14-25, etc.

When you collapse the outline, the last week in each quarter will be
visible.

Gizmo63 wrote:
I want to break a set of 52 columns (weeks) into relevant quarters using the
group and outline function, however, Exel in its wisdom automatically merges
adjacent groups.
This could be made to work by inserting blank columns or summary columns
between each quarter. However, many formulae use offsets to look into the
future columns.
Inserting columns of any sort will kaibosh the offset so it's not an option.
I would prefer not to use macros if possible (keeps it simple for when I
leave) but will do as a last resort.

Does anyone know how to get around or 'disable' the merging of columns.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html