|485 forum posts|
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.
|546 forum posts|
Your question starts at sub-section number 3.
103 forum posts
Highlight the entire sheet and then use custom sort to sort on the column you require - the whole sheet will be sorted.
|Calum Galleitch||30/06/2021 13:07:55|
95 forum posts
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.
|Paul Lousick||30/06/2021 13:12:01|
|1836 forum posts|
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
|485 forum posts|
Thanks gents for your help. All sorted now.
|John Haine||30/06/2021 16:58:54|
|4086 forum posts|
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.
Please login to post a reply.
Want the latest issue of Model Engineer or Model Engineers' Workshop? Use our magazine locator links to find your nearest stockist!
You can contact us by phone, mail or email about the magazines including becoming a contributor, submitting reader's letters or making queries about articles. You can also get in touch about this website, advertising or other general issues.
Click THIS LINK for full contact details.
For subscription issues please see THIS LINK.