Here’s a list of excel shortcut keys that can help you improve your productivity when working with spreadsheets in Excel.
Column 1 | Column 2 |
Absolute/relative/mixed reference | F4 |
AutoSum | Alt = |
Bold | Ctrl-B |
Border lines off | Ctrl-Shift _ |
Border lines on | Ctrl-Shift & |
Calculate active sheet | Shift-F9 |
Calculate all worksheets | F9 |
Close | Ctrl-W |
Collapse selection to active cell | Shift-Backspace |
Comment insert/edit | Shift-F2 |
Copy | Ctrl-C |
Copy formula from cell above | Ctrl ‘ |
Copy value from cell above | Ctrl-Shift “ |
Cut | Ctrl-X |
Date | Ctrl ; |
Delete range | Ctrl – |
Delete to end of line | Ctrl-Del |
Show values/formulas | Ctrl ` |
Edit cell | F2 |
Enter formula as array | Ctrl-Shift-Enter |
Fill down | Ctrl-D |
Fill right | Ctrl-R |
Find | Ctrl-F |
Format commas (2 decimal places) | Ctrl-Shift ! |
Format currency (2 decimal places) | Ctrl-Shift $ |
Format date (day, month, year) | Ctrl-Shift # |
Format exponential number (2 decimal places) | Ctrl-Shift ^ |
Format general number | Ctrl-Shift ~ |
Format percentage (0 decimal places) | Ctrl-Shift % |
Format time (hour and minute) | Ctrl-Shift @ |
Formula | = |
Function Wizard | Shift-F3 |
GoTo | Ctrl-G |
Group row/column | Alt-Shift-Right |
Hard Return in cell | Alt-Enter |
Hide selected column(s) | Ctrl-0 (zero) |
Hide selected row(s) | Ctrl-9 |
Insert chart sheet | F11 |
Insert Function components | Ctrl-Shift-A |
Insert range | Ctrl-Shift-Plus |
Insert worksheet | Shift-F11 |
Italics | Ctrl-I |
Menu bar | F10 |
Move between noncontiguous selections | Ctrl-Alt-Left/Right |
Move left/right one screen | Alt-PgUp/PgDn |
Move to beginning of worksheet | Ctrl-Home |
Move to edge of region | Ctrl-Arrow |
Move to end of row | End, Enter |
Move to end of worksheet | Ctrl-End |
Move to next corner of selection | Ctrl . |
Move up through a selection | Shift-Enter |
Name a range (Insert/Name/Create) | Ctrl-Shift-F3 |
Name a range (Insert/Name/Define) | Ctrl-F3 |
New | Ctrl-N |
Next window | Ctrl-F6 |
Next worksheet | Ctrl-PgUp |
Open | Ctrl-O |
Outline symbols display/hide | Ctrl-8 |
Paste | Ctrl-V |
Paste named range (Insert/Name/Paste) | F3 |
Previous window | Ctrl-Shift-F6 |
Previous worksheet | Ctrl-PgDn |
Ctrl-P | |
Repeat Find | Shift-F4 |
Repeat/Redo | Ctrl-Y |
Replace | Ctrl-H |
Save | Ctrl-S |
Save As | F12 |
Scroll to display active cell | Ctrl-Backspace |
Select array to which active cell belongs | Ctrl / |
Select cells directly referred to by selected formula | Ctrl [ |
Select cells referred to by selected formula | Ctrl-Shift { |
Select cells with comments | Ctrl-Shift ? |
Select column | Ctrl-spacebar |
Select current region | Ctrl-Shift * |
Select formulas that directly refer to active cell | Ctrl ] |
Select formulas that refer to active cell | Ctrl-Shift } |
Select objects on worksheet | Ctrl-Shift-spacebar |
Select row | Shift-spacebar |
Select to beginning of row | Shift-Home |
Select to beginning of worksheet | Ctrl-Shift-Home |
Select to edge of region | Ctrl-Shift-(Arrow) |
Select to end of row | End, Shift-Enter |
Select to end of worksheet | Ctrl-Shift-End |
Select visible cells in selection | Alt ; |
Select worksheet | Ctrl-A |
Shortcut menu | Shift-F10 |
Spelling and Grammar check | F7 |
Strikethrough on/off | Ctrl-5 |
Style box | Alt ‘ |
Tab inserted | Ctrl-Alt-Tab |
Time | Ctrl-Shift-Colon |
Underline | Ctrl-U |
Undo | Ctrl-Z |
Ungroup row/column | Alt-Shift-Left |
Unhide column(s) | Ctrl-Shift ) |
Unhide row(s) | Ctrl-Shift ( |
Charlie Harris says
I have tried to put a shortcut key in an IF function. eg if a10=a12 do nothing or enter ctrl+d
How do I get this to work.
Thanks
Charlie
New Zealand
ms office says
Microsoft Office is still the best program when it comes to spreadsheet and word processing
officeuser says
i use both open office and microsoft office and i would say that microsoft office is more responsive and user friendly
Danna says
I would like to download the above shortcut table.
I tried copy/paste but that did not work.
karen says
@Danna–copy then in excel, right click, paste special choose text. that should work for you.