Many people use Microsoft Excel to store and analyze data all around the world. Even though there are other data analysis tools available, Excel is still the most popular choice for working with data. It has lots of built-in features that make it easy for you to organize your data.

Shortcut keys in Excel help you work on your data quickly. In this article, we will talk about different Excel shortcuts. These keyboard shortcuts help you do tasks faster and better.

What is Microsoft Excel?

Microsoft Excel is a program made by Microsoft that helps you keep track of data, analyze it, and make charts. It was created in 1985.

Microsoft Excel Spreadsheet

Data in Excel is organized in rows and columns. We use Excel to keep track of information, do math, and make charts. Excel can also help us automate tasks with macros.

To work faster in Excel, there are shortcuts we can use. By pressing certain keys on the keyboard, we can do tasks more quickly. Let’s learn some Excel shortcuts to make our work easier.

Why You Should Learn MS Excel Shortcut Keys?

Excel has lots of shortcuts that can help you work faster and get more done. Instead of using the mouse to click on things, you can just press a few keys on the keyboard to do important tasks. This saves time and makes your work easier.

You don’t have to memorize all the shortcuts, but it’s good to know a few. If you practice using them regularly, you’ll remember most of them without even trying.

In this article, we’ll talk about 50 Excel shortcuts that are grouped based on what they do. Let’s start with the shortcuts for working with workbooks.

Workbook Shortcut Keys

In this part, we will learn how to use a workbook. We will see how to make a new workbook, open one that already exists, and save it so you don’t lose any work. We will also learn how to switch between different sheets in a workbook.

DescriptionExcel Shortcuts
1. To create a new workbookCtrl + N
2. To open an existing workbookCtrl + O
3. To save a workbook/spreadsheetCtrl + S
4. To close the current workbookCtrl + W
5. To close ExcelCtrl + F4
6. To move to the next sheetCtrl + PageDown
7. To move to the previous sheetCtrl + PageUp
8. To go to the Data tabAlt + A
9. To go to the View tabAlt + W
10. To go the Formula tabAlt + M

Here are some shortcuts in Excel that can help you move around your spreadsheet easily. After you finish creating your workbook, the next important thing to do is cell formatting.

Cell Formatting Shortcut Keys

In Excel, a cell holds all your data. You can use shortcuts to do things like edit a cell, line up the text inside a cell, put a border around a cell, make an outline around multiple cells, and more. Here are some quick tips for using these shortcuts in Excel.

DescriptionExcel Shortcuts
11. To edit a cellF2
12. To copy and paste cellsCtrl + C, Ctrl + V
13. To italicize and make the font boldCtrl + I, Ctrl + B
14. To center align cell contentsAlt + H + A + C
15. To fill colorAlt + H + H
16. To add a borderAlt + H + B
17. To remove outline borderCtrl + Shift + _
18. To add an outline to the select cellsCtrl + Shift + &
19. To move to the next cellTab
20. To move to the previous cellShift + Tab
21. To select all the cells on the rightCtrl + Shift + Right arrow
22. To select all the cells on the leftCtrl + Shift + Left Arrow
23. To select the column from the selected cell to the end of the tableCtrl + Shift + Down Arrow
24. To select all the cells above the selected cellCtrl + Shift + Up Arrow
25. To select all the cells below the selected cellCtrl + Shift + Down Arrow

In addition to the cell formatting shortcuts we already talked about, let’s learn some more advanced Excel shortcuts for formatting cells. These can be really useful.

Today, we’ll learn how to add comments to cells. Comments give extra info about what’s in a cell. We’ll also learn how to find and change values in a spreadsheet. Then, we’ll see how to put in the current time, date, use a filter, and add a link to a cell. Finally, we’ll learn how to make data in a cell look a certain way.

DescriptionExcel Shortcuts
26. To add a comment to a cellShift + F2
27. To delete a cell commentShift + F10 + D
28. To display find and replaceCtrl + H
29. To activate the filterCtrl + Shift + L

Alt + Down Arrow

30. To insert the current dateCtrl + ;
31. To insert current timeCtrl + Shift + :
32. To insert a hyperlinkCtrl + k
33. To apply the currency formatCtrl + Shift + $
34. To apply the percent formatCtrl + Shift + %
35. To go to the “Tell me what you want to do” boxAlt + Q

Once you’ve learned how to format cells in Excel using shortcuts, the next thing to learn is how to work with a whole row or column in Excel.

Row and Column Formatting Shortcut Keys

In this part, we will learn some important tips for organizing rows and columns in our spreadsheet.

We will learn how to delete rows and columns, hide and show the rows and columns we choose, and group and ungroup rows and columns.

DescriptionExcel Shortcuts
36. To select the entire rowShift + Space
37. To select the entire columnCtrl + Space
38. To delete a columnAlt+H+D+C
39. To delete a rowShift + Space, Ctrl + –
40. To hide selected rowCtrl + 9
41. To unhide selected rowCtrl + Shift + 9
42. To hide a selected columnCtrl + 0
43. To unhide a selected columnCtrl + Shift + 0
44. To group rows or columnsAlt + Shift + Right arrow
45. To ungroup rows or columnsAlt + Shift + Left arrow

Now that we’ve learned about quick ways to change how cells, rows, and columns look, let’s move on to a more advanced topic in Excel: pivot tables. We’ll explore shortcuts that help you summarize your data using pivot tables.

Pivot Table Shortcut Keys

First, let’s make a pivot table using a sales dataset.

In the picture below, you can see a pivot table that shows the total sales for each type of product in every category.

Pivot Table Shortcut Keys

46. To group pivot table itemsAlt + Shift + Right arrow

The picture shows that we put together the sales of bookcases and chairs into Group 1.

Sales Of Bookcases And Chairs Subcategories

47. To ungroup pivot table itemsAlt + Shift + Left arrow
48. To hide pivot table itemsCtrl + –

Below, we have hidden the subcategories for Chairs, Art, and Labels.

Chairs, Art, And Label Subcategories

49. To create a pivot chart on the same sheetAlt + F1
50. To create a pivot chart on a new worksheetF11

Pivot Chart On The Same Sheet

Conclusion

Mastering these 50 Excel shortcuts in 2024 will undoubtedly boost your productivity and efficiency in handling data and spreadsheets. Whether you’re a beginner or an experienced Excel user, incorporating these shortcuts into your workflow will save you time and effort, allowing you to focus on analyzing and interpreting your data effectively. Stay ahead in the competitive landscape of data analysis by making the most out of these essential Excel shortcuts.

FAQs

1. What are MS Excel Shortcut Keys?

MS Excel Shortcut Keys are like magic codes you can type on your keyboard to do things quickly in Excel. They help you work faster, especially when dealing with big spreadsheets. For example, instead of clicking a button to make text bold, you can just press Ctrl+B.

2. Why are Excel shortcuts important?

Excel shortcuts are super important because they make your work easier and faster. By using shortcuts, you can save time and focus on other important stuff. They also help prevent your hand from getting tired from using the mouse too much.

3. What are some of the most common Excel shortcuts?

Here are some popular Excel shortcuts:

  • Ctrl+C: Copy
  • Ctrl+V: Paste
  • Ctrl+Z: Undo
  • Ctrl+Y: Redo
  • F2: Edit cell
  • Ctrl+A: Select all
  • Home: Go to the start of the worksheet
  • End: Go to the end of the worksheet
  • PgUp: Move up one page
  • PgDn: Move down one page
4. Where can I find a list of Excel shortcuts?

You can find Excel shortcuts in the Excel Help menu or on the Microsoft Office website.

5. How can I create my own Excel shortcuts?

You can make your own Excel shortcuts by going to the File menu, selecting Options, then going to the Advanced tab. Look for Keyboard shortcuts and click on New to create your own shortcut.

6. How do I manage shortcuts in Excel?

To manage shortcuts in Excel, go to Excel Options, then to Customize Ribbon. Click on Keyboard Shortcuts to change or create shortcuts as you like.

7. How many Excel shortcuts are there?

There are more than 270 Excel shortcuts for keyboard and mouse, for Windows, Mac, and Web versions. These shortcuts help you work faster and smarter with your data.

8. What is the shortcut to copy selection in Excel?

To copy in Excel, press Ctrl+C.

9. How can I undo the last action in Excel?

To undo in Excel, press Ctrl+Z.

10. What is the shortcut to redo the last action in Excel?

To redo in Excel, press Ctrl+Y.

Shares:
Show Comments (0)

Leave a Reply

Your email address will not be published. Required fields are marked *

1 + 2 =