Resort Data In Spreadsheet

[travelersway]

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.

 

[Guest]

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

(e-mail address removed)

 

[gls858]

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.

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