LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gizmo63
 
Posts: n/a
Default Group and Outline Adjacent Columns

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sheet protection and "Group and Outline" OkieViking Excel Discussion (Misc queries) 9 May 22nd 07 05:17 PM
How to Use Group and Outline function when locked sheet Denis Excel Worksheet Functions 0 July 22nd 05 04:18 PM
Why is Group and Outline grayed out? Why is Group and Outline grayed out? Excel Worksheet Functions 1 February 19th 05 12:32 AM
Can't group pivot table items by month in Excel scott_ensley Excel Discussion (Misc queries) 1 February 1st 05 08:41 PM
How do I hide the outline of a Forms Group Box? MadTodd Excel Discussion (Misc queries) 7 January 17th 05 05:45 PM


All times are GMT +1. The time now is 07:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"