help with a certain way of setting up a spreadsheet.

[mily]

okay, hope I'm posting in the correct place.

Basically, I'm trying to set up a database type of thing and I'm having a little trouble working it all out. I'll do my best to explain heh..

Lets say that I've got a set of books, and I want to set up columns for Author, Title, Genre, date it was published etc and I want to be able to organize them into an A-Z each time I add a new entry. However, I want each line of the columns to stay matched up, so when I'd organize them all into order the Author and Title would stay matched up rather then becoming jumbled.

I also want to be able to order it by different factors, so say I want to put the Titles a-z, or I wanted to sort them out into the correct date, but for everything to stay paired up.

I really hope this made sense..my excel knowledge is very limited and being able to do this would be a big help!

thanks!

[Ron Coderre]

If you already know how to sort....but, you are sorting only one column...

Select your entire data list first....Then, when you sort a column,
the other corresponding data will sort, too.

Tip: Here's a shortcut for selecting your data list:
• Click on ony cell in the list
• Then use one of these key combinations to select the range:
CTRL+*....(the asterisk on the numeric keypad)
or
CTRL+SHIFT+8
or
CTRL+SHIFT+SPACEBAR

Does that help?
Post back if you have more questions.