Hello,

I am not sure if this is the right category to post, but I did search first before i posted.

I have not touch my Microsoft Excel 2007 in 4-5 years of so and I am stumped.
I also tried watching tons of youtube help videos and tutorials but still cant seem to find an answer I am looking for.

I entered names into row 2 and columns a-g that i want as title for each column but I cant seem to make it work.
What i mean by that is I have the words there and then I enter data in each row below each column from rows 4-30 and columns a-g.
I want to be able to sort my entered row data without sorting the names in row 2 but I don't remember how to accomplish that.
I am making a book list so i will always be adding new rows that I will want to sort to put in alphabetical order but the row 2 names I made keep being sorted.

Now here is the question(s):

How do I set the row 2 names so they are not sorted as I want row 2 as a title/header (terms may be wrong)? I tried define name and that did not work and i simply cant remember how to accomplish this.

Next question is where do I find a decent video tutorial for re-learning Excel 2007? I find youtube some help but want a more course type help videos.

Thanks in advance
Gren