Excel Cheat Sheet

Please find below all the relevant shortcuts that you really need to excel in Excel. Learn them by hard - benefit from the immediate boost of speed.

Please enter **FREE EXCEL CHEAT SHEET** as subject in the contact form below and we will send you the pdf to your email address.

**#QuickerThanTheRest**

Shortcuts
I. NAVIGATION

1) ARROW KEYS	move between cells
PAGE UP / DOWN	move one screen up / down
CTRL + PAGE UP / DOWN	move to previous / next worksheet
CTRL + SHIFT + TAB / F6	switch to previous tab
CTRL + TAB / F6	switch to next tab

2) QUICK
CTRL + ARROW KEYS	jump to the next speedbump
F5	open go-to menu
HOME	move to the first column (left)
CTRL + HOME	move to the first cell (top left)
CTRL + END	move to the last edited cell (bottom left)

II. ENTER DATA

1) ENTER & DELETE
= / + / -	allow for data entry
ENTER	enter data & move to cell below
CTRL + ENTER	enter data & no movement
CTRL + SHIFT + ENTER	enter matrix formula
ESC	abort data entry
DEL	remove cell contents
F2	edit active cell

2) MODIFY (WITHIN A CELL / CELL MODE)
MODIFY (WITHIN A CELL / CELL MODE)	move within the cell
CTRL + ARROW KEYS	jump to the next text
CTRL + SHIFT + ARROW KEY	extend the selection
ALT + ENTER	start new line in the same cell
F4	cycle through dollarization options
BACKSPACE	delete character / selection

3) NOTES & NAMES
SHIFT + F2	Insert / edit cell note
2x ESC	exit cell note
CTRL + F3	set name
F3	insert name into a formula

III. CALCULATIONS

F9	calculate formulas (workbook)
SHIFT + F9	calculate formulas (active sheet)

IV. MODIFY CELLS

1) SELECT, ENTER, DELETE
SHIFT + ARROW KEYS	select cells
SHIFT + SPACEBAR	select row
CTRL + SPACEBAR	select column
SHIFT + F8	add non-adjacent cell or range to selection
CTRL + A	select entire worksheet
CTRL + + / -	insert / delete cells
CTRL + R	fill the cells to the right with the content of the selected cell(s)

2) GROUP
SHIFT + ALT + RIGHT ARROW	group cells
SHIFT + ALT + LEFT ARROW	ungroup cells
CTRL + 9 / + 8	collapse grouped row/ columns
CTRL + SHIFT + 9 / + 8	expand grouped row / columns

V. MENU

1) RIBBONS
ALT	display ribbon (shortcuts)
ESC	move back on the ribbon
CTRL + F1 / + SHIFT + F1	display/hide ribbon
CTRL + SHIFT + U	expand/collapse formula bar

2) DROP-DOWN LIST
ALT + ARROW DOWN	open drop-down list
SHIFT + SPACEBAR	select / unselect items

VI. SHORTCUT BASICS

CTRL + C / X	copy / cut
CTRL + V / + ALT + V	paste / paste special
CTRL + Y / Z	redo / undo last action
ALT + ENTER	repeat last action
CTRL + F / H	find / replace
MENU KEY or SHIFT + F10	right mouse click
CTRL + P	print
F12	save as …
CTRL + F4	close workbook
ALT + F4	close Excel

Downloads

22.12.24

AM Articles

Financial modeling demystified

You want to learn financial modeling? This is how you go about it.

20.12.24

AM Articles

Why should you invest extra effort and time in your modeling skills?

I am convinced that modeling skills are essential for your future success. Let's explore why!

24.06.24

Motivational Videos

Tom Brady - Motivational Speech

Wisdom of the GOAT #12

14.04.24

AM Articles

The Dunning-Kruger Effect: Excel, Expertise, and Self-Perception

Perception vs. performance True performers - Worst performers - YOU?

14.04.24

AM Articles

Is Excel Outdated? A Closer Look at Its Role in Modeling & Data Analysis

Data-driven world vs. Excel - Tool / skill of of choice?

Contact

Get in touch!

We are always here to help. If you have any questions, please don’t hesitate to contact us. For immediate answers to common questions, be sure to check out our FAQs. They might just have what you are looking for!

FAQs