View Single Post
  #5   Report Post  
jgiorget jgiorget is offline
Junior Member
 
Posts: 1
Default

Quote:
Originally Posted by RagDyeR View Post
(snip)

However, if you would leave a column in between each group as a summary
column, XL by default, designates this *ungrouped* summary column to be on
the right side of the group (or on the bottom for grouped rows). This is
where it (XL) places the "+" and "-" signs to expand or collapse the group.

To change this default setting from "right" to "left" (or "bottom" to "top"),
<Data <Group&Outline <Settings
And check or uncheck the desired configuration.

(snip)
In case anyone is reading this page looking for an answer to the question for Excel 2010 (with ribbon)…

Find the ‘outline’ group within the ‘data’ ribbon (you’re probably there already), and click the tiny arrow in the bottom right of that group. You’ll get a dialog box that lets you change where the summary rows go (left or right).