[Excel] linking cells in the same row & sorting
Charles
-
Raymond PENTIER Posted messages 58548 Registration date Status Contributeur Last intervention -
Raymond PENTIER Posted messages 58548 Registration date Status Contributeur 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.
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.
Isn't there a way to create a rule? Because selecting everything is not practical.
You select the 3 columns of titles and sort them, you just have to follow the steps.
Mytå