Locking Rows for Sorting

[Bob Weaver]

I've got a spreadsheet that is basically a mailing list,
with name, address, city, state and zip columns. I need
to sort the contents by name, and again by zip.

How can I "lock" the rows so that all the cells for each
row will stay together?

TIA,

 

[Chip Pearson]

Bob,

Select all the columns you want to keep together, then do the
sort. Don't select only the column you want to sort by.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Bob Weaver]

Chip,

Somehow, between the last time I tried this (Excel '97?)
and now, things have changed. I just selected the column
I wanted to sort and clicked on the "A-Z" sort button.
Excel warned me about data in adjoining cells and gave me
the option of keeping things together or not.

Really quite simple and sorta elegant! Kudos to the
programmer(s)!

The machine I was working on didn't have Access, or I
would have dumped the sheet into Access and sorted that
way. It's nice to know I don't have to do that!

Thanks,

Bob Weaver