Is there any way to get rid of the table sort buttons?

[JenniferMurphy]

Tables have the little sort buttons on every column. Is there any way to get rid of them? In my opinion, they are a useless waste of space for most columns. They just clutter up the headers.

If I right-click a header and select Sort and then Put Selected Sorting Icon On Top, as I did with the Exact column below, I get a little up arrow. This is curious since the table is not sorted on that column. I got a stern warning about disparaging the M$FT developers, so I'll leave it at that.

What would be really helpful is to eliminate the icons completely and then add the little arrows for those columns that are actually sorted leaving all the rest free of clutter. If they wanted to implement it right, they could add a little sort order number with the arrows to indicate sorting on multiple columns.

ymmv

The mini-sheet did not reproduce the sort icons or the little arrow and it screwed up the column widths. Here's a screen shot of how it really looks:

Temp.xlsm
	B	C	D	E	F	G
2		2	Total number of games (trials)
3		0.5	Probability of winning any 1 game
4
5	Prob	Tot	N	Exact	Cum
6	0.5	2	0	0.25	0.25
7	0.5	2	1	0.50	0.75
8	0.5	2	2	0.25	1.00
Prob Under

Cell Formulas
Range	Formula
B6:B8	B6	=Prob
C6:C8	C6	=Total
E6:E8	E6	=BINOM.DIST([@N],Total,Prob,FALSE)
F6:F8	F6	=BINOM.DIST([@N],Total,Prob,TRUE)

Named Ranges
Name	Refers To	Cells
'Prob Under'!Prob	='Prob Under'!$C$3	B6:B8, E6:F8
'Prob Under'!Total	='Prob Under'!$C$2	C6:C8, E6:F8

 

[Domenic]

To remove the filter buttons, first make sure that any cell with your table is selected, then do the following . . .

Ribbon >> Table Design tab >> Table Style Options group >> uncheck Filter Button

 

[JenniferMurphy]

To remove the filter buttons, first make sure that any cell with your table is selected, then do the following . . .

Ribbon >> Table Design tab >> Table Style Options group >> uncheck Filter Button

That does indeed get rid of the filter buttons. I discovered that I can still sort a column by right-clicking anywhere in that column, selecting Sort, then the sort order. I do lose the indication that it is sorted (sigh). Would including that little arrow would be such a chore?

Thank you.

PS: I wonder why that didn't come up when I did a search. Probably because I didn't use the term "filter".

 

[Domenic]

Would including that little arrow would be such a chore?

I'm unaware of a way to include the little arrow without the filter buttons being displayed. Maybe through the creative use of images and VBA code.

Thank you.

You're very welcome!

PS: I wonder why that didn't come up when I did a search. Probably because I didn't use the term "filter".

Possibly . . .