Forum Discussion
Excel Sort button missing
I am working in an excel file setup by someone else with Table banding. Now there is no sort button available on the Data menu. I have tried removing the table banding, and deleting the table headers...
SergeiBaklan , this was an interesting exercise. I protected and then unprotected the sheet. I also set all cells to unlocked. Unfortunately, I still do not have a sort icon.
I see, thank you. Hard to say more without the file. At least - is that macro-enabled file or not; is that the same if open file in safe mode; is that for only one worksheet in the workbook or for any one; is that for any place within such sheet or only for some specific ranges.