Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default solution

Thank you this worked for me even in Excel 2010. I was wondering if this option is unchecked off by default or if it was changed at some point? Thanks for your help


Regards

On Friday, August 27, 2010 1:13:21 PM UTC-6, john wetmore wrote:
for any of you searching for a solution.. i have found it and thought it may help someone down the road. this is for excel 2007..

go to start button, excel options, click advanced.. now go down to the secion that says "display options for this worksheet", make sure "show outline symbols if an outline is applied" is checked.

http://excel.tips.net/Pages/T003020_...e_Symbols.html

On Wednesday, February 10, 2010 3:59 PM 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



On Wednesday, February 10, 2010 6:18 PM Dave Peterson wrote:


In xl2003 menus:

Tools|Options|View tab|check Outline symbols



DCR wrote:

--

Dave Peterson



On Thursday, February 11, 2010 1:58 AM j 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



On Thursday, February 11, 2010 7:59 AM Dave Peterson wrote:


I am sure that the same option exists in xl2007.

Office button|excel options

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


--

Dave Peterson



Submitted via EggHeadCafe - Software Developer Portal of Choice
Assemblies in Folder Debug Build Checker
http://www.eggheadcafe.com/tutorials...d-checker.aspx


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 03:32 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"