Highlight your data and press Ctrl + T to turn it into a dynamic Excel Table. You’ll instantly get filter buttons, alternating row colours, and automatic range updates when you add new data. Excel tables are also the gateway to many features you may use in the future, such as Power Query, Power BI and other online services.
Before:
After:
If you want more tips on Excel Tables please comment below.