View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarbacky Jarbacky is offline
external usenet poster
 
Posts: 1
Default Very Basic SORT question

Hello,

I'm using Excel 2002 but I think this question would apply to all
versions. I am working with 30k names and addresses. I need to sort by
different columns at different times. What can I do to prevent myself
from accidentally only sorting the one column and not all the
columns?

For example, if I want to sort by first name I want to make sure all
the the row info remains intact. I don't want to accidently Change
John Doe to Carl Doe because the only column sorted was the first
name.

Is there one step or setting I can implement or am I stuck being very
careful that I select all columns each and every time.

Thank you in advance for any help.

J