There are over 100 Excel shortcut keys available for you to learn. Make your work faster by learning these amazing shortcut keys for your spreadsheet application.
Using the mouse can be faster jumping from one place in a spreadsheet to the other, but sometimes it gets annoying if you have to line up the cursor right before moving.
Sometimes, it is not just the mouse line up but you just don’t know where to locate certain tools.
I will be using lots of spreadsheet terms in my presentation. If you are not familiar with Excel, quickly check my previous article on Excel terms.
Watch and read this article guide here carefully about on over 100 Excel Shortcut Keys Just For You available in 2022.
Ctrl Excel Shortcut Keys Combination
- Ctrl + A – Select All
- Ctrl + B – Bold
- Ctrl + C – Copy
- Ctrl + D – Fill
- Ctrl + F – Find
- Ctrl + G – Find next instance of text
- Ctrl + H – Replace
- Ctrl + I – Italic
- Ctrl + K – Insert a hyperlink
- Ctrl + N – New workbook
- Ctrl + O – Open
- Ctrl + P – Print
- Ctrl + R – Nothing right
- Ctrl + S – Save
- Ctrl + U – Underlined
- Ctrl + V – Paste
- Ctrl + W – Close
- Ctrl + X – Cut
- Ctrl + Y – Redo
- Ctrl + Z – Undo
- Ctrl + : – Insert the current time
- Ctrl + ; – Insert the current date
- Ctrl + “ – Copy the value of the cell above
- Ctrl + ‘ – Copy the formula from the cell above
- Ctrl + ` – Change views to display formulas
- Ctrl + – – Delete selected column or row
- Ctrl + F3 – Set name
- Ctrl + F4 – Close
- Ctrl + F5 – XL, size of the restore window
- Ctrl + F6 – Next Workbook Window
- Ctrl + F7 – Move window
- Ctrl + F8 – Resize Window
- Ctrl + F9 – Minimize the workbook
- Ctrl + F10 – Maximize or Restore Window
- Ctrl + F11 – Inset 4.0 Macro sheet
- Ctrl + F1 – Open File
- Ctr + 0 – Hide column
- Ctrl + 1 – Format cell contents
- Ctrl + 5 – Strikethrough
- Ctrl + 8 – Show outline symbol
- Ctrl + 9 – Hide row
- Ctrl + ` – Toggle value / display of the formula
- Ctrl + Shift + A – Insert the argument names in the formula
- Ctrl + Shift + F3 – Create a name using the names of row and column labels
- Ctrl + Shift + F6 – Previous Window
- Ctrl + Shift + F12 – Printing
- Ctrl + Shift + = – Insert columns and rows
- Ctrl + Shift + ~ – General Format
- Ctrl + Shift + 0 – Unhide Column
- Ctrl + Shift + 1 – Apply comma formatting
- Ctrl + Shift + 2 – Apply time formatting
- Ctrl + Shift + 3 – Apply date formatting
- Ctrl + Shift + 4 – Apply currency formatting
- Ctrl + Shift + 5 – Apply percentage formatting
- Ctrl + Shift + 7 – Thicken border of selected cell
- Ctrl + Shift + 9 – Unhide row
Shift Excel shortcut Keys Combination
- Shift – Offset Adjustment for Additional Functions in the Excel Menu
- Shift + F1 – What is it?
- Shift + F2 – Edit cell comment
- Shift + F3 – Paste the function into the formula
- Shift + F4 – Search Next
- Shift + F5 – Find
- Shift + F6 – Previous Panel
- Shift + F8 – Add to the selection
- Shift + F9 – Calculate the active worksheet
- Shift + F10 – Popup menu display
- Shift + F11 – New spreadsheet
- Shift + F12 – Save
- Shift + Ctrl + F6 – Previous Workbook Window
Alt Key combination
- Alt + A – Select Data tab
- Alt + H – Select Home tab
- Alt + M – Select Formulas tab
- Alt + N – Sletct Inert tab
- Alt + P – Select Page Layout tab
- Alt + Q – Jump to search
- Alt + R – Select Review tab
- Alt + W – Select View tab
- Alt + Y – Select Help tab
- Alt + Enter – Start New line
- Alt + F1 – Insert a graph
- Alt + F2 – Save As
- Alt + F4 – Output
- Alt + F8 – Macro dialog
- Alt + F11 – Visual Basic Editor
- Alt + Shift + F1 – New spreadsheet
- Alt + Shift + F2 – Save
- Alt + = – AutoSum
- Alt + down arrow – automatic view list
- Alt + ‘ – Format Style Dialog
- Alt + 1 – Autosave on
- Alt + 2 – Save work
- Alt + F + C – Save and close
- Alt + F + E – Export
- Alt + F + Z – Share workbook
Navigation Shortcut Keys
- Use Arrow keys to move Left, Right, Up, or Down.
- Tab – Move Right
- Shift + Tab – Move left
- Enter – Move down
- Shift + Enter – move up
- Ctrl + Arrow keys will move to the end of the page
Function Keys
- F1 – Help
- F2 – Edition
- F3 – Paste the name
- F4 – Repeat the last action
- F4 – When entering a formula, switch between absolute/relative references
- F5 – Go to
- F6 – Next Pane
- F7 – Spell Check
- F8 – Extension of the mode
- F9 – Recalculate all workbooks
- F10 – Activate Menubar
- F11 – New graph
- F12 – Save As
Conclusion
These are not all the shortcut keys in Excel. But these ones will help you go a bit faster.
Since the online version of Excel works in a browser, it is likely some of the shortcuts will work for the browser instead of Excel.
Thanks for reading our useful guide about Over 100 Excel Shortcut Keys Just For You in 2022.
There are also combinations that demand that you have data on your sheet before they will work.