Microsoft Excel Shortcuts: 50 Time-Savers I Use Every Day (2026)

A few years ago, I watched a coworker finish a sales report in 15 minutes. The same report took me two hours. We had the same data. We used the same Excel. So what was the difference?

She used keyboard shortcuts. I used the mouse.

That one moment changed how I work. Over the next few months, I tested every shortcut I could find. I kept the ones that saved real time. I dropped the ones that sounded cool but never came up in real work.

This article shares what survived that test.

You will not find 222 shortcuts here. Most of those lists are useless because nobody remembers them. Instead, you will get the 50 shortcuts I still use every single day, grouped by what you are trying to do.

Ready? Let’s save you some hours.

Why Excel Shortcuts Are Worth Learning

Here is the truth. Most people use Excel at 20% speed.

They click. They scroll. They hunt for buttons. Then they wonder why work takes so long.

Shortcuts fix that. They do three big things:

1. They save time. A few seconds per task adds up to hours per week.
2. They keep your hands on the keyboard. That means fewer mistakes and less wrist strain. Doctors at the Mayo Clinic note that repetitive wrist movements can lead to problems like carpal tunnel syndrome over time.
3. They make you look like a pro. Yes, people do notice.

Shortcuts help power users like me move faster. But they also make Excel more usable for people with mobility or vision issues who cannot work well with a mouse. Microsoft’s accessibility team treats keyboard support as a core design idea across all their products.

You do not need to learn all 50 at once. Start with the top 10. Use them for a week. Then add more.

The Top 10 Excel Shortcuts (Start Here)

If you only learn 10 shortcuts in your life, make it these. They come up in almost every Excel task.

Print this table. Stick it on your monitor. In two weeks, your fingers will know them without thinking.

Navigation Shortcuts: Move Around Fast

The first big upgrade is how you move through a sheet. Most people use the scroll wheel and arrow keys. That is fine for 20 rows. It is painful for 20,000.

These shortcuts fix that.

1. Ctrl + Arrow Key (Jump to the Edge)

Press this to shoot to the last filled cell in any direction. Going down a price column with 5,000 rows? One tap takes you to the bottom.

2. Ctrl + Home (Go to Cell A1)

You can get lost somewhere inside a huge sheet. One press and you are home.

3. Ctrl + End (Go to the Last Used Cell)

This jumps to the bottom-right corner of your data. It is great when you need to check if extra junk data is hiding somewhere. I use this to clean up files before I share them.

4. Ctrl + Page Up and Ctrl + Page Down (Switch Sheets)

Working with many tabs at the bottom of your workbook? These two move you left or right through them. No more mouse clicks.

5. Ctrl + Tab (Switch Workbooks)

Have more than one Excel file open? Ctrl + Tab flips between them. Same idea as switching browser tabs.

6. F5 or Ctrl + G (Go To)

Type in any cell address, like Z500, and you jump right there. Handy for big models.

Selection Shortcuts: Pick Cells Without the Mouse

Selecting cells is where most people still cling to the mouse. Drop it. Your fingers can do this faster.

7. Shift + Arrow Key (Extend Selection)

Hold Shift and tap an arrow. You pick up one more cell in that direction. Keep tapping to grow the selection.

8. Ctrl + Shift + Arrow Key (Select to the Edge)

Combine the last two. This grabs everything from your cell to the end of the data. I use this to pick whole columns of numbers in one move.

9. Shift + Space (Select Whole Row)

One tap and the full row is picked.

10. Ctrl + Space (Select Whole Column)

Same idea, but for columns.

11. Ctrl + A (Select All)

Here is a cool thing most people miss. If your cell is empty, Ctrl + A picks the whole sheet. If your cell is inside a table, it picks only the table. Smart, right?

12. Ctrl + Shift + End (Select to Last Used Cell)

This picks from where you are to the very end of the data. Great for copying whole datasets.

13. Ctrl + Click (Pick Scattered Cells)

Hold Ctrl and click cells here and there. You build a custom group. Then you can format them all at once.

Data Entry and Editing Shortcuts

This group is where you will feel the biggest speed jump.

14. F2 (Edit the Active Cell)

Stop double-clicking cells to fix them. Just press F2. You drop right into edit mode.

15. Alt + Enter (New Line Inside a Cell)

Want two lines of text in one cell? Press Alt + Enter where you want the break. On Mac, use Option + Return.

16. Ctrl + Enter (Fill All Selected Cells)

This one is gold. Pick many cells. Type a value. Press Ctrl + Enter. Every selected cell gets filled with that value.

I once used this to fix a 3,000-row data sheet in under a minute. True story.

17. Ctrl + D (Fill Down)

Pick a cell with a value. Select the empty cells below it. Press Ctrl + D. The value (or formula) flows down.

18. Ctrl + R (Fill Right)

Same thing, but fills to the right.

19. Ctrl + ; (Insert Today’s Date)

Hold Ctrl and tap the semicolon. Today’s date drops in.

