How do you organize information alphabetically in Microsoft Excel?

Question

Or in any Microsoft Office program.

Answer 1

If you want to keep everything associated (all the lines sort by one column) select everything, go to Data -> Sort... Select the columns that you want to sort by and the direction you want it sorted (a-z or z-a).

Answer 2

Go under the DATA tab. Click on sort, and fill in your criteria. Also, there should be a button on the tool bar that has an A on top of a Z with an arrow pointing downwards. This is a quick alphabetical sort.

Answer 3

In excell you choose the column you want to sort then click data at the top of the window and choose sort then sort by column and choose asscending to do alphabetically or descending to reverse the order z to a. Hope this helps

Answer 4

Excel: select the data, find the sort command, and plug in the letter of the column/s you want to sort by.

Word: works similarly. The sort command in under the table menu.

Answer 5

Highlight the column you'll be working with (A for example) then go to Data > Sort. If there is a header row, click the mark for header row, if not click the mark for no header row. Have it sort by the desired column, then click sort and there you go.

Answer 6

to ensure that the different records now to not grow to be unattached, you ought to choose each and each of the info formerly you do the "form..." choose suitable left cellular, carry down shift and ctrl, press the right arrow key, then down arrow key. that's fastest thanks to choose all of it.