Excel Keyboard Shortcuts: The Most Useful Shortcuts for Every Skill Level

Key Takeaways

• Keyboard shortcuts dramatically speed up your workflow by keeping your hands on the keyboard instead of reaching for the mouse.
• This guide organizes the most useful Excel shortcuts by skill level (basic, intermediate and advanced) so you can learn progressively.
• Most Excel shortcuts work on both Windows and Mac with minor modifier key differences (Ctrl on PC = Cmd on Mac).
• Memorizing even 10-15 shortcuts can save you time — potentially hours per week on repetitive Excel tasks.

Why Excel Keyboard Shortcuts Save You Time

It's not an exaggeration to say that Excel is the most-used business software tool in the world. Some have even described it as the "Swiss Army Knife" of business analytics, but whether you use the blade or the spork, all users benefit from learning keyboard shortcuts that keeps their hands on the keyboard.

Studies on workplace productivity consistently show that switching between the mouse and keyboard is one of the biggest hidden time drains in spreadsheet work. Even shaving a few seconds off each action adds up fast when you're repeating it dozens or hundreds of times a day. Learning a curated set of Excel shortcuts can realistically save you several hours per week, and the payoff only grows as the commands become second nature.

While you can find a complete list of Excel Keyboard Shortcuts on Microsoft's website, you probably don't want to spend hours looking through the whole thing to pick one to learn next. So we've given you a starting place and organized the most useful shortcuts to start with:

Windows vs. Mac: Understanding Modifier Keys

Nearly every shortcut in this guide works on both Windows and Mac. The main difference is which modifier key you press. Here's a quick translation table so you can follow along on either platform:

All shortcuts in this guide are shown in Windows format. If you're on a Mac, swap Ctrl for Cmd in most cases and you'll be set. Where a Mac shortcut differs more significantly, we've noted it. Keep in mind that some laptops require you to hold the Fn key to use function keys (F1-F12), which we cover later in this guide.

Keyboard Shortcuts for Basic Excel Users

Universal Shortcuts

Several common tasks have nearly universal application. In fact, these eight keyboard commands are available in almost all software packages used today.

• Ctrl+S = Saves your file
• Ctrl+F = Opens the Find tool
• Ctrl+C = Copies selected content, then...
• Ctrl+V = Lets you paste that content elsewhere
• Ctrl+X = Copies selected content and deletes it when pasted into its new location
• Ctrl+Z = Undoes the last action you just did, then...
• Ctrl+Y = Lets you redo the last action you just undid
• Ctrl+A = Selects "all" the content in the worksheet or cell that you have selected

Formatting Shortcuts

Quickly apply the most common text formats so that you can spend more time analyzing. They are also usually available in software that includes text.

• Ctrl+B = Applies the Bold format
• Ctrl+I = Applies the Italic format
• Ctrl+U = Applies the Underline format

At risk of sounding pushy, everyone should commit these basic shortcuts to muscle memory and use them often in all your applications.

Keyboard Shortcuts for Intermediate Excel Users

If you've mastered the basic shortcuts even before you open Excel for the first time, then you can start working on intermediate Excel shortcuts and avoid having to re-learn how to perform common repetitive tasks.

Navigation Shortcuts

As you enter data, you will move your curser between cells, rows, columns and even worksheet tabs. These shortcuts get you to where you want to work without taking precious seconds to move your hand to a mouse.

• Tab = Moves to the next cell
• Shift+Tab = Moves to the previous cell
• Arrow Keys = These often-unused buttons on your keyboard can be put to great use in Excel; use them to navigate stepwise between cells in any direction
• Ctrl+Arrow Keys = Jumps your cursor to the edge of your data in the direction of the arrow
• Ctrl+Home = Moves your cursor to the beginning of a worksheet
• Ctrl+End = Moves your cursor to the lowest row of the rightmost column of filled cells
• Ctrl+Page Down = Moves your cursor to the next worksheet tab
• Ctrl+Page Up = Moves your cursor to the previous worksheet tab

Selection Shortcuts

Many tasks involve selecting multiple cells. These shortcuts keep your hands on the keyboard (mostly) while doing so.

• Ctrl+A = Selects the entire active worksheet, even unfilled cells
• Ctrl+Spacebar = Selects the whole column
• Shift+Spacebar = Selects the whole row
• Ctrl+Shift+Arrow Keys = Selects all cells from the selected cell to the end of the filled row or column in the direction of the arrow
• Ctrl+Click = Selects individual, non-adjacent cells

Ribbon Tab Shortcuts

Quickly open the Ribbon you need with these keyboard commands.

• Alt+F = File menu
• Alt+H = Home tab
• Alt+N = Insert tab
• Alt+P = Page Layout tab
• Alt+M = Formulas tab
• Alt+A = Data tab
• Alt+R = Review tab
• Alt+W = View tab

Keyboard Shortcuts for Advanced Excel Users

At the advanced level, you are most likely specializing in tools and procedures that are specific to your field or industry. A command you use daily might be something another user has never even clicked before. Therefore, learning advanced shortcuts is more about identifying what you do frequently and then finding the ones that apply to you. Here are a handful of shortcuts that benefit any Excel power user.

