Sort In Word For Mac

If you want to sort by the second word for each entry (for example, by last name in a FIRST, LAST format), click the Options button in the Sort Text window. In the “Separate fields by” section, select Other and enter a single space. Press OK, and then select Word 2 in the Sort By menu. Press OK to sort the list. Word will allow you to create two columns for the whole document, in which the text flows from one column to the next on each page, or just for a particular section of the document. Separate a Word document into two columns for a newsletter.

You can sort a column by Number, Text or Date depending on the values. As you can see, there’s a choice to sort in either direction. My list has tells Word whether to include or exclude the top row or header from the sort. NOT automatic Remember that Word sorting is a ‘one-time’ deal. If you change the table (add/remove rows) the sort order is NOT automatically applied.

You have to reapply the Sort command after data changes. Saving Sort Criteria shows how to save and reapply sorting rules to a table. Options The options button has some powerful choices that a worth keeping in mind. There are choices that Excel and Access users would like to have but don’t. Separate fields at • Tabs • Commas • Other This option lets you break up a single entry into different elements for sorting. The most common option used is ‘space’ and that’s missing from the list given.

To separate by space choose ‘Other’ and ensure the hyphen is replaced with a single space. Use the space to separate first names from surnames. This is list sorted by ‘Astronaut’ but uses first names. • Al Bean • Al Shepard • Buzz Aldrin • Charlie Duke • Dave Scott • Ed Mitchell • Gene Cernan • Jack Schmitt • John Young • Neil Armstrong • Pete Conrad • Scott Irwin Change the field separator to space then Sort by: ‘Word 2’.

• Buzz Aldrin • Neil Armstrong • Al Bean • Gene Cernan • Pete Conrad • Charlie Duke • Scott Irwin • Ed Mitchell • Jack Schmitt • Dave Scott • Al Shepard • John Young That works for a simple “First Surname” situation but if you add some middle names, nicknames or other common prefixes then this feature breaks down. For example: • Jack ‘Harrison’ Schmitt • Farouk El Baz • Werner von Braun Other lists that can use the ‘Separate Fields’ option are: Using colon character to sort by number: • Mercury: 6 manned missions • Gemini: 10 manned missions • Apollo: 11 missions • Space Shuttle: 135 missions Or using $ to sort by dollar value: • Wilma $65,762 • Betty $12,934 • Barney $7642 • Fred $134 Note: choose type ‘Number’.

The values will sort correctly with or without commas. Sort columns only – this choice is usually fixed but is active if you choose a table column and want only that column to be sorted. Case sensitive – sorts normally ignore case. Right-to-left language first – text sorts only.

Ignore – some choices for character types to ignore when sorting • (e.g. Accents, acute, grave, umlaut etc.) • alef lam in Arabic • Sorting language This option is, as far as we know, unique to Word and very useful. Great multiplayer games for mac steam. Normally sorting order or collation is controlled by the Windows Regional setting but Word Tables have the choice of a separate order in a language different from the Windows setting or the languages used in the document.