Shortcut Keys

This is a list of shortcut keys related to tables.

Ctrl + Spacebar	Selects the entire column when the active cell is not inside a table. Selects the current column (without headers) when the active cell is inside a table. When pressed again the selection will include the table header row. When pressed again the entire column is selected.
Shift + Spacebar	Selects the entire row when the active cell is not inside a table. Selects the current row when the active cell is inside a table. When pressed again the entire row is selected.
Ctrl + Shift + (=)	Inserts one or more columns into a table to the left of the active cell when two cells in a single column. To insert more than one column you need to highlight more vertical cells than horizontal cells.
Ctrl + Shift + (=)	Inserts one or more rows into a table above the active cell. To insert more than one row you need to highlight more horizontal cells than vertical cells.
Ctrl + (-)	Deletes one or more columns from a table. To delete more than one column you need to highlight more vertical cells than horizontal cells.
Ctrl + (-)	Deletes one or more rows from a table. To delete more than one row you need to highlight more horizontal cells than vertical cells.
Ctrl + 0	Hides the columns.
Ctrl + 9	Hides the rows.
Ctrl + Shift + 0	Unhides any hidden columns within the selection. This does not work in Excel 2007.
Ctrl + Shift + 9	Unhides any hidden rows within the selection.
Ctrl + A	Selects the entire worksheet, or the current region if the active cell contains a value, or the whole table (excluding heading) if the active cell is in a table.
Ctrl + Shift + A	Applies a Filter to the current region.
Ctrl + Shift + L	Toggle the display of the AutoFilter drop-downs. Also provides a quick way of clearing all the current filters.
Ctrl + Shift + T	Toggles the display of the total row at the bottom of the table.
Alt + Down Arrow	Display the Filter for the current column.
Alt + Up Arrow	Closes the Filter for the current column.

Ctrl + Spacebar Selects the entire column when the active cell is not inside a table. Selects the current column (without headers) when the active cell is inside a table. When pressed again the selection will include the table header row. When pressed again the entire column is selected.
Shift + Spacebar Selects the entire row when the active cell is not inside a table. Selects the current row when the active cell is inside a table. When pressed again the entire row is selected.
Ctrl + Shift + (=) Inserts one or more columns into a table to the left of the active cell when two cells in a single column. To insert more than one column you need to highlight more vertical cells than horizontal cells.
Ctrl + Shift + (=) Inserts one or more rows into a table above the active cell. To insert more than one row you need to highlight more horizontal cells than vertical cells.
Ctrl + (-) Deletes one or more columns from a table. To delete more than one column you need to highlight more vertical cells than horizontal cells.
Ctrl + (-) Deletes one or more rows from a table. To delete more than one row you need to highlight more horizontal cells than vertical cells.
Ctrl + 0 Hides the columns.
Ctrl + 9 Hides the rows.
Ctrl + Shift + 0 Unhides any hidden columns within the selection. This does not work in Excel 2007.
Ctrl + Shift + 9 Unhides any hidden rows within the selection.
Ctrl + A Selects the entire worksheet, or the current region if the active cell contains a value, or the whole table (excluding heading) if the active cell is in a table.
Ctrl + Shift + A Applies a Filter to the current region.
Ctrl + Shift + L Toggle the display of the AutoFilter drop-downs. Also provides a quick way of clearing all the current filters.
Ctrl + Shift + T Toggles the display of the total row at the bottom of the table.
Alt + Down Arrow Display the Filter for the current column.
Alt + Up Arrow Closes the Filter for the current column.