Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
DCR DCR is offline
external usenet poster
 
Posts: 3
Default subtotal outline not working

I have a data list I wish to subtotal and outline. What is the trick to get
the outline feature to work. All I can get are subtotals below is change in
description. Is there a view setting somewhere to see the 1, 2, 3 etc on
left side of workbook
Thanks
Duane


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default subtotal outline not working

In xl2003 menus:

Tools|Options|View tab|check Outline symbols



DCR wrote:

I have a data list I wish to subtotal and outline. What is the trick to get
the outline feature to work. All I can get are subtotals below is change in
description. Is there a view setting somewhere to see the 1, 2, 3 etc on
left side of workbook
Thanks
Duane


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default subtotal outline not working

hi dave
it is excel 2007. I get the subtotals but no outline. tried every method i
googled. did the group, auto outline. i know it must be a check mark or
simple setting i am missing
Thanks
Duane
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default subtotal outline not working

I'm sure that the same option exists in xl2007.

Office button|excel options

And look for the Outline symbols option (maybe in a view category????)

wrote:

hi dave
it is excel 2007. I get the subtotals but no outline. tried every method i
googled. did the group, auto outline. i know it must be a check mark or
simple setting i am missing
Thanks
Duane


--

Dave Peterson
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
Rename Subtotal outline headers? Nathan Excel Discussion (Misc queries) 1 February 13th 09 05:07 PM
outline symbols (1,2,3) don't show up when subtotal a list dat Excel Discussion (Misc queries) 1 September 26th 08 02:10 PM
Subtotal error to expand Outline Levels Michelle Excel Discussion (Misc queries) 1 October 4th 07 12:31 AM
Data Subtotal/Outline Question Tonya Excel Discussion (Misc queries) 1 June 28th 06 11:00 PM
Group / Outline / subtotal tikchye_oldLearner57 Excel Discussion (Misc queries) 0 June 22nd 06 11:47 AM


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