View original (French)

[Excel] linking cells in the same row & sorting

Charles -  
Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   -
Hello,

I have a question from a complete beginner. I have a table with data. Not knowing much about Excel, I placed customer names in column 1. In front of these customer names, I put information regarding them: payment, etc. So on the first line we will see, for example:
MARTIN | PAYMENT | DIRECT DEBIT
MICHEL | PAYMENT | CHECK

And so on.

The problem I have is that if I sort alphabetically by column 1 to find a customer, the information in the following columns is not sorted. It seems there is a missing "link" between the cells in the same row. Is there a simple solution?

Thank you in advance!

I am using Microsoft Excel 2007.

2 answers

  1.
    Mytå Posted messages 4246 Registration date   Status Contributor Last intervention   958
     
    Hello forum

    Select the 3 columns of your table and perform the sort on the first one

    Mytå
    Thank you for responding to your question, we are not robots...
    Installed versions [MsProject 2003(FR), Excel 2003-2007(FR)]
    3
    1. Charles
       
      Sure, thank you,

      Isn't there a way to create a rule? Because selecting everything is not practical.
      0
      1. Mytå Posted messages 4246 Registration date   Status Contributor Last intervention   958 > Charles
         
        Re the forum

        You select the 3 columns of titles and sort them, you just have to follow the steps.

        Mytå
        0