Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sheet protection and "Group and Outline" | Excel Discussion (Misc queries) | |||
How to Use Group and Outline function when locked sheet | Excel Worksheet Functions | |||
Why is Group and Outline grayed out? | Excel Worksheet Functions | |||
Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) | |||
How do I hide the outline of a Forms Group Box? | Excel Discussion (Misc queries) |