Excel - Put your data in a table

A simple way to access Excel’s power is to put your data in a table. That lets you quickly filter or sort your data.

Select your data by clicking the first cell and dragging to the last cell in your data.

To use the keyboard, hold down Shift while you press the arrow keys to select your data.

Click the Quick Analysis button Quick Analysis button in the bottom-right corner of the selection.

Selected data with Quick Analysis Lens button visible

Click Tables, move your cursor to the Table button to preview your data, and then click the Table button.

Quick Analysis Tables gallery

Click the arrow Filter drop-down arrow in the table header of a column.

To filter the data, clear the Select All check box, and then select the data you want to show in your table.

Select All box in the Sort and Filter gallery

To sort the data, click Sort A to Z or Sort Z to A.

Sorting commands in the Sort and Filter gallery

Click OK.