Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 93
Default why do the groups not show when i subtotal?

I have a spreadsheet with ~40000 rows of data. When I subtotal, it doesn't
give me the expandable menu on the side. Is this too much data for the
groups to handle?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 104
Default why do the groups not show when i subtotal?

Ctrl and 8 on a standard keyboard toggles the outline on and off. Could this
be your problem?
--
Hope this helps,
MarkN


"Stephanie" wrote:

I have a spreadsheet with ~40000 rows of data. When I subtotal, it doesn't
give me the expandable menu on the side. Is this too much data for the
groups to handle?

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
Help with Lists... Corey Excel Discussion (Misc queries) 0 July 5th 06 09:39 PM
copy subtotal value only - also can be lookup from other worksheet BB Excel Discussion (Misc queries) 1 June 30th 06 10:12 AM
some charts will not show trendlines comfuted Charts and Charting in Excel 8 June 12th 06 10:17 PM
add No's to show as hrs and mins (i.e 7.24+2.58 to show as 10.22) Abrahams Excel Discussion (Misc queries) 1 March 31st 06 02:48 PM
show groups tereses Excel Worksheet Functions 1 December 21st 04 05:37 PM


All times are GMT +1. The time now is 10:09 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"