How To Sort Alphabetically

Table of contents:

How To Sort Alphabetically
How To Sort Alphabetically

Video: How To Sort Alphabetically

Video: How To Sort Alphabetically
Video: How to Sort Alphabetically in Excel 2024, May
Anonim

Sorting in alphabetical order is a fairly common operation, so it is included in most modern office applications. Some of these programs provide only rudimentary string ordering - usually text-oriented applications. Others can sort string variables placed in spreadsheets.

How to sort alphabetically
How to sort alphabetically

Necessary

Word processor Microsoft Office Word or spreadsheet editor Microsoft Office Excel

Instructions

Step 1

To sort a list of strings alphabetically, use, for example, a word processor called Microsoft Office Word. Select and copy (Ctrl + C) the list, start Word and paste (Ctrl + V) the contents of the clipboard into a blank document created by the program at startup. Then select all the pasted text again - press the keyboard shortcut Ctrl + A.

Step 2

Click on the "Sort" button in the "Paragraph" group of commands on the "Home" tab of the word processor menu - it is marked with an icon with the letters A and Z placed one above the other. This button opens a sort dialog in which you can simply click OK, and the selected lines will be sorted alphabetically in ascending order. If you need the reverse order, check the box "descending" - for this, just press the key with the letter "B".

Step 3

To make lines beginning with uppercase letters appear in the sorted list before lines beginning with lowercase letters, use the advanced settings of this operation. Open them by clicking on the "Options" button in the "Sort" dialog, and check the box "case sensitive" - this can also be done from the keyboard, just press the key with the letter "H". Then close both windows by clicking OK in each of them, and the problem will be solved.

Step 4

To sort data with a structure that is more complex than just strings, it is better to use another program from the office suite - Microsoft Office Excel. This is a spreadsheet editor, so you can insert table data into it, in which the column separators are, for example, tabs, and the line separators are carriage returns.

Step 5

Start Excel, copy the tabular data, and paste it into the workbook that you created at startup. Then right-click any cell in the column by which you want to sort the table. In the context menu, go to the "Sort" section and select one of the items - "Sort from A to Z" or "Sort from Z to A". The rows in the entire table will be arranged according to the alphabetical order of the data in the column you selected.

Recommended: