By continuing to use this site, you agree to our use of cookies. Find out more
Forum sponsored by:
Forum sponsored by Allendale Jan 24th

Organising M.E. index spreadsheet

All Topics | Latest Posts

Search for:  in Thread Title in  
steamdave30/06/2021 12:34:27
485 forum posts
38 photos

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

DC31k30/06/2021 12:57:07
546 forum posts
1 photos

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.

Bizibilder30/06/2021 12:57:52
avatar
103 forum posts
7 photos

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

Calum Galleitch30/06/2021 13:07:55
avatar
95 forum posts
27 photos

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 Lousick30/06/2021 13:12:01
1836 forum posts
659 photos

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

steamdave30/06/2021 16:32:00
485 forum posts
38 photos

Thanks gents for your help. All sorted now.

Dave
The Emerald Isle

John Haine30/06/2021 16:58:54
4086 forum posts
241 photos

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.

All Topics | Latest Posts

Please login to post a reply.

Magazine Locator

Want the latest issue of Model Engineer or Model Engineers' Workshop? Use our magazine locator links to find your nearest stockist!

Find Model Engineer & Model Engineers' Workshop

Latest Forum Posts
Support Our Partners
Warco
rapid Direct
Dreweatts
Eccentric July 5 2018
walker midge
JD Metals
cowells
emcomachinetools
Eccentric Engineering
Subscription Offer

Latest "For Sale" Ads
Latest "Wanted" Ads
Get In Touch!

Do you want to contact the Model Engineer and Model Engineers' Workshop team?

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.

Digital Back Issues

Social Media online

'Like' us on Facebook
Follow us on Facebook

Follow us on Twitter
 Twitter Logo

Pin us on Pinterest