View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
king_reggie king_reggie is offline
external usenet poster
 
Posts: 5
Default keeping the rows together

It didn't happen. the text in column B stays put and only Colum A sorts

"RagDyeR" wrote:

Simply select the *entire* datalist before you sort.

I suggest to *never* use the sort icons on the toolbar.

In fact, I've removed them from the machines of all my users.

XL is right most of the time ... BUT NOT all of the time.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"king_reggie" wrote in message
...
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?