Excel Tables are a powerful feature that automatically manage your data ranges, apply formatting, and add filter controls. They make data analysis much faster and more efficient.
Le faire avec l'IASelect your data range
Click and drag to select the range of cells that contains your data, including the headers.
Use the keyboard shortcut
Press 'Ctrl + T' on your keyboard to open the 'Create Table' dialog box.
Confirm the table range
Ensure the 'My table has headers' checkbox is checked if your data has column titles, then click 'OK'.
Tables offer automatic formatting, built-in filtering, and structured references that update automatically when you add new data.