Excel Tables are one of Excel’s most powerful features for working with data.
To toggle filters, use Ctrl-Shift-L in Windows, and use Command-Shift-F on a mac.
A number of shortcuts for selecting cells take advantage of the table structure.
you’re able to a select table row, using Shift + Space.
And a table column, with Control Space.
Both shortcuts work with multiple cells selected.
Insert rows and columns with control-shift + in Windows, Control-I on a Mac.
Delete rows and columns in a table with Control -.
Tables have very good support for drag and drop.
I can select one or more rows, then drag directly to a new location.
This is also a good way to duplicate rows in a table.
When a table has filters, you could activate a filter using Alt + down arrow.
In Windows, you get a few more shortcuts after you snag an open filter.
This is really a handy way to check that that you’re looking at all data.