20. Ctrl + Shift + ; (Insert Current Time)

Same idea, but for the time right now.

21. Ctrl + ’ (Copy from the Cell Above)

The apostrophe key (next to Enter) copies the value from the cell directly above. Fast way to repeat a value.

22. Esc (Cancel What You Typed)

Typed the wrong thing? Do not delete letter by letter. Just hit Esc. The cell goes back to what it was.

Formatting Shortcuts

Formatting slows down most people. These shortcuts make it instant.

23. Ctrl + B (Bold)

24. Ctrl + I (Italic)

25. Ctrl + U (Underline)

Simple, but you will use them forever.

26. Ctrl + 1 (Open Format Cells)

This is one of the most powerful shortcuts in Excel. It opens the full Format Cells dialog box. From there, you can change fonts, borders, numbers, dates, and more.

27. Ctrl + Shift + $ (Currency Format)

Turns any number into dollars and cents. Perfect for reports.

28. Ctrl + Shift + % (Percent Format)

Turns 0.15 into 15% in one keystroke.

29. Ctrl + Shift + # (Date Format)

Makes a number look like a date.

30. Ctrl + Shift + ! (Number Format with Commas)

Changes 1000000 into 1,000,000.00. Reports look cleaner instantly.

31. Alt + H + H (Fill Color)

On Windows, press Alt to turn on the menu shortcuts. Then H for Home, then H again for fill color. You pick a color from the menu. Fast once you learn the pattern.

32. Ctrl + Shift + L (Turn Filters On or Off)

This one is a lifesaver. One press adds filter arrows to your headers. Another press removes them. No more digging through the ribbon.

Formula Shortcuts

These are the shortcuts that made me fall in love with Excel.

33. Alt + = (Auto Sum)

Pick an empty cell below some numbers. Press Alt + =. Excel writes the SUM formula for you. Hit Enter. Done.

34. F4 (Repeat Last Action or Lock References)

This one has two superpowers.

If you are editing a formula, F4 locks the cell reference. So A1 becomes $A$1. Press it again for A$1, then $A1. This is huge for anyone who works with formulas.

Outside of formulas, F4 repeats your last action. Changed a cell color? F4 does it again on the next cell. This is one of the simplest tricks that saves the most time, and I still use it daily.

35. F9 (Calculate Part of a Formula)

Highlight part of a formula inside the formula bar. Press F9. Excel shows you the real value of that piece. This is how I debug messy formulas. Do not forget to press Esc after, or you will lock in the value.

