Advance Excel Shortcut Keys for Power Users

Q: Is Flash Fill an advanced Excel shortcut?

Yes. Ctrl + E fills a column by copying a pattern you type once or twice.

Q: Which key copies only the visible rows of a filtered list?

Select them and press Alt + ; before copying.

These advance excel shortcut keys go beyond copy, paste and SUM. Ctrl + T turns a range into a smart table, Ctrl + E runs Flash Fill to split or join text by example, F5 then Special finds blanks, formulas or errors, and Alt + F11 opens the macro editor.

They are the keys used by MIS executives, analysts and accountants who handle large sheets daily. Each section below groups them by job: data, formulas, analysis and automation.

Quick facts

Table
Ctrl + T
Flash Fill
Ctrl + E
Go To Special
F5, then Special
Advanced Filter
Alt, then A, then Q
Name Manager
Ctrl + F3
Macros
Alt + F8, Alt + F11

Advance excel shortcut keys for data

Working with large data
Action	Keys
Create a table	`Ctrl` + `T`
Flash Fill	`Ctrl` + `E`
Advanced Filter	`Alt`, then `A`, then `Q`
Remove Duplicates	`Alt`, then `A`, then `M`
Text to Columns	`Alt`, then `A`, then `E`
Data Validation	`Alt`, then `A`, then `V`, then `V`
Go To Special (blanks, errors)	`F5`, then `Alt` + `S`
Select visible cells only	`Alt` + `;`
Group rows or columns	`Shift` + `Alt` + `Right`

Formula auditing and names

Checking and naming
Action	Keys
Show formulas	`Ctrl` + `
Select cells this formula uses	`Ctrl` + `[`
Select cells that use this cell	`Ctrl` + `]`
Evaluate part of a formula	Select it in the bar, `F9`
Name Manager	`Ctrl` + `F3`
Create names from headings	`Ctrl` + `Shift` + `F3`
Expand the formula bar	`Ctrl` + `Shift` + `U`
Full recalculation	`Ctrl` + `Alt` + `F9`

When using F9 to check part of a formula, press Esc afterwards; pressing Enter would replace that part with its result.

Analysis tools

Pivot and what-if
Action	Keys
Insert PivotTable	`Alt`, then `N`, then `V`, then `T`
Refresh all data	`Ctrl` + `Alt` + `F5`
What-if analysis menu	`Alt`, then `A`, then `W`
Insert chart of selection	`Alt` + `F1`
Chart on its own sheet	`F11`
Conditional formatting	`Alt`, then `H`, then `L`

Pivot details are on pivot table shortcut key.

Advanced filter shortcut key

Advanced Filter extracts records matching several conditions, including OR conditions across columns, and can copy the result to another place. Set up a small criteria range with the same headings above your data, put conditions under them, click in the data, and press Alt, A, Q. Choose the list range, criteria range and Copy to another location. For simple filters, Ctrl + Shift + L is quicker; see Excel filter shortcut.

Macros and automation

Alt + F8 lists macros to run, and Alt + F11 opens the VBA editor to write or edit them. Record a macro from the View tab for repetitive formatting, then run it with a key you assign in the recording box. Save such files as .xlsm, and enable macros only from trusted sources, because macros can carry harmful code.

An MIS executive receives the same raw export every morning. A recorded macro run with Alt + F8 cleans it, a table made with Ctrl + T feeds a pivot, and Ctrl + Alt + F5 refreshes the report in seconds.

When advanced keys do not work

Problems and fixes
Problem	Fix
Ctrl + E fills wrong results	Give two examples so Flash Fill learns the pattern
Alt + F11 does nothing	Macros may be blocked by policy; ask IT
Ctrl + [ selects nothing	The cell has no formula, or refers to another workbook that is closed
F-keys change volume	Press `Fn` too, or turn on Fn lock

Beginners should start with the core Excel list and the formula basics before these.

This site is not affiliated with Microsoft or Apple; this is an independent explanation.

Frequently asked questions

What are advanced Excel shortcut keys?

Keys for tables, Flash Fill, auditing, pivots, advanced filter and macros, beyond the basics.

What is the advanced filter shortcut key?

Alt, A, Q.

Is Flash Fill an advanced Excel shortcut?

Yes. Ctrl + E fills a column by copying a pattern you type once or twice.

How do I trace which cells a formula uses?

Press Ctrl + [.

How do I open the macro editor?

Press Alt + F11.

Which key copies only the visible rows of a filtered list?

Select them and press Alt + ; before copying.