By continuing to use this site, you agree to our use of cookies. Find out more
Forum sponsored by:
Forum sponsored by Forum House Ad Zone

Organising M.E. index spreadsheet

All Topics | Latest Posts

Search for:  in Thread Title in  
steamdave30/06/2021 12:34:27
521 forum posts
45 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.

The Emerald Isle

DC31k30/06/2021 12:57:07
725 forum posts
2 photos

Your question starts at sub-section number 3.

Bizibilder30/06/2021 12:57:52
125 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
194 forum posts
65 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
2071 forum posts
725 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
521 forum posts
45 photos

Thanks gents for your help. All sorted now.

The Emerald Isle

John Haine30/06/2021 16:58:54
4712 forum posts
273 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

Sign up to our Newsletter

Sign up to our newsletter and get a free digital issue.

You can unsubscribe at anytime. View our privacy policy at

Latest Forum Posts
Support Our Partners
Eccentric July 5 2018
Eccentric Engineering
Rapid RC
Subscription Offer

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