-- SHORTCUTS:

1) Press ALT + A + C

2) ALT + S for sorting

3) ALT + T for creating a filter.

-- You have to follow these steps for Sorting

1) Select a column of alphanumeric data in a range of cells.

2) On the Home tab, select the Sort & Filter option and do one of the following:

- To sort in ascending alphanumeric order, click Button Image Sort A to Z.
- To sort in descending alphanumeric order, click Button Image Sort Z to A.

-- For Filtering, follow the given steps:

1) Click on any cell in your spreadsheet.

2) Select the Home tab.

3) Under the Editing group, press the Sort and Filtering button and select the Filter button.

4) Drop-down menus will appear next to each cell heading.

5) Clicking on any drop-down menu will provide you with options for filtering.