Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
ECR ECR is offline
external usenet poster
 
Posts: 1
Default Arrange Name,address and other info Alphabetically

I have a sreadsheet with event registation on it ( names, addresses and
telephone ect) the problem is when I put the names in Alphabetical order the
other information does not follow? I have used the function that will help
me once before and just can not remember what it is.....
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,071
Default Arrange Name,address and other info Alphabetically

Make a copy of your file and learn how to sort in the copy file first.
Select the top-left cell of all the data you want to sort. (Click on that
cell)
Scroll down and to the right and find the bottom-right cell of all your
data.
Hold the Shift key down and click on that bottom-right cell.
You have now selected all the data you want to sort.
Click on Data - Sort in the menu that runs across the top of the screen.
Select the column by which you want to sort.
Select whether or not the selected data includes a header row.
Click OK. Done.
HTH Otto
"ECR" wrote in message
...
I have a sreadsheet with event registation on it ( names, addresses and
telephone ect) the problem is when I put the names in Alphabetical order
the
other information does not follow? I have used the function that will
help
me once before and just can not remember what it is.....



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i arrange alphabetically my sheets? nickthebizz Excel Worksheet Functions 1 February 18th 08 01:05 PM
arrange excel by street address instead of alphabetically by name Ray Excel Worksheet Functions 9 June 13th 07 03:33 PM
How do I arrange worksheets alphabetically in Excel? Rosa Excel Worksheet Functions 2 January 12th 07 03:02 AM
How do I arrange the worksheets in my workbook alphabetically? Kiara Parker Excel Worksheet Functions 2 September 5th 06 12:25 PM
How do I arrange entries in a column alphabetically ferrymaster77 Excel Discussion (Misc queries) 1 January 21st 05 11:58 AM


All times are GMT +1. The time now is 04:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"