Remove 'buttons' after Subtotals

  • Thread starter Thread starter Teak
  • Start date Start date
T

Teak

I used the Data.Subtotal function to create subtotal.
But I want to remove those untidy buttons on the left side, so that it will
looks like a normal ws.
how?

Thanks for any help rendered.
 
Tools|Options|View Tab|Uncheck Outline symbols.

But they're really useful!
 
You must log in or register to reply here.

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

Macro To Remove Subtotals from ALL Worksheets 2
Subtotals Deleting Rows after removing Subtotal - 2003 Excel 1
Additonal info into newly created Subtotal row 1
Subtotal of adjacent coloumn 4
Intercept and Slope of visible rows, please. 0
How do I make AutoSum really Sum, not Subtotal 5
Why can't I click the Subtotal button? 3
Import external data into Excel 2007 so I can subtotal it 2

Back
Top