Resort Data In Spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

travelersway - 30 Dec 2005 19:40 GMT

I have a spreadsheet that is used for a mail merge with names and
addresses.

Column A - Names
Column B - Number & Street
Column C - City
Column D - State
Column E - Zip Code

I want to view the data by Number & Street for another application. Is
there a way to resort the data by Number & Street and have the sort
change all the data to corispond?

Your help appreciated.

Signature

travelersway

Reply to this Message

Jacob_F_Roecker - 30 Dec 2005 20:26 GMT

Try using Auto Filter

Select your top row then

Data | Filter | Auto Filter

This will put a drop down arrow on each column of your top row. You'll find
that you have the ability to sort it a number of different ways.

I hope this helps

jacob@roeckerfam.com

> I have a spreadsheet that is used for a mail merge with names and
> addresses.
[quoted text clipped - 10 lines]
>
> Your help appreciated.

Reply to this Message

gls858 - 30 Dec 2005 20:34 GMT

> I have a spreadsheet that is used for a mail merge with names and
> addresses.
[quoted text clipped - 10 lines]
>
> Your help appreciated.

click on the small square above row 1 and to the left of col a
this will select the entire sheet. Then on the menu bar select
Data > Sort the rest is pretty easy.

gls858

Reply to this Message