Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 27th 07, 04:20 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2007
Posts: 2
Default How do you create roll-up rows in EXCEL?

I have recently seen a worksheet with + boxes to the left of a row that when
you click on it several related rows are revealed and the + becomes a -. When
you click the - the newly reveald rows are hidden and the initial line is
visible and the sign chaned back to a +.

Can someone tell me how this is done?

  #2   Report Post  
Old June 27th 07, 04:23 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 301
Default How do you create roll-up rows in EXCEL?

By Grouping. Excel 2003: Select the rows (or columns) you want to group,
then use Data/Group and Outline/Group. in Excel 2007: Data tab/Group
Bob Umlas
Excel MVP


"TOMA" wrote in message
...
I have recently seen a worksheet with + boxes to the left of a row that
when
you click on it several related rows are revealed and the + becomes a -.
When
you click the - the newly reveald rows are hidden and the initial line is
visible and the sign chaned back to a +.

Can someone tell me how this is done?





Reply
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
How to roll up columns or rows for summary purposes? IgorHendriksen Excel Worksheet Functions 1 October 15th 06 12:21 PM
how do i roll dates forward in excel Davecl New Users to Excel 4 September 24th 06 05:13 AM
Excel Summary Tab/Roll-Up - somebody PLEASE impress me here!! lacey125 Excel Discussion (Misc queries) 0 September 20th 06 09:43 PM
roll up a calendar in excel Crystal Excel Worksheet Functions 0 July 19th 06 07:10 PM
trying to create a rent roll Zachary Chan Excel Discussion (Misc queries) 0 November 8th 05 09:03 AM


All times are GMT +1. The time now is 05:16 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017