Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-15-2015, 09:37 PM
jenpen jenpen is offline Sorting cells alphabetically Windows 8 Sorting cells alphabetically Office 2013
Novice
Sorting cells alphabetically
 
Join Date: Nov 2015
Posts: 3
jenpen is on a distinguished road
Default Sorting cells alphabetically

I have a table, three columns, 20 rows, and each cell is independent as it's a service directory (accountants, bricklayers, contractors etc) for a community newspaper. Occasionally one drops out or I need to add a new one. Is there some way I can sort all cells alphabetically?
Reply With Quote
  #2  
Old 11-15-2015, 11:35 PM
macropod's Avatar
macropod macropod is offline Sorting cells alphabetically Windows 7 64bit Sorting cells alphabetically Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,340
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Have you tried the table sort tools?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-15-2015, 11:40 PM
jenpen jenpen is offline Sorting cells alphabetically Windows 8 Sorting cells alphabetically Office 2013
Novice
Sorting cells alphabetically
 
Join Date: Nov 2015
Posts: 3
jenpen is on a distinguished road
Default

Yes but it assumes you want to keep rows intact. You can't sort individual cells.
Reply With Quote
  #4  
Old 11-16-2015, 12:17 AM
eNGiNe eNGiNe is offline Sorting cells alphabetically Windows 7 32bit Sorting cells alphabetically Office 2010 64bit
Expert
 
Join Date: Jan 2012
Location: Brussels [BE]
Posts: 746
eNGiNe is on a distinguished road
Default

I don't have the right sort of content to check this at the moment, but how about copy/pasting the table into a spreadsheet and using the spreadsheet data sort tools to sort a single column? then copy/paste back into Word and see whether the table survives the journey.
Reply With Quote
  #5  
Old 11-16-2015, 01:36 AM
macropod's Avatar
macropod macropod is offline Sorting cells alphabetically Windows 7 64bit Sorting cells alphabetically Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,340
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by jenpen View Post
Yes but it assumes you want to keep rows intact. You can't sort individual cells.
Why would you want to sort an individual cell? Or do you mean each cell's data are unrelated to other cells on the same row? If it's the latter, you should use a single-column table in a three-column page layout. That way, you can sort the table and insert/delete cells at will and have the table re-organise itself to take account of the edits.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 11-16-2015, 11:35 PM
jenpen jenpen is offline Sorting cells alphabetically Windows 8 Sorting cells alphabetically Office 2013
Novice
Sorting cells alphabetically
 
Join Date: Nov 2015
Posts: 3
jenpen is on a distinguished road
Default

macropod, that might just work... thanks, I'll have a go.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting cells alphabetically Linking cells: can sub-cells move with their master-cell when sorting? kw01 Excel 1 06-30-2015 05:02 PM
Sorting cells alphabetically Table will not allow sorting because "cells are merged". I can't find the merged cells. wendyloooo Word Tables 1 05-26-2015 01:19 PM
Creating a list and sorting alphabetically. irvsax Word 4 09-04-2013 11:47 PM
Sorting cells alphabetically Problem sorting names alphabetically? mikehende Excel 12 09-12-2012 12:00 PM
Sorting cells alphabetically How to sort the styles alphabetically? Jamal NUMAN Word 1 04-14-2011 01:53 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:44 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft