📊Excel Shortcut

AutoSum

Detailed guide to use "AutoSum" in Excel

Shortcut Keys

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

Windows

Alt+=
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: Alt+=

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+Shift+T

In Action

This shows a representative pseudo-Excel example of what happens after the shortcut runs. The actual Excel UI may differ slightly.

Auto-playing example
Active: D6Selection: D6Sheet: Sheet1Step 1/3

You can scroll the sheet horizontally

↶↷BIUGeneral
Name Box
D6
Formula Bar
fx
◢
A
B
C
D
1
Item
Qty
Price
Total
2
Pen
12
80
960
3
Pad
6
120
720
4
File
4
300
1200
5
Box
3
450
1350
6
Memo
Ready
2026-03-28
Sheet1
Ready100%

Basic Info

Category
Editing
Difficulty
★★☆(Intermediate)

How to Use

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

Practice

Practice this shortcut and build reliable muscle memory.

Start Shortcut PracticeSee Practice ModesStart Function Practice

Usage Tip

Insert a SUM formula automatically.

Related Shortcuts

Toggle Reference Type

Similar function
F4

Insert Current Date

Same category
Ctrl + ;

Edit Cell

Same category
F2

New Line in Cell

Same category
Alt + Enter

Repeat Last Action

Same category
F4

Insert Current Time

Same category
Ctrl + :

Format Cells Dialog

Same category
Ctrl + 1

Apply Comma Style

Same category
Ctrl + Shift + 1

More In This Category

Clear Cell Contents

Delete

Redo

Ctrl + Y

Underline

Ctrl + U
View Full Shortcut List

FAQ

What is the shortcut for AutoSum?

Windows: Alt+=. Mac: Cmd+Shift+T.

How do I use AutoSum?

Use it beside or below a range when you want totals inserted quickly.

What shortcuts should I practice after AutoSum?

Practice cell editing, AutoSum, and formula view next and you can move through common Excel work much faster.

Where can I practice AutoSum?

Use the page button to start a focused drill right away. If you switch to full practice, you can review cell editing, AutoSum, and formula view in the same flow.

What is the action preview for AutoSum?

A visual pseudo-Excel simulation showing the before and after state when you run the shortcut.

← Back to ListExcelGym Home