Create a chart of the data in the current range in a separate chart sheet in Excel
In Microsoft Excel, press F11 on Mac, Windows.
EscF1F2F3F4F5F6F7F8F9F10F11F12PrtScScrLkPause
`1234567890-=deleteInsHomePgUp
TabQWERTYUIOP[]\DelEndPgDn
CapsASDFGHJKL;'return
ShiftZXCVBNM,./Shift↑
fnctrloptcmdcmdopt←↓→
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 |
| Open the Quick Analysis options for selected cells | — | CtrlQ |
| Insert a new worksheet | ShiftF11 | ShiftF11 |
| 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 |