Spreadsheet Tips

Shortcut: Quickly Create Tables

September 30, 2019
A user selects some data and presses Ctrl+T to transform it into a formatted Table.

Excel provides a nifty shortcut for quickly creating tables on the fly.

Just select your data (including headers) and hit Ctrl + T. This works for both Mac and PC and it's relatively easy to remember (which isn't always the case for Excel shortcuts 🙃)