Five Excel Table Shortcuts worth Knowing

 

          Five Excel Table Shortcuts worth Knowing

 

1.    CTRL+T (or: CTRL+L a lesser-known shortcut):
Creates a table

2.    CTRL+SHIFT+8 (CTRL+*):
Selects the entire table,
including the header row and the total row (if present)

3.    CTRL+SHIFT+T (a toggle shortcut):
Adds/removes the total row

4.    CTRL+A:
Selects the entire table, without the total row (if present)

5.    CTRL+SHIFT+drag mouse:
Duplicates the entire table