Open the Quick Analysis options for selected cells in Excel
In Microsoft Excel, press Ctrl+Q.
WindowsCtrlQ
EscF1F2F3F4F5F6F7F8F9F10F11F12PrtScScrLkPause
`1234567890-=BkspInsHomePgUp
TabQWERTYUIOP[]\DelEndPgDn
CapsASDFGHJKL;'Enter
ShiftZXCVBNM,./Shift↑
CtrlWinAltAltWinMenuCtrl←↓→
See it happen Press the shortcut above, or
More Excel shortcuts: data and worksheets
| Action | Mac | Windows |
|---|---|---|
| Turn AutoFilter on or off for the selected range | ShiftCmdF | CtrlShiftL |
| Insert a new worksheet | ShiftF11 | ShiftF11 |
| Create a chart of the data in the current range in a separate chart sheet | F11 | F11 |
| Create an embedded chart of the data in the current range | — | AltF1 |
| Freeze panes | — | AltW,F,F |
| Open the Macro dialog | OptionF8 | AltF8 |
| Open the Visual Basic for Applications editor | OptionF11 | AltF11 |
| Select all objects on a worksheet when an object is selected | ShiftCmdSpace | CtrlShiftSpace |