This is a list of all the 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 + L||Toggle the display of the AutoFilter drop-downs. Also provides a quick way of clearing all the current filters.|
|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.|
|Alt + Down Arrow||Display the Filter for the current column.|
|Alt + Up Arrow||Closes the Filter for the current column.|
|Alt + A, A||Sort Ascending|
|Alt + A, D||Sort Descending|
|Alt + A, F||Toggle AutoFilter|
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext