Organising M.E. index spreadsheet

Is it possible to organise Excel into ascending or descending order across all columns?

I particularly would like to reorganise the Model Engineer index Excel spreadsheet to show contributors in alphabetical order with their contributions. This would make it easier to search for particular articles.

I can sort and filter Authors in alphabetical order but the remaining columns are not sorted using the Sort & Filter button.

Dave
The Emerald Isle

https://support.microsoft.com/en-us/office/sort-data-in-a-table-77b781bf-5074-41b0-897a-dc37d4515f27

Your question starts at sub-section number 3.

Highlight the entire sheet and then use custom sort to sort on the column you require - the whole sheet will be sorted.

Dave, if you highlight the entire table before turning on the sort/filter tool (or off and on again), it should keep all the rows in order. Let me know if you're struggling and I'll see if I can sort it out for you.

Make a copy and use it for sorting columns. Unlike a database (MS Access, etc) the data in the columns for each record is not linked together and easy to mix them up and ruin the file.

Edited By Paul Lousick on 30/06/2021 13:13:18

Thanks gents for your help. All sorted now.

Dave
The Emerald Isle

You have probably seen this now, but if, having sorted, you click on the little down arrow next to the column head it gives you a list of all the contents in that column with a tick box. If you untick them all by clicking on the "select all" box then click the (say author) you want it will show you just the relevant entries.