Data Subtotal/Outline Question

G

Guest

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,
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

subtotal outline not working 7
Subtotal error to expand Outline Levels 1
Sorting and subtotal in a filtered list 1
Subtotals 5
Getting Text data using the Data - Subtotal feature 1
Copying from Subtotal Data 2
SUBTOTAL not refreshing when using advanced filter 2
Outlining function without subtotals 1

Top