• Alt+H+A+C = Applies center alignment to cell contents
• Alt+H+B = Applies a border to the cell
• Ctrl+; = Inserts the current date
• Ctrl+Shift+: = Inserts the current time
• Ctrl+K = Inserts a hyperlink
• Ctrl+Shift+$ = Applies the currency format
• Ctrl+Shift+% = Applies the percent format
• Ctrl+9 = Hides Row
• Ctrl+Shift+9 = Unhides Row
• Ctrl+0 = Hides Column
• Ctrl+Shift+0 = Unhides Column
• Ctrl+Alt+V = Opens the Paste Special dialog window

How to Add Shortcuts to Your Workflow

Learning even a handful of Excel shortcuts at a time compounds into significant time savings. The key is building muscle memory gradually rather than trying to memorize everything at once. There are (non-scientifically) two phases of learning shortcuts: First is remembering what to type, second is being able to do it without even thinking. Here are some tips and tricks for tackling the first phase. And then luckily — or not so luckily, depending on your mood — repetition is what gets you to the second!

• Create a cheat sheet — Choose the shortcuts you want to learn and print them out or keep a notes window open so they are always in front of you. Refer to the sheet when you are performing a task that has a shortcut. DON'T print the entire set of available shortcuts! A giant list of commands you will never use will discourage and slow you down. If this method works for you, print short lists at a time and then start a new one once the last list is committed to muscle memory.
• Choose a "learning project" — Identify a project or recurring task that offers many repetitions of one or at most two shortcuts you want to learn. When you sit down to work, commit to ONLY using the shortcut each time the task comes up. Post a sticky that says "SHORTCUT" or has the command on your monitor to remind you. Plan for being slower at the beginning, but you will quickly gain speed as you repeat the command.
• Use a practice tool — If you learn best when you don't also have to think about work, try a keyboard practice tool to drill the keystrokes.
• Use Mnemonics — Words, phrases, or images can help you learn information that is otherwise abstract. To help you remember Ctrl+C, Ctrl+V for copy/pasting information, you might think or even say out loud: "Create a Copy — C for Copy, V for Paste". For Ctrl+X, you could say "X that out before I paste it."
• Use Excel's "Tell Me" feature — Press Alt+Q to open the Tell Me search bar at the top of the ribbon. Type any command you'd normally click through menus to find, and Excel will show you the action along with its shortcut key. This is one of the best ways to discover new shortcuts for tasks you already do regularly.

Over time, continue to remind yourself of the commands as you go. Don't give in to the temptation to just grab the mouse because it's faster for now. You're spending time now to save more time later. Keep that excel shortcut cheat sheet handy for the shortcuts that you only use "now and then."

Function Keys in Excel: What F1 Through F12 Do

One of the most common questions about keyboard shortcuts in Excel is what the function keys across the top of your keyboard actually do. Each one triggers a specific command, and a few of them are genuinely useful time-savers once you know they exist. Note that on many laptops, you may need to hold the Fn key to activate these rather than the default media controls.

• F1 = Opens the Help pane
• F2 = Edits the active cell (places your cursor in the formula bar)
• F3 = Opens the Paste Name dialog (useful when working with named ranges)
• F4 = Toggles between absolute and relative cell references in a formula (e.g., A1 to $A$1). Outside of a formula, F4 repeats the last action.
• F5 = Opens the Go To dialog, letting you jump to a specific cell or range
• F6 = Switches between the worksheet, ribbon, task pane and status bar
• F7 = Launches Spell Check
• F8 = Enables Extend Selection mode so you can expand a selection using arrow keys without holding Shift
• F9 = Calculates all worksheets in all open workbooks (helpful when automatic calculation is turned off)
• F10 = Activates Key Tips on the ribbon (similar to pressing Alt)
• F11 = Creates a chart from selected data on a new chart sheet
• F12 = Opens the Save As dialog

F2 and F4 tend to be the most frequently used function keys for everyday Excel work. F2 saves you from double-clicking a cell to edit it, and F4 is indispensable when building formulas with mixed references.

Troubleshooting: When Excel Shortcuts Don't Work

If you press a shortcut and nothing happens (or the wrong thing happens), don't assume you have the wrong command. There are several common reasons keyboard shortcuts fail in Excel:

• Fn key lock on laptops: Many laptops default the top row of keys to media controls. If your function keys aren't responding, try holding Fn while pressing the key, or toggle the Fn Lock setting in your BIOS or keyboard settings.
• Num Lock is off: Shortcuts that use number pad keys (like Ctrl+0 to hide a column) may not work if Num Lock is disabled. Check the Num Lock indicator on your keyboard.
• Excel for the web behaves differently: Browser-based Excel shares many shortcuts with the desktop app, but some are intercepted by the browser itself (for example, Ctrl+W closes a browser tab instead of closing a workbook). If a shortcut isn't working in your browser, try the desktop application.
• Third-party software conflicts: Screen recording tools, accessibility software and clipboard managers sometimes intercept key combinations before Excel receives them. If a shortcut suddenly stops working, check whether a recently installed program is the cause.
• Mac-specific differences: A few Windows shortcuts have no direct Mac equivalent, particularly those that use the Alt key for ribbon navigation. On Mac, use the Control key (not Cmd) for some menu-access shortcuts, and check Microsoft's Mac-specific shortcut list for edge cases.

Take Your Excel Skills Further

Keyboard shortcuts are a great foundation, but they're just the beginning of what you can do with Excel. Pryor Learning offers live and On-Demand Excel courses covering formulas, PivotTables, data visualization, advanced analytics and more. Whether you're looking to build confidence with the basics or tackle complex financial models, structured training can accelerate your growth far beyond what self-study alone provides.