📊Excel Shortcut

Create Table

Detailed guide to use "Create Table" in Excel

Shortcut Keys

The highlighted keys show where to press. Press the required keys together.

Windows

Ctrl+T
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
⌫
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
↩
⇧
Z
X
C
V
B
N
M
,
.
/
⇧
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Home
Del
End
PgUp
PgDn
↑
←
↓
→

Windows: Ctrl+T

Mac

⌘+T
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
⌫
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
↩
⇧
Z
X
C
V
B
N
M
,
.
/
⇧
⌃
⌘
⌥
⌥
⌘
Fn
⌃
↑
←
↓
→

Mac: Cmd+T

Basic Info

Category
Other
Difficulty
★★★(Advanced)

How to Use

  1. 1Select the target cell/range if needed
  2. 2Press the highlighted keys shown above together
  3. 3Create Table is executed

Practice

This shortcut conflicts with browser-reserved keys here, so this page shows the reference only.

Browse Browser-Safe PracticeStart Function Practice

Usage Tip

Convert the selected range into an Excel table.

Related Shortcuts

Insert New Worksheet

Same category
Shift + F11

New Workbook

Same category
Ctrl + N

Open Workbook

Same category
Ctrl + O

Save

Same category
Ctrl + S

Save As

Same category
F12

Print

Same category
Ctrl + P

Close Workbook

Same category
Ctrl + W

Insert Cells/Rows/Columns

Same category
Ctrl + Shift + +

More In This Category

Open Workbook

Ctrl + O

Print

Ctrl + P

Save

Ctrl + S
View Full Shortcut List

FAQ

What is the shortcut for Create Table?

Windows: Ctrl+T. Mac: Cmd+T.

How do I use Create Table?

Use it on the active workbook or selection to keep routine work keyboard-first.

What shortcuts should I practice after Create Table?

Practice save, copy, and paste next and you can move through common Excel work much faster.

Where can I practice Create Table?

This shortcut conflicts with browser keys and has no individual drill. Open the practice list to choose a supported shortcut.

← Back to ListExcelGym Home