View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
steven1001
 
Posts: n/a
Default How do i automatically group rows in a pivot table?


You could select multiple rows with the mouse, right-mouse-click and
then 'group'. then over-type a description for that group.

You could also use a vlookup or equivalent to populate a helper column
with labels that you can group by.

regards..


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=528688