top of page
Image by Jess Bailey

Get finance and accounting tips delivered right to your inbox

Excel Shortcuts Cheatsheet

excel shortcuts cheatsheet


Are you ready to become an Excel pro? Imagine zipping through your spreadsheets like a master musician playing a symphony. Today, I'll share an essential Excel shortcuts cheatsheet that will boost your speed and productivity.


You might be thinking: "How can I remember all these shortcuts?" Don't worry—it's easier than it sounds! I'll show you a simple way to learn each one quickly.


Before we start, download the infographic and the Excel file we'll be using below. These tools will help us along the way.



You might also wonder: "Do I really need keyboard shortcuts? Can't I just use the mouse?" The answer is yes, you do need them! Using shortcuts will make you much faster in Excel. Imagine being on a call with a client and effortlessly navigating your work with just your keyboard. It feels amazing and makes you look like a pro.


Set your mouse aside (you won't need it much). Your keyboard is about to become your new best friend. Let's dive into this Excel shortcuts cheat sheet and unlock your full potential.





What We're Going to Talk About


The Easy Ones 😃


These shortcuts can be found across almost all applications.


Functionality
Shortcut

Copy

CTRL + C

Cut

CTRL + X

Paste

CTRL + V

Select All

CTRL + A

Save Workbook

CTRL + S

New Workbook

CTRL + N

Underline

CTRL + U

Open Workbook

CTRL + O

Print Workbook

CTRL + P

Find

CTRL + F

Undo

CTRL + Z

Redo

CTRL + Y

Bold

CTRL + B

Italic

CTRL + I


The Essentials


These are the shortcuts you need to know.


Functionality
Shortcut

Jump to next / last active cell

CTRL + Arrow key

Highlight Cells

SHIFT + Arrow key

Select Row

SHIFT + Space

Select Column

CTRL + Space

Insert Row/Column

CTRL + +

Delete Row / Column

CTRL + -

Remove Gridlines

ALT + W + VG

Ungroup Cells

ALT + A + U

Remove Duplicates

ALT + A + M

Autosum

ALT + =

Open cell dialogue box

CTRL + 1

Fix References

F4

Insert Cut Cells

ALT + H + I + E

Add Data Validation

ALT + A + V + V

Freeze Panes

ALT + W + F + F

Create Table

CTRL + T

Create Filter

ALT + H + S + F

Change Windows

ALT + W + W

Group Cells

ALT + A + G

Autofit Cells

ALT + H + O + I

Define Name

ALT + M + M

Access Dropdown

ALT + Arrow Down

Edit Cells

F2

Go To

F5


Border 🔲


Tap AlT + H + B to change borders


Functionality
Shortcut

All

ALT + H + B + A

None

ALT + H + B + N

Left

ALT + H + B + L

Right

ALT + H + B + R

Top

ALT + H + B + P

Down

ALT + H + B + O

Outer Edge

ALT + H + B + S

Change Color

ALT + H + B + I


Paste Special 📄


Tap AlT + H + V to paste special


Functionality
Shortcut

Format

ALT + H + V + R

Value

ALT + H + V + V

Transpose

ALT + H + V + T

Picture

ALT + H + V + U

Formula

ALT + H + V + F


Cell Formatting✒️


Tap ALT + H to control cell formatting


Functionality
Shortcut

Change Font Color

ALT + H + F + C

Change Background Color

ALT + H + H + H

Merge & Center

ALT + H + M + C

Wrap Text

ALT + H + W

Indent

ALT + H + 6

Decrease Indent

ALT + H + 5

Make Bigger

ALT + H + F + G

Make Smaller

ALT + H + F + K

Format Percentage

ALT + H + P

Format Number

ALT + H + K

Format Short Date

ALT + H + N + S

Align Left

ALT + H + A + L

Align Center

ALT + H + A + C

Align Right

ALT + H + A + R

Align Top

ALT + H + A + T

Align Middle

ALT + H + A + M

Align Bottom

ALT + H + A + B

Change Column Width

ALT + H + O + W

Change Row Height

ALT + H + O + H

Format Currency

ALT + H + A + N


Now you know my method for mastering the Excel shortcut cheatsheet. Remember, practice makes perfect. Initially, using your keyboard might take longer as you build muscle memory, but with consistent practice, these shortcuts will become second nature. Soon, you'll be conducting an Excel symphony like a modern Beethoven.


Keep practicing, and watch your efficiency soar!




 

Josh (Your CFO Guy)

Thanks for reading my article . My goal is to help you grow in your career with proper Finance and Accounting.

If we're not already connected on Social media, let's get connected and send me a message to say hi. I promise to respond

171 views

Related Posts

See All

留言


bottom of page