Select the data range and press Ctrl+T (Windows) or Cmd+T (Mac). Excel will instantly format it as a "smart" table.

This is not just for looks: the table automatically expands, adds filters, and allows you to quickly summarize data. The main thing is to avoid empty rows and merged cells inside.

This format is the foundation for automation. When you have a lot of data, knowledge of the basics of working with pivot tables in Excel will be useful for analysis.

🔗 Source: excel.rf