1. Excel®
1.16. Tables
When you have your data entered and your formulas complete, you can select everything and put it into a table.
This will allow some easy ways to further manipulate your data (filter, sort). This is useful when you have long lists of data that you may have been entering over a period of time.
Select all your data by clicking the last cell or the first cell and dragging diagonally until the entire area is highlighted.
Click on the Insert Bar at the top of the screen and locate the Table icon.
Click on Table.
Excel® will ask you to confirm your selection.
If you have included headers, there is a checkbox to indicate this.