[Excel] linking cells in the same row & sorting

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

  • Votes
  • Date
  • Descending date
  1. Contributor
    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)]
    1. Sure, thank you,

      Isn't there a way to create a rule? Because selecting everything is not practical.
    2. Contributor
      @CharlesRe the forum

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

      Mytå