JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,535
- Office Version
- 365
- Platform
- Windows
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:
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 |