ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data Subtotal/Outline Question (https://www.excelbanter.com/excel-discussion-misc-queries/96668-data-subtotal-outline-question.html)

Tonya

Data Subtotal/Outline Question
 
When I add subtotals to a spreadsheet, sometimes I get the 3 button outline
options at the right and sometimes they are not there even though the
subtotals are. Does this have something to do with the length of the
spreadsheet or is there another variable?

Is there someway to always get the outline buttons?

Thanks,
--
Tonya

Dave Peterson

Data Subtotal/Outline Question
 
The only time I can remember not seeing them is when I turn them off:

Tools|Options|View Tab
Make sure Outline Symbols is checked.

Tonya wrote:

When I add subtotals to a spreadsheet, sometimes I get the 3 button outline
options at the right and sometimes they are not there even though the
subtotals are. Does this have something to do with the length of the
spreadsheet or is there another variable?

Is there someway to always get the outline buttons?

Thanks,
--
Tonya


--

Dave Peterson


All times are GMT +1. The time now is 05:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com