Is it possible to select multiple sheets and then apply the Sort tool to all the sheets selected? I just tried it myself but it didn't work. I selected several sheets and then highlighted a table I want sorted, but when I went to the pull down menus, "Sort" was grayed out, as was most of the tools under the "Data" menu.
I have the same table on every sheet (same location, same format/formulas, etc. The only thing that is different is the contents of each table. I want to be able to sort all the tables on every sheet simultaneously rather than have to go from sheet to sheet and applying the sort tool once on each sheet.
I have the same table on every sheet (same location, same format/formulas, etc. The only thing that is different is the contents of each table. I want to be able to sort all the tables on every sheet simultaneously rather than have to go from sheet to sheet and applying the sort tool once on each sheet.