36. Ctrl + ` (Show Formulas)

The backtick key (above Tab) flips the sheet to show every formula instead of every result. Press it again to flip back. Great for auditing.

37. Ctrl + [ (Jump to Source Cell)

If your formula uses a cell from another place, Ctrl + [ jumps you straight to that cell. I learned this one from a senior analyst about six years ago. I still use it daily.

38. Shift + F3 (Insert Function Wizard)

Opens a helpful box that lets you search for and build a function step by step. Good for new users.

Row and Column Shortcuts

Adding, deleting, and hiding rows is one of the most common Excel tasks. The mouse method is slow. These are faster.

39. Ctrl + Shift + Plus (Insert Row or Column)

Select a row, press this, and a new row slides in above.

40. Ctrl + Minus (Delete Row or Column)

Select a row, press Ctrl + Minus, and boom, it is gone.

41. Ctrl + 9 (Hide Rows)

42. Ctrl + 0 (Hide Columns)

43. Ctrl + Shift + 9 (Unhide Rows)

To unhide, first select the rows around the hidden ones. Then use this combo.

44. Alt + H + O + I (Auto Fit Column Width)

Select your columns. Press Alt, H, O, I, one after the other. Every column resizes to fit its content. This one looks weird but works perfectly every time.

Sheet and Workbook Shortcuts

45. Shift + F11 (Insert New Sheet)

Adds a new worksheet tab instantly.

46. Ctrl + N (New Workbook)

Opens a brand new Excel file.

47. Ctrl + W (Close Current Workbook)

Closes the one you are in without closing Excel.

48. Ctrl + P (Print Preview)

Shows you how the sheet will look on paper. Always use this before printing. It has saved me from printing 200 blank pages more than once.

49. F12 (Save As)

Opens the Save As box. Useful when you need to save a copy with a new name.

50. Ctrl + F1 (Hide or Show the Ribbon)

Your screen feels tiny on a laptop. Ctrl + F1 hides the ribbon and gives you back a ton of space. Press it again to bring it back.

5 Hidden Shortcuts Most People Never Find

These are my favorites. None of them are on the basic lists. They all save real time.

Ctrl + Shift + V (Paste Values Only)

Tired of paste bringing along ugly formatting? This pastes only the values. No colors. No borders. Just the numbers. Clean.

Alt + ; (Select Visible Cells Only)

When you filter a list, copying it also grabs the hidden cells. That causes chaos.

Before you copy, press Alt + ; (semicolon). It picks only the cells you can see. Then copy and paste without a mess.

Ctrl + T (Turn Your Data Into a Table)

Pick your data. Press Ctrl + T. Hit Enter. Now your data is a real Excel table with filters, formatting, and formulas that auto-extend.

This one single-handedly doubled my speed when I learned it.

Ctrl + Shift + U (Expand the Formula Bar)

Long formulas hide on one line in the formula bar. This pops it open so you can see the whole thing. Great for long IF or VLOOKUP formulas.

F4 While Editing (Toggle Cell References)

I mentioned this one above, but it deserves a second look. Every serious Excel user I know presses F4 hundreds of times a week. It cycles through A1, $A$1, A$1, and $A1. Without it, you are typing dollar signs all day.

Quick Note for Mac Users

Most Windows shortcuts work on a Mac, but with small swaps. Here is the cheat sheet.

Sadly, the Alt menu shortcuts (like Alt + H + O + I) do not work the same on Mac. Excel for Mac uses a different system for its ribbon. If you live on a Mac, stick to the Cmd-based shortcuts and get used to the menu bar.

3 Mistakes Beginners Make With Shortcuts

After years of teaching shortcuts to coworkers, I see the same three mistakes again and again.

1. Trying to learn too many at once. You will forget them all in a week. Pick five. Use them every day. Add five more next month.

2. Not practicing them on real work. If you learn them in a tutorial but never use them in your actual job, your brain drops them. Force yourself to use one shortcut every time a situation comes up.

3. Fighting muscle memory. You have been using the mouse for years. Your hand will keep reaching for it. Cover your mouse with a sticky note for a day. You will shock yourself at how fast you pick up shortcuts.

How to Memorize Excel Shortcuts (For Real)

Here is what worked for me.

First, I wrote the top 10 on a sticky note. I placed it right under my monitor. Every time I reached for the mouse, I forced myself to check the note first.

Second, I turned it into a game. I would say to myself, “Finish this report with zero mouse clicks.” Sometimes I failed. But even trying made me faster.

Third, I taught a coworker. When you teach something, you cannot forget it. Trust me on this.

Within 30 days, my fingers just knew them. My reports went from two hours to 20 minutes. Same data. Same Excel. Different skills.

Frequently Asked Questions

What is the most useful Excel shortcut?

For me, it is Ctrl + Arrow Key. It lets you move through huge spreadsheets in a split second. If you work with data that goes past row 100, this one shortcut alone will save you hours every month.

How many Excel shortcuts are there?

There are more than 500 shortcuts in Excel. Microsoft’s official guide lists them all. But nobody needs them all. Most power users rely on about 40 to 60 shortcuts, max.

Are Excel shortcuts the same on Windows and Mac?

Most of them are the same in idea, but you swap Ctrl for Cmd and Alt for Option. A few Windows shortcuts, like Alt + menu key combos, do not exist on Mac at all.

What is the shortcut to sum in Excel?

Press Alt + = on Windows. Excel auto-writes the SUM formula for you. On a Mac, press Cmd + Shift + T.

What is the F4 key used for in Excel?

F4 has two jobs. Inside a formula, it locks cell references (adds dollar signs). Outside a formula, it repeats your last action. Both uses save a lot of clicks.

How do I learn Excel shortcuts fast?

Start with 5 to 10. Use them daily for a week. Add more once the first batch feels natural. Print a cheat sheet and keep it near your screen. Do not try to learn 50 at once.

What is the shortcut to save in Excel?

Ctrl + S on Windows. Cmd + S on Mac. Use it often. Excel can crash, and no one wants to lose two hours of work.

What is the shortcut to add a filter in Excel?

Ctrl + Shift + L. Press it once to add filters. Press it again to remove them. One of the most underrated shortcuts out there.

What is the shortcut to paste values in Excel?

Ctrl + Shift + V. This pastes only the values, without the formatting. Clean and simple.

How do I unhide a column in Excel with a shortcut?

Select the columns on both sides of the hidden column. Then press Ctrl + Shift + 0. Note: on some Windows setups, this shortcut is blocked. If it fails, right-click and choose Unhide from the menu.

Final Thoughts

Excel shortcuts are not about showing off. They are about taking back your time.

I have watched smart people spend their whole workday clicking through menus. That is not a computer problem. That is a habit problem. And just like mastering microsoft teams tips and tricks can transform your meetings, these Excel habits can change your workflow fast with the right tools.

Pick five shortcuts from this list. Use them today. Tomorrow, pick five more. In one month, your Excel speed will feel like a superpower.

And when a coworker asks how you finished that report so fast? You can send them this article. Or better yet, show them an excel hidden game to celebrate your newly saved free time.

Now go save yourself some hours.

Have a favorite Excel shortcut I missed? Drop it in the comments. I am always hunting for new ones.

Harris K.

Harris loves digging into software to find what others miss. He has a real passion for sharing Tricks and Hidden Features that simplify your digital life. He writes these guides to help you get more done with less effort.