Another weird but possibly useful quirk of Excel tables… If you have a cell in any subsequent row selected, Ctrl + Space will NOT scroll down. You can press Ctrl + Backspace to scroll up and activate the first cell in the selection/column. If you have the cell in the first row of the body of the table selected, Ctrl + Space will scroll down to the bottom of the table. In the video above I mention a small nuance with Ctrl + Space. The keyboard shortcut for selecting a column in Excel tables is Ctrl + Space. (If you left-click a second time, it will include the header cell in your selection.) Then left-click and it will select all of the cells in that column.

To select a column in an Excel Table, hover over the top half of column's header cell, until your cursor becomes a down arrow. These shortcuts are for both mouse and keyboard and can be used on Windows or Mac. If you work with Excel Tables often, you're going to want to memorize several of the following shortcuts to make your life easier. Table-Shortcuts.xlsx Download Master Excel Tables With These 10 Shortcuts

Create shortcuts for excel 2016