Excel Sort button missing

%3CLINGO-SUB%20id%3D%22lingo-sub-1962840%22%20slang%3D%22en-US%22%3EExcel%20Sort%20button%20missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1962840%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20working%20in%20an%20excel%20file%20setup%20by%20someone%20else%20with%20Table%20banding.%20Now%20there%20is%20no%20sort%20button%20available%20on%20the%20Data%20menu.%20I%20have%20tried%20removing%20the%20table%20banding%2C%20and%20deleting%20the%20table%20headers%20and%20turning%20off%20filters%2C%20but%20nothing%20brings%20back%20the%20ability%20sort.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1962840%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1963535%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Sort%20button%20missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1963535%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F893496%22%20target%3D%22_blank%22%3E%40hhaines33%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20the%20sheet%20is%20protected%2C%20you%20may%20check%20if%20right%20click%20on%20sheet%20name%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1964858%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Sort%20button%20missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1964858%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%2C%20no%2C%20I%20can%20make%20other%20changes%20to%20the%20spreadsheet%2C%20so%20it%20is%20not%20protected.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1966693%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Sort%20button%20missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1966693%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F893496%22%20target%3D%22_blank%22%3E%40hhaines33%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOnly%20some%20regions%20could%20be%20protected%20and%20you%20can%20make%20changes%20in%20other.%20Better%20to%20check%20protected%20or%20not%20in%20menu.%20Anyway%2C%20I%20have%20no%20other%20ideas%2C%20looks%20exactly%20as%20for%20protected%20sheet.%20Or%20partially%20protected%2C%20doesn't%20matter.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 and turning off filters, but nothing brings back the ability sort.

5 Replies

@hhaines33 

Perhaps the sheet is protected, you may check if right click on sheet name

@Sergei Baklan, no, I can make other changes to the spreadsheet, so it is not protected. 

@hhaines33 

Only some regions could be protected and you can make changes in other. Better to check protected or not in menu. Anyway, I have no other ideas, looks exactly as for protected sheet. Or partially protected, doesn't matter.

@Sergei Baklan , 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.

@hhaines33 

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.