Excel Shortcut Keys | Full Guide
Top 50 Shortcut Keys in Microsoft Excel
Today,
we’re going through the top 50 shortcut keys in Microsoft Excel. These
shortcuts have made me work more efficiently, and I think they will do the same
for you. We’ll go through the most frequently used, navigation, formatting, and
selection and action shortcuts.
Most Frequently Used Shortcut Keys
·
Close a spreadsheet: Ctrl+W
·
Open a spreadsheet: Ctrl+O
·
Save a spreadsheet: Ctrl+S
·
Copy: Ctrl+C
·
Paste: Ctrl+V
·
Undo: Ctrl+Z
·
Redo: Ctrl+Y
·
Cut: Ctrl+X
Using
the Alt key will open up more shortcut keys. Pressing Alt will reveal letters
on the screen that correspond to different controls. For example, to delete a
column, press Alt+H+D+C. To go to the formula tab, press Alt+M. Using the tab
key to move between cells can also be helpful, especially when entering numbers
or values across a row.
Navigation Shortcut Keys
·
Tab to the right: Tab
·
Tab to the left: Shift+Tab
·
Move to the rightmost cell: Ctrl+Right Arrow
·
Move to the leftmost cell: Ctrl+Left Arrow
·
Move to the top cell: Ctrl+Up Arrow
·
Move to the bottom cell: Ctrl+Down Arrow
·
Move to the first cell in a row: Home
·
Move to the last cell in a row: End
Formatting Shortcut Keys
·
Apply bold formatting: Ctrl+B
·
Apply italic formatting: Ctrl+I
·
Apply underline formatting: Ctrl+U
·
Apply strikethrough formatting: Ctrl+5
·
Apply general formatting: Ctrl+Shift+~
·
Apply currency formatting: Ctrl+Shift+$
·
Apply percentage formatting: Ctrl+Shift+%
·
Apply exponential formatting: Ctrl+Shift+^
·
Format cells: Ctrl+1
Selection and Action Shortcut Keys
·
Select the entire sheet: Ctrl+A
·
Select the current region: Ctrl+Shift+*
·
Select the current array: Ctrl+/
·
Insert a new worksheet: Shift+F11
·
Delete a worksheet: Alt+E+L
·
Insert a new column: Ctrl+Shift+=
·
Delete a column: Ctrl+-
·
Insert a new row: Ctrl+Shift+=
·
Delete a row: Ctrl+-
·
Fill down: Ctrl+D
·
Fill to the right: Ctrl+R
·
AutoSum: Alt+=
·
Sort ascending: Alt+A+S+A
·
Sort descending: Alt+A+S>D
·
Insert a hyperlink: Ctrl+K
Navigating and Formatting Cells in Excel
To
navigate within a worksheet, use the shortcut keys: Ctrl+Home to go to the top left
cell, Ctrl+End to go to the last cell, and Ctrl+Page
Up/Down to
move between sheets within a workbook.
To
move to the edge of the current data region, use Ctrl+Arrow
Key.
To
scroll up or down a page at a time, use Page Up/Down. To move left or right,
combine with the Alt key.
To
format cells, use Ctrl+1 to bring up the formatting dialog. To
add or edit a cell comment, use Shift+F2.
To
insert a table, use Ctrl+T (or Ctrl+L). To insert the current
time, use Ctrl+Shift+Colon. To insert the current date, use Ctrl+Semicolon.
To
quickly copy formatting, use Ctrl+D to fill down,
and Ctrl+R to fill right.
To
apply formatting with a few clicks of the keyboard, use the following
shortcuts: Ctrl+Shift+Exclamation Mark for comma format, Ctrl+Shift+At
Sign for
time format, Ctrl+Shift+Number Sign for date format, Ctrl+Shift+Dollar
Sign for
dollar format, Ctrl+Shift+Percentage Sign for percentage format,
and Ctrl+Shift+Carrot Symbol for scientific format.
To
select the entire worksheet, use Ctrl+A or Ctrl+Shift+Spacebar. To select multiple cells,
use Shift+Arrow Key. To select an entire set of cells, use Ctrl+Shift+Arrow
Key.