Ms Excel all keyboard shortcuts
 |
| Ms Excel keyboard shortcut improves your professionalism |
All keyboard shortcuts used in Ms Excel are given here. Knowing all the keyboard shortcuts in Ms Excel improves your speed while working and saves your time too with approximately upto 50%.
This post includes approximately all the shortcut keys that are used in Ms Excel and this is very beneficial to you in day to day life as well as professional life.
 |
| Ms Excel keyboard shortcuts are time saving |
The following shortcuts are for Ms Excel spreadsheet and may or may not work on other spreadsheets, like google sheets, libre calc, etc.
Here are all the Ms Excel keyboard shortcuts:-
Ctrl + A - Select all
Ctrl + B - Apply or remove bold of the selected cell
Ctrl + C - Copy the selected text
Ctrl + D - Fill down
Ctrl + E - Flash Fill
Ctrl + F - Used to Find the desired text in the spreadsheet
Ctrl + G - Go To
Ctrl + H - Replace the desired text in the spreadsheet
Ctrl + I - Apply or remove Italics of the selected text
Ctrl + K - Inserts hyperlink
Ctrl + N - Create new workbook
Ctrl + O - Open existing workbook
Ctrl + P - Print the current file
Ctrl + S - Saves the current workbook
Ctrl + T - Create table
Ctrl + U - Apply or remove the underscore of the selected text
Ctrl + V - Paste the text you copied
Ctrl + X - Cut the selected text
Ctrl + Y - Redo the last action
Ctrl + Z - Undo the last action
Ctrl + ; - Enter the current date
F1 - Open help window
F2 - Edit the selected cell
F4 - Repeat the last action
F5 - Go To
F7 - Run Spellcheck
F9 - Calculate worksheets
F11 - Insert chart in a new sheet
F12 - Save as
Ctrl + F1 - Expand or collapse the ribbon
Ctrl + Alt + V - Paste Special dialog box
Ctrl + Shift + F4 - Find previous match
Shift + F4 - Find next match
Shift + Space - Select table row
Ctrl + Space - Select table column
Alt + C - Clear slicer filter
Shift + F7 - Open Thesaurus
Alt + F8 - Open Macro dialogue box
Ctrl + 6 - Show or Hide Objects
Shift + F10 - Show right-click menu
Shift + F11 - Insert a new worksheet
Ctrl + PgDn - Jump to the next worksheet
Ctrl + PgUp - Jump to the previous worksheet
Alt + O - Rename the current worksheet
Alt + E - Delete current worksheet
Ctrl + F2 - Print preview
Alt + P - Print area setting
Alt + R - Protect sheet
Ctrl + Tab - Jump to the next workbook
Ctrl + Shift + Tab - Jump to the previous workbook
Ctrl + F9 - Minimize current workbook window
Ctrl + F10 - Maximize current workbook window
Ctrl + F4 - Close current workbook
Alt + F4 - Close excel
Ctrl + ---> - Jump to the right edge of data region
Ctrl + <--- - Jump to the left edge of data region
Ctrl + ↑ - Jump to the top of the data region
Ctrl + ↓ - Jump to the bottom of the data region
Home - Jump to the beginning of row
Ctrl + End - Jump to the last cell containing data
Ctrl + Home - Jump to the first cell
Shift + F8 - Add to selection
Esc - Escape
Ctrl + Shift + O - Select cells with comments
Shift + F2 - Insert or edit comment
Alt + Enter - Start a new line in the same cell
Ctrl + Shift + ; - Insert the current time
Ctrl + ' - Copy the content from the above cell
Ctrl + 1 - Format cells
Ctrl + 5 - Apply or remove strikethrough of the selected text
Ctrl + Shift + ~ - Apply general format
Ctrl + Shift + ! - Apply number format
Ctrl + Shift + @ - Apply time format
Ctrl + Shift + # - Apply date format
Ctrl + Shift + $ - Apply currency format
Ctrl + Shift + % - Apply percentage format
Ctrl + Shift + ^ - Apply scientific format
Ctrl + Shift + & - Add border around selected cells
Ctrl + Shift + - - Remove borders around selected cells
Shift + F3 - Open the Insert function dialog box
Alt + = - Autosum
Ctrl + Shift + A - Insert function arguments
Shift + F9 - Calculate active worksheet
Ctrl + 0 - Hide columns
Ctrl + 9 - Hide rows
Ctrl + Shift + 9 - Unhide rows
