The excel shortcut keys are designed to convenient learning of the MS excel functions accessed by using ALT, ctrl, shift, function keys and windows key. So when you are pressing the alt key, the user can observe that the ribbon tab below will display the shortcuts keys to press.
Common Shortcut keys
Here comes the list of common or basic excel shortcutkeys that everyone must know:-
1. Alt + F – file menu option in the current program.
2. Alt + E – edits options in the current program.
3. F1– universal help for any kind of program.
4. Ctrl + A – selects all texts.
5. Ctrl + X – cuts the selected items.
6. Ctrl + Del – cuts selected items.
7. Ctrl +C – copy the selected items.
8. Ctrl + V – paste the selected items.
9. Shift + Ins – paste the selected items.
10. Home – takes the users to the beginning of the document.
11. Ctrl + home – go to the beginning of the document.
12. End – Go to the end of the current line.
13. Ctrl + End – go to the end of a document.
14. Shift + home – highlight from current position to beginning of the line.
15. Ctrl_ (left arrow) – move one word to the left at a time.
Pivot table shortcut keys
The pivot table is quite an advanced and powerful tool in MS Excel. This is helpful for summarizing the data which helps to learn about few shortcuts that works quickly with them
16. Creating a pivot table from the selected data
For the purpose, first select the data set and then press Alt>N>V. then a dialog box will appear with the options to create a pivot table. Even you can normally select a cell in the data set as long as there are no blank rows or columns and then the excel will highlight the entire data set.
17. Refreshing the current pivot table
For the above sequence, select a cell in the pivot table and then press Alt + F5.
18. Refreshing all pivot tables in the workbook
Just press Ctrl+ Alt+F5.
19. Selecting an entire pivot table including the report filters
Select a cell in the pivot table and then press Alt>JT>W>T.
20. Select an entire pivot table that don’t include report filters
Just select a cell in the pivot table and then press Ctrl+A or press Ctrl+ shift +*.
21. Create a pivot chart on the same sheet
Select a cell in a pivot table and then press F11 to create a pivot chart on a new sheet based on the current pivot table.
22. Group selected pivot table items
For this, press Alt+ Shift+ Left arrow to ungroup the selected pivot table items.
23. Open the pivot table and the pivot chart wizard
To open the legacy of the pivot table and the pivot chart wizard, just press Alt>D>P and the legacy dialog box will appear.
Navigation shortcut keys
The navigation key board points out details for people who cannot use a mouse or even other pointing device. For the keyboard shortcuts that are useful to all the users.
24. Navigate user’s interfaces
Move the keyboard focus between the different controls. So just ctrl +tab moves between groups of controls, these are from a side bar to the main content. Ctrl+ Tab can also break out a control that uses Tab itself, such as a text area. Hold down Shift to move focus in the reverse order.
25. The arrow keys
Move selection between items in a single control, or among a set or related controls. So just use the arrow keys to focus buttons in a tool bar, then select items in a list or icon view, or select just a radio button from the group.
26. Ctrl+ arrow keys
In a list or icon view, just move the keyboard focus to another item without changing which item is selected.
27. Shift + arrow keys
In the list or icon view, just select all items from the currently selected items to the newly focused items. This will be available in a tree view and the following expands by pressing shift+à and collapse by pressing shift+ß.
Activate a focused item like button, check box and list items.
29. Ctrl + space
In the list or icon view, select or deselect the focused item without deselecting other items.
Hold the alt key to reveal the accelerators and press the underlined letter to activate a control, just like if you have clicked on it.
Exit a menu, popup, switcher or a dialog window.
You may also like, How to Use Excel: Basic Terms & Formulas [Easy Guide].
How to select items with shortcut keys
There are some basic key board ms excel shortcut keys which help to select cells. These are like:-
32. Select the last used cell
It doesn’t matter from where you are starting your worksheet. Just press ctrl+ end and it will take you to the intersection of the last used column and the last used row.
33. Select the first visible cell
Using the ctrl+ home will take you to the first visible cell excluding the hidden rows and columns on the sheet until and unless your sheet has freeze panes.
These freeze panes locks the rows and columns in place so that they are always visible. The following are helpful when you want to see the titles, headers or the product names that would help to identify the data.
34. Selecting last cell in contiguous range
Using ctrl along with the arrow keys would allow users to move to the beginning or the end of contiguous data in a row or column. Repeating the process would move you further down the column to just before the next of blank cell.
35. Alternative use of mouse
The following can be accomplished using the mouse instead of keyboard and vice versa. For the key board, just hover over the bottom line of the cell until the cursor turns into and arrow with the cross hairs. Then double click. That will help you jump down to the last cell in the contiguous set of data for that column.
Functions and formulas short keys
Here comes a list of functions and formulas for excel keyboard shortcut keys:-
36. F9 – smart calculation with the power to calculate the complete worksheets in the complete open workbooks. This also replaces the highlighted part of the formula with its result to help debug when you are using the formula bar.
37. Shift + F9:-calculates the active or selected worksheets in the active workbook.
38. Ctrl + alt+ F9:- Calculates all the worksheets in the open workbooks.
39. Ctrl+alt+shift+F9:-helps with complete recalculation. It calculates all the worksheets in all the open workbooks
40. Ctrl + shift+ F9:- This is not a default shortcut key. But some third party add-ins uses this for performing a complete calculation of all the cells in just the active workbook.
Time and date short keys
For formatting time in the excel sheet:-
- Add time to cell in a worksheet manually.
- If it stands necessary, select the cell to make it the active cell.
- Press and hold the ctrl and shift keys on the keyboard.
- Now press and release the @ symbol key on the keyboard which is located above the number 2 without releasing the ctrl and shift keys.
- Now release the ctrl and shift keys.
- The time will then be formatted to show the current time in the excel sheet.
Similarly for the data sheet;-
- Select the cell where you want the date to appear.
- Now press and hold the ctrl key on the keyboard.
- Next press and release the semi colon key on the keyboard without releasing the ctrl key.
- Release the Ctrl key.
- Now the current date will appear on the selected worksheet.
Short keys to edit in Excel
Shortly if we move to know the short keys to edit in excel for editing a cell is F2 on the windows and ctrl +U on the Mac. Using these keys with the Excel’s default settings, you can put the cursor directly in the cell and ready to edit it as the Microsoft excel shortcuts to edit.
Formatting shortcut keys in Excel
Here comes a list of excel formatting shortcuts:-
41. CONTROL + B – this applies for bold font formatting to headers.
42. ALT + H + B + A– applicable to build the borders to the cells.
43. ALT + H+ B+ T – helps in building outline border to the data set.
44. ALT + H+ O+W – helps with auto filling the column widths.
45. CONTROL + 1– open the formatting cell dialog box.
Follow us on Pinterest.
excel shortcut keys, excel shortcuts, ms excel shortcut keys, excel keyboard shortcuts, microsoft excel shortcuts, shortcut keys used in ms excel.