Disable sorting buttons?

[JugglerJAF]

Is it possible (in office 2013) to disable the "Sort A to Z" and "Sort Z to A" buttons (the ones that do the automatic sort), but still allow the user to sort using the main Sort button (the one that displays the Sort dialog box that allows you to choose columns, sort by values/colour etc., and specify ascending or descending).

The reason for the question is that a member of staff keeps managing to break data files by selecting part of the data and clicking the automatic sort button.

I still want to be able to sort data, just not using either of the buttons that apply the sort without showing you any of the sorting options being used.

 

[Comfy]

I don't have 2013 but you could customise the ribbon to remove the quick sort buttons?

Change the Ribbon in Excel 2007 - 2013

That would just leave the sort option via the context menu (right-click)

I have never changed these but reading this post it seems you would use the same process as you would for removing the buttons:

Customizing Context Menus in All Versions of Microsoft Excel