Forum Discussion
Excel
Bj je souhaite que dans un tableur excel quand je tape le nom de famille toutes les colonnes suivantes qui ne changent pas pour ce nom là, s'affiche sans que je doive tout retaper à chaque encodage de cette personne. Donc que son prénom, date de naissance, n° de compte, adresse mail, ... s'affiche juste en tapant le début de son nom de famille.
Donc je tape "Lai..." pour mon nom qui est Laitem et isabelle, 20/01/1992, ... s'affiche de suite ... et le reste des infos je les complète moi même vu qu'elles sont différentes du 1er encodage, ...
J'espère que je suis claire ... c'est donc un genre d'affichage instantané mais de toutes les colonnes inchangées par rapport au 1er encodage et pas que la colonne en question ...
2 Replies
Hi Ila1972,
you can use a combination of the Data Validation and AutoFill features in Excel.
Create a table with the following columns:
- Name
- First name
- Date of birth
- Account number
- Email address
Enter the data for the first row of the table.
In the Name column, select the cell that contains the first name.
On the Data tab, click the Data Validation button.
In the Data Validation dialog box, click the List tab.
In the Allow list, select List from a range of cells.
In the Source box, enter the range of cells that contains the names you want to use.
Click OK.
Now, when you select the cell that contains the name, a drop-down list will appear. You can select a name from the list, and the rest of the columns will be automatically populated with the corresponding data.
To use the AutoFill feature, select the entire first row of the table and drag the fill handle down to the last row of the table.
The rest of the rows will be automatically filled in with the corresponding data.
Some additional notes:
- You can use the Data Validation feature to create a drop-down list of any type of data, such as numbers, dates, or text.
- You can use the AutoFill feature to fill in a range of cells with the same data.
- You can use the Conditional Formatting feature to highlight cells that contain specific data.
Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.If the post was useful in other ways, please consider giving it Like.
Kindest regards,
Leon Pavesic
(LinkedIn)- Ok many thanks, I try and come back to say it's ok or not ...
