About This Shortcut This shortcut will opt for entire column of the current selection. If the current selection spans multiple columns, all columns that intersect the current selection will be selected. Related videos The videos below demonstrate this shortcut.
About This Shortcut This shortcut will pick the entire pivot table, excluding report filters. How to copy a pivot table without the data Why pivot tables? How to add unique count to a pivot table Two-way summary with dynamic arrays
About This Shortcut This shortcut will opt for entire row of the current selection. If the current selection spans multiple rows, all rows that intersect the selection will be selected. Related videos The videos below demonstrate this shortcut.
About This Shortcut This shortcut will snag the entire worksheet. Shortcuts for selecting cells Shortcuts for selecting cells in Excel
Alt + F3 works in Windows only and it appears to have been introduced in Excel 2016. On the Mac there is no equivalent shortcut. However, you’re free to use another shortcut, F6, to cycle through “panes”. It may take more than one click, but F6 will snag the name box eventually.
About This Shortcut Use this keyboard shortcut to select additional non-adjacent worksheets. you’ve got the option to select as many additional worksheets as you like. Related videos The videos below demonstrate this shortcut.
Related videos The videos below demonstrate this shortcut. Shortcuts for editing cells
Related videos The videos below demonstrate this shortcut. Shortcuts for editing cells
About This Shortcut Inside a cell, this shortcut will extend the selection by one word to the left each time the left arrow key is pressed.
Related videos The videos below demonstrate this shortcut. Shortcuts for editing cells
Note that this shortcut depends on the location of the active cell in a selection. Related videos The videos below demonstrate this shortcut. Shortcuts for Go To Special
About This Shortcut This shortcut selects the data area of a table, when the cursor is in an Excel table. Behavior changes as the shortcut is used more than once: Related videos The videos below demonstrate this shortcut. 10 pivot table problems and easy fixes How to update a pivot chart How to set a default custom table style What is an Excel Table How to use VLOOKUP with a table How to calculate and highlight expiration dates
Behavior changes as the shortcut is used more than once. First time: column data. Second time: column data + column header. Third time: entire worksheet column. Related videos The videos below demonstrate this shortcut.
