View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Sameer Nagi[_2_] Sameer Nagi[_2_] is offline
external usenet poster
 
Posts: 15
Default keeping the rows together

select the entire worksheet by "ctrl+A".
select Data-Sort
Select "Column A" in Ascending order...ensure that in "Options" it is
selected to be columns and NOT rows...

Let us know if this also doesnt work...

"king_reggie" wrote:

I'm Creating a directory based on new clientele and i want it alphabetical.
now my problem is tha if i enter for example in A1 Kim Smith, B1 111 rogers
rd, C1 555-555-5555, then continue with other names addresses and phone
numbers, how can i get all the info per row to stay together when i sort
column A? Is there a way to make the each column in the row work as one when
it sorts?