Part of the free Module 1: Excel Shortcut Keys · Lesson 5 of 8 · Full Excel course
Updated on 5 September 2026 · Works in Excel 365, 2021, 2019 and 2016 unless noted.
Excel data shortcuts are the keys that sort, filter, convert a range into a Table, build a pivot table and insert a chart without touching the mouse. The core set is small: Ctrl + Shift + L for AutoFilter, Ctrl + T for a Table, Alt, N, V, T for a pivot table and Alt + F1 for a chart. This lesson covers each group with the Alt sequences that sit behind the Data ribbon.
Sorting from the keyboard
Put the active cell anywhere inside the column you want to sort. Excel works out the surrounding data region on its own, so you do not need to select the whole block first.
- Alt, A, S, A sorts the column ascending (A to Z, smallest to largest, oldest to newest).
- Alt, A, S, D sorts the column descending.
- Alt, A, S, S opens the Sort dialog for multi-level sorts (Region, then Revenue). Use Tab to move between the Column, Sort On and Order boxes and Alt + A inside the dialog to add a level.
- Alt, H, S opens the Home > Editing > Sort & Filter menu, which repeats the same commands plus Custom Sort.
These are press-and-release sequences, not chords. Press Alt, let go, then type the letters one after another. If the sort dialog warns about a header row, tick My data has headers with Alt + H inside the dialog.
Filtering without the mouse
Ctrl + Shift + L switches AutoFilter on or off for the current region. Once the drop-down arrows are visible, move to a header cell and press Alt + Down arrow to open its filter menu. Inside that menu single letters do the work:
| Key inside the filter menu | What it does |
|---|---|
| E | Jumps to the search box; type part of a value and press Enter to keep only matching rows |
| C | Clears the filter from that column |
| S | Sorts A to Z (or smallest to largest) |
| O | Sorts Z to A (or largest to smallest) |
| Space | Ticks or unticks the highlighted item in the checklist; use the arrow keys to move through it |
Two Data-tab sequences are worth memorising alongside these. Alt, A, C clears every filter on the sheet in one go, and Alt, A, T toggles the filter arrows exactly like Ctrl + Shift + L. When you copy a filtered list, select it and press Alt + ; first so that only the visible cells are copied. Hidden rows are otherwise pasted along with the rest.
Excel Tables
A Table gives you structured references, automatic filter arrows and a layout that grows as you add rows. Click inside the data and press Ctrl + T, check that My table has headers is ticked, and press Enter. Inside a Table the selection keys change behaviour:
- Tab in the last cell of the last row adds a new row and carries the formulas and formatting down.
- Ctrl + Space selects the data in the current Table column; press it again to include the header, and a third time to select the whole worksheet column.
- Shift + Space selects the current Table row rather than the whole sheet row.
- Ctrl + A selects the Table data first, the Table with its header row on the second press, and the entire sheet on the third.
- Alt, J, T opens the contextual Table Design tab, where you can rename the Table or pick a style.
- Ctrl + Shift + T switches the Total Row on or off. The ribbon route is Alt, J, T, T.
In the Total Row, press Alt + Down arrow on any cell to choose Sum, Average, Count or another function from the list.
Remove Duplicates and Data Validation
Both commands live on the Data tab, so both start with Alt, A.
- Alt, A, M opens Remove Duplicates. Use Tab and Space to tick the columns that define a duplicate, then Enter. Excel deletes rows permanently, so press Ctrl + Z straight away if the count looks wrong.
- Alt, A, V, V opens the Data Validation dialog. Alt + A moves to the Allow box; type L for List, Tab to Source and enter your comma-separated items or a range.
- On a cell that already has a validation list, Alt + Down arrow drops the list open. Arrow to the value and press Enter.
Pivot table shortcuts
With the cursor inside your data, press Alt, N, V, T in Excel 365 to open the Insert PivotTable dialog (in Excel 2019 and earlier the sequence is Alt, N, V). Press Enter to accept a new worksheet. Once the pivot exists:
- Alt + F5 refreshes the pivot under the cursor; Ctrl + Alt + F5 refreshes every pivot and query in the workbook.
- Alt, J, T opens PivotTable Analyze, and Alt, J, Y opens the pivot Design tab. Both only appear while a pivot cell is selected.
- Alt + Shift + Right arrow groups the selected row or column items into a new group; Alt + Shift + Left arrow ungroups them.
- Ctrl + - hides the selected item from the pivot, the same as unticking it in the field filter.
- Alt, D, P still opens the legacy PivotTable and PivotChart Wizard, which is the only route to a pivot built from multiple consolidation ranges.
To move a field between areas without the mouse, select a field name in the field list, press Shift + F10 (or the context menu key) and choose Add to Row Labels, Add to Values and so on.
Chart shortcuts
Select the data, or a single cell inside it, then press Alt + F1 to insert the default chart on the current sheet, or F11 to create it on its own chart sheet. The default is a clustered column chart unless you have set another type as default from the chart type menu.
For a specific chart type use the Insert tab: Alt, N, C opens the column and bar gallery and Alt, N, R opens Recommended Charts. With a chart selected, Alt, J, C opens the Chart Design tab for layouts, colours and Switch Row/Column, and Ctrl + 1 opens the Format pane for whichever chart element is selected. Arrow keys cycle through chart elements while the chart is active.
Grouping and outlining rows and columns
Outlines let you collapse detail rows under a subtotal. Select whole rows or columns first (Shift + Space or Ctrl + Space, then extend with Shift + Arrow).
| Action | Shortcut |
|---|---|
| Group the selected rows or columns | Alt + Shift + Right arrow |
| Ungroup them | Alt + Shift + Left arrow |
| Hide the detail under the active group | Alt, A, H |
| Show the detail again | Alt, A, J |
| Show or hide the outline symbols in the margin | Ctrl + 8 |
If Alt + Shift + Right arrow asks whether to group rows or columns, you selected a block of cells rather than whole rows. Choose in the dialog or reselect the full rows.
Worked example: sort, filter, Table and pivot in keystrokes only
Type this small sales list into A1:D7 and keep your hands on the keyboard.
| Region | Product | Units | Revenue |
|---|---|---|---|
| North | Laptop | 12 | 9600 |
| South | Monitor | 30 | 5400 |
| North | Monitor | 18 | 3240 |
| East | Laptop | 7 | 5600 |
| South | Laptop | 15 | 12000 |
| East | Monitor | 22 | 3960 |
- Press Ctrl + Home to land in A1, then Ctrl + T and Enter. The range becomes Table1 with filter arrows.
- Move to D1 with Right arrow three times. Press Alt + Down arrow, then O. Revenue is now sorted largest to smallest: South Laptop 12000 sits on top.
- Press Ctrl + Left arrow to reach A1, then Alt + Down arrow, E, type North and press Enter. Only the two North rows remain.
- Press Ctrl + Shift + T. A Total Row appears showing 12840 for Revenue, the SUBTOTAL of the visible rows only.
- Press Alt, A, C to clear the filter, then Alt, N, V, T and Enter. A blank pivot opens on a new sheet with the field list showing Region, Product, Units and Revenue.
- In the field list, tick Region and Revenue with Space (use Tab and the arrow keys to reach them). The result is three rows: East 9560, North 12840, South 17400, total 39800.
- Change any Revenue figure on the first sheet, return with Ctrl + Page Down and press Alt + F5. The pivot updates.
Excel data shortcuts reference table
Alt ribbon sequences do not exist on a Mac, so those rows show a dash; the Mac column is only filled where the mapping is certain.
| Action | Windows | Mac |
|---|---|---|
| Toggle AutoFilter | Ctrl + Shift + L | Cmd + Shift + F |
| Open the filter menu on a header | Alt + Down arrow | Option + Down arrow |
| Sort ascending / descending | Alt, A, S, A / Alt, A, S, D | – |
| Sort dialog | Alt, A, S, S | – |
| Clear all filters | Alt, A, C | – |
| Select visible cells only | Alt + ; | Cmd + Shift + Z |
| Create a Table | Ctrl + T | Cmd + T |
| Toggle the Table Total Row | Ctrl + Shift + T | – |
| Remove Duplicates | Alt, A, M | – |
| Data Validation dialog | Alt, A, V, V | – |
| Insert PivotTable | Alt, N, V, T (365) / Alt, N, V | – |
| Refresh pivot / refresh all | Alt + F5 / Ctrl + Alt + F5 | – |
| Group / ungroup | Alt + Shift + Right arrow / Alt + Shift + Left arrow | – |
| Toggle outline symbols | Ctrl + 8 | – |
| Default chart on the sheet | Alt + F1 | Fn + Option + F1 |
| Chart on a new chart sheet | F11 | Fn + F11 |
| Chart Design tab | Alt, J, C | – |
Tips and common mistakes
- Sorting a single selected column scrambles the rows. Keep the active cell inside the data with nothing selected, or use the Sort dialog with the full region.
- Blank rows or columns break the region. Ctrl + Shift + L and Ctrl + T only pick up the block touching the active cell. Remove the gap or select the full range first.
- Filtered rows still paste unless you press Alt + ; before Ctrl + C.
- F11 and Alt + F1 use the current selection. If the chart looks empty, the active cell was outside the data.
- Alt + Down arrow does nothing on a plain cell. It only opens a list on a header with filter arrows, a validation cell or a Total Row cell.
- The pivot does not change after new data. Pivots are snapshots; press Alt + F5, or build the source as a Table so new rows are included at the next refresh.
- Laptop function keys often need Fn as well, so Alt + F1 becomes Fn + Alt + F1.
Practise these five this week
| Shortcut | What it does | When to use it |
|---|---|---|
| Ctrl + Shift + L | Toggles AutoFilter | Every time you open a list someone else built |
| Alt + Down arrow then E | Opens the filter menu and jumps to search | Finding one customer or product in a long column |
| Ctrl + T | Converts the range into a Table | Before writing formulas or building a pivot |
| Alt, N, V, T | Inserts a pivot table | Summarising by category in seconds |
| Alt + F1 | Inserts the default chart | A quick visual check of any numeric column |
- Open any list you use at work, press Ctrl + Shift + L, filter one column with Alt + Down arrow, E, then clear it with Alt, A, C.
- Convert the list to a Table with Ctrl + T, add a Total Row with Ctrl + Shift + T and change its function from the Alt + Down arrow list.
- Build a pivot with Alt, N, V, T, then select the pivot and press Alt + F1 to add a PivotChart.
Key takeaways
- Most data commands start with Alt, A because they live on the Data tab.
- Ctrl + Shift + L, Alt + Down arrow and the letters E, C, S and O cover almost all everyday filtering.
- Ctrl + T changes how Ctrl + Space, Shift + Space, Ctrl + A and Tab behave, in a helpful way.
- Alt, N, V, T inserts a pivot and Alt + F5 refreshes it.
- Alt + F1 and F11 are the fastest chart shortcuts in Excel.
- Alt sequences do not exist on a Mac; the Ctrl shortcuts mostly map to Cmd.
Related lessons
- Excel Shortcut Keys course hub
- Excel Navigation and Selection Shortcuts
- Excel Formula Shortcuts: F2, F4, F9 and Alt + =
- Excel Alt Key Ribbon Sequences and the Quick Access Toolbar
- Data Filter in Excel (Sort and Filter course)
- How to insert a Pivot Table
- Microsoft Support: Keyboard shortcuts in Excel
Frequently asked questions
What is the shortcut to filter data in Excel?
Press Ctrl + Shift + L with the cursor inside your data. Filter arrows appear on the header row; press the same keys again to remove them. To use a filter, move to a header cell, press Alt + Down arrow, then E to search or the arrow keys and Space to tick items.
How do I sort in Excel using the keyboard?
Click inside the column and press Alt, A, S, A for ascending or Alt, A, S, D for descending. For a multi-level sort press Alt, A, S, S to open the Sort dialog and add levels with Alt + A.
What is the shortcut key for a pivot table in Excel?
In Excel 365 press Alt, N, V, T with the cursor inside the data, then Enter to place the pivot on a new sheet. Older versions use Alt, N, V. After editing the source, Alt + F5 refreshes the pivot and Ctrl + Alt + F5 refreshes every pivot in the workbook.
What is the difference between Alt + F1 and F11 for charts?
Both create the default chart from the selected data. Alt + F1 embeds the chart on the worksheet you are working on, so it sits next to the numbers. F11 creates a separate chart sheet that fills the window, which suits printing or presenting. Either chart can be changed afterwards from the Chart Design tab.
Do Excel data shortcuts work on a Mac?
The Ctrl-based ones mostly do with Cmd instead: Cmd + Shift + F toggles the filter, Cmd + T makes a Table and Cmd + Shift + Z selects visible cells. The Alt ribbon sequences such as Alt, A, S, S do not exist on a Mac; use the menu or the Data ribbon with the mouse instead.
Want the finished version? Ready-made Excel dashboards, trackers and VBA systems are available at NextGenTemplates.com.