Best Shortcut Keys For MS Excel

Best shortcut keys for MS Excel

Best Shortcut Keys For MS Excel used    in 2022

What is Microsoft Excel?

Excel is a computer program developed by the Microsoft company for Windows, mac OS, Android, and iOS. It is a part of Microsoft Office which includes other programs such as Word and PowerPoint, Access, etc.

It is an electronic spreadsheet used to store, organize, and manipulate data. The data is stored in cell/cells. It is usually organized into a series of columns and rows in a worksheet. The collection of columns and rows is referred to as a table.

Why ms excel is important?

Microsoft Excel enables users to identify trends and organize and sort data into meaningful categories.

Excel also performs Human Resources functions, such as sorting worked hours and organizing employee profiles and expenses, which help businesses better understand the structure and activities of their workforce.

Pivot tables summarize data from a worksheet into a chart.

What is Excel for?

Excel is distinguished from all other office programs because it allows us to work with numeric data. We can perform basic arithmetic calculations with the numbers stored in Excel. We also apply more complex mathematical functions or use of statistical functions.

Excel makes it easier for us to work with numbers and allows us to easily analyze them. It generates reports with tools such as graphs and dynamic tables.

The best keyboard shortcuts in Microsoft Excel

By Belinda Anderson, 31 March 2016,Updated: 26 October 2020.

Want to become more efficient using Excel? Let me show you the best keyboard shortcuts in Excel. Anyone who has ever attended training with me, or even anyone who has read my other “shortcut key” posts, should know that I am a big fan of shortcuts. Anything that can improve efficiency and workflow is a good thing in my books. Because I often multi-task on the computer, I tend to use many of these shortcut keys on a very regular basis.

If you plan to start using keyboard shortcuts, start small. Don’t try to memorise them all in one go. Break them down into a hand full of the shortcuts you think you will use most often. Once you have those locked into memory then identify the next group and continue until you have mastered shortcuts like a pro!

Below is a list of my favourite shortcuts to use in Microsoft Excel. Don’t worry about writing these ones down, you can receive a PDF copy of all keyboard shortcut lists at the bottom of this post.

What are excel formulas?

Excel formulas help you identify relationships between values in the cells of your spreadsheet, perform mathematical calculations using those values, and return the resulting value in the cell of your choice. Formulas you can automatically perform include sum, subtraction, percentage, division, average, and even dates/times.

Excel Formulas

1. SUM
2. IF
3. Percentage
4. Subtraction
5. Multiplication
6. Division
7. DATE
8. Array
9. COUNT
10. AVERAGE
11. SUM IF
12. TRIM
13. LEFT, MID, and RIGHT
14. Vlookup

My Favourite Shortcut Keys

1. Ctrl + N Create a New workbook
2. Ctrl + O Open an existing workbook
3. Ctrl + F12 Display the Open dialog box
4. Ctrl + S Save current workbook
5. Ctrl + P Print current workbook
6. Ctrl + W Close current workbook
7. Ctrl + A Select entire worksheet
8. Ctrl + Z Undo. Undo. Undo. Need I say more?
9. Ctrl + Y Redo the last action
10. Ctrl + X Cut
11. Ctrl + C Copy
12. Ctrl + V Paste
13. Ctrl + B Apply Bold formatting
14. Ctrl + I Apply Italics formatting
15. Ctrl + U Apply Underline formatting
16. Ctrl + F Find text or formatting within the current workbook
17. Ctrl + H Find and replace text or formatting within the current workbook
18. Ctrl + G Use the Go To feature
19. Ctrl + K Insert a hyperlink
20. Ctrl + E Flash Fill
21. Ctrl + 1 Display the Format Cells dialog box
22. Alt Turn KeyTips on and off
23. TAB Move one cell to the right
24. Ctrl + mouse wheel Scroll the mouse wheel up to zoom in and down to zoom out
25. Alt + Tab Switch between open program windows
26. F1 Launch Help
27. F2 Edit the current cell
28. F4 Repeat the last action
29. F7 Spell Check
30. F11 Create a chart from current data
31. F12 Save As
32. Ctrl + Home Move the cursor to cell A1
33. Ctrl + End Move the cursor to last cell containing data
34. Ctrl + Shift + ~ Apply a General Number format
35. Ctrl + Shift + $ Apply a Currency Number format
36. Ctrl + Shift + % Apply a Percentage Number format
37. Ctrl + Space Bar Select current column
38. Shift+ Space Bar Select current row
39. Shift + Home Highlight from the current cell back to column A of the row
40. Ctrl + Shift + Home Highlight from the current cell back to cell A1
41. Ctrl + Shift + End Highlight from the current cell to the last cell containing data
42. Ctrl + Page UP Move between worksheets (Right to Left)
43. Ctrl + Page Down Move between worksheets (Left to Right)
44. Best 15 MS-Excel Keyboard Shortcuts
45. F4: Repeats the previous command, including repeating the last action.
46. F9: One of the most important shortcut keys, this enables you to calculate all worksheets in all open workbooks.
47. F11: Enables you to make a bar graph on the selected data in a separate sheet.
48. F12: Pops open the Save As window, allowing you to save the MS Excel file in any location you wish.
49. Shift + F11: This allows you to insert a new worksheet within the same MS Excel workbook.
50. Shift + F9: Shortcut enables calculations only in the active worksheets.
51. Shift + Arrow key: Adds a new cell in the direction of the Arrow key used.
52. Ctrl + F1: The shortcut helps to show or hide the ribbon.Ctrl + F2: Switches to print preview.
53. Ctrl + Shift + U: Expands or collapses the formula bar.
54. Ctrl + Shift + $: Selected cells formatted as currency.
55. Ctrl + Shift + #: Selected cells formatted as date with day, month, year format.
56. Ctrl + Shift + %: Selected cells formatted as percentage.
57. Alt + F1: This allows you to make an embedded bar chart on the selected cells.
58. Alt + Q: Shortcut key opens the 'Tell me what you want to do', enabling you to search for a feature.

Bonus Shortcut Keys To Remember

Apart from these, there are a couple of basic shortcut keys that can be used across Microsoft Office. Some are listed below:

1. Ctrl + Z: Undo an action
2. Ctrl + Y: Redo an action
3. Ctrl + F4: Closes the opened file
4. Ctrl + S: Saves the file'
5. Ctrl + N: Opens new page