Excel keyboard shortcuts

Format data as a table

Windows
Ctrl+T
Mac
Ctrl+T

Turns the data around the active cell into an Excel table with filters, banded rows and structured references. In a browser Ctrl+T opens a new tab, so practice it in Excel itself.

Your browser keeps this combination for itself, so we explain it here but can't drill it in the page.

More Workbook shortcuts