How do I put my list of movies in alphabetically order?

Question

I have listed our entire movie collection in Microsoft Excel, and want to list in alphabetical order. My brain is very stressed on other issues, so I think I'm just overlooking how to do this simple thing that I have done before. I call today, my DUHH! DAY! This is my 3rd DUHH to myself and it is only 9:18 a.m. So with that obviouosly, I need step by step instructions if anyone would be so kind to help me. Thanks much and good day to all!

OK, each column went alpha order, but how to alpha. entire 2 pages together? Remember I'm in DUHH mode.

I did it! oh yeah its the happy dance! Thanks to all that helped me. Cheers to ya!

Answer 1

Highlight the movie names' column. The next step would be a choice of preference. You can do either...

find a button with the icon with the button that has a writing like "A->Z", and click it.
- OR -
go to Data and click Sort
- OR -
press "Alt+D" and then press "S"

after that .. walla.. its settled... :-). I've had a duhh day before.. it was caused by not-enough-sleep.

Answer 2

1. Highlight the column you want to sort
2. At the top click on Data and Sort
3. Choose how you want to sort the data
4. Click OK

Answer 3

highlight the column with the titles.
then click the A-Z button at the top of the window.

Or hilight the column and go to
Data > Sort...

Answer 4

Highlight the column that contains the field by which you intend to sort. Then:

DATA | SORT | Ascending

Answer 5

the time-eating area is going to be typing out each and all of the titles, yet after that, purely spotlight all of them, circulate to 'tables' and then click 'variety' and carry on with activates. (microsoft word) once you sort them, i might propose doing it in columns