Keeping records together on a spreadsheet

[reblynferg]

I created a spreadsheet with a lot of data on it that I need to sort. My question is how do I keep ROWS together when I sort the column. I created a row with first, last names, addresses etc. and now I need to sort the town names and still keep the info together for each person. Is there a way I can do this? Should I have done something different?

[RickRandom]

Not quite sure how your data is arranged, but avoid using the A-Z buttons when sorting, they don't always work as you might expect. Always select the whole range you want to sort, then from the menu, Data, Sort, then select the column you want to sort on, select whether you have column headings or not, then sort.

Let us know how you get on.

[reblynferg]

Yay! That worked! Thank you so much! I was beating my head against the wall because I have over 400 records that I entered and needed to use.