Create Table
Windows
Ctrl+T
Turns the selected range into a table.
Excel Create Table Shortcut for Windows, Mac & Web
Turns the selected range into a table. Here's the keyboard shortcut for every version of Excel, plus other ways to do it.
Quick Answer
- Windows
- Ctrl+T
- Mac
- Cmd+T
- Web
- Ctrl+L
How to create table in Excel with the keyboard
- Open Excel and go to where you want to create table.
- Press Ctrl + T on Windows or Cmd + T on Mac.
Excel Create Table Shortcut for Windows
Press Ctrl + T.
Excel Create Table Shortcut for Mac
Press Cmd + T.
Excel Create Table Shortcut for Excel Web
Press Ctrl + L.
Related Shortcuts
Frequently asked questions
What is the Excel create table shortcut?
On Windows, press Ctrl + T. On a Mac, press Cmd + T.
Is there a Mac shortcut to create table in Excel?
Yes: Cmd + T.
Does it work in Excel for the web?
Yes: Ctrl + L.
Not yet verified · Last reviewed: not yet reviewed · Microsoft's official shortcut list