50 shortcut keys of ms excel | ms excel shortcut keys by getready
Here's a table with 50 commonly used Microsoft Excel shortcuts:
Command Explanation |
Shortcut Key Combination |
Save workbook |
Ctrl + S |
Copy |
Ctrl + C |
Cut |
Ctrl + X |
Paste |
Ctrl + V |
Undo |
Ctrl + Z |
Redo |
Ctrl + Y |
Select all |
Ctrl + A |
Find |
Ctrl + F |
Replace |
Ctrl + H |
Insert hyperlink |
Ctrl + K |
Insert current date |
Ctrl + ; |
Insert current time |
Ctrl + Shift + ; |
Insert column |
Ctrl + Shift + + |
Insert row |
Ctrl + Shift + |
Delete column |
Ctrl + |
Delete row |
Ctrl + Shift + = |
Move to next sheet |
Ctrl + Page Down |
Move to previous sheet |
Ctrl + Page Up |
AutoSum |
Alt + = |
Insert function |
Shift + F3 |
Format cells |
Ctrl + 1 |
Bold |
Ctrl + B |
Italicize |
Ctrl + I |
Underline |
Ctrl + U |
Strikethrough |
Ctrl + 5 |
Increase font size |
Ctrl + Shift + > |
Decrease font size |
Ctrl + Shift + < |
Align text left |
Ctrl + L |
Align text center |
Ctrl + E |
Align text right |
Ctrl + R |
Merge cells |
Ctrl + Shift + + |
Unmerge cells |
Ctrl + Shift + |
Hide column |
Ctrl + 0 |
Unhide column |
Ctrl + Shift + 0 |
Hide row |
Ctrl + 9 |
Unhide row |
Ctrl + Shift + 9 |
Insert new worksheet |
Shift + F11 |
Calculate active worksheet |
F9 |
Insert new chart |
F11 |
Go to next worksheet tab |
Ctrl + Page Down |
Go to previous worksheet tab |
Ctrl + Page Up |
Select entire column |
Ctrl + Spacebar |
Select entire row |
Shift + Spacebar |
Open the formula bar |
Ctrl + Shift + U |
Apply number format (general) |
Ctrl + Shift + ~ |
Apply number format (currency) |
Ctrl + Shift + $ |
Apply number format (percentage) |
Ctrl + Shift + % |
Apply number format (date) |
Ctrl + Shift + # |
Apply number format (time) |
Ctrl + Shift + @ |
These are just a few examples of the many shortcuts
available in Microsoft Excel. Remember that some shortcuts may vary depending
on the version of Excel or your operating system.
50 shortcut keys of ms excel | ms excel shortcut keys by getready