Forum Discussion
Can't Sort Data
I have always been able to sort data by column and add columns etc but now the sort button does not light up to give me the option to click on it?? I currently use Office 365
I do it that way all the time myself....highlight the entire table including headers....it just seems that there have been a few cases where it wouldn't allow me to even choose the "sort" button after clicking on "Data" tab. Now that I think about this....it has happened before on one of my Lenovo desktops that is running Windows 10.
Check "Review" -> "Protect/Unprotect Sheet/Workbook", see if your file is protected from these activities.