fbpx
Learn Excel Shortcuts

Learn Excel Shortcuts

I LOVE shortcuts, there is no doubt about it. Every single course I teach covers some of the shortcuts available within the program and I reference these throughout the day. If you want to learn the best shortcuts to use in Excel then look no further. Here are the best shortcuts for Excel plus an easy to print PDF version to help you lock these into memory.

Warning: Do not try to learn these all at once! Pick out 4 or 5 which you feel you will use the most, focus on those and locking them into memory before you pick the next 4 or 5. Before you know it, you’ll be shortcutting like a pro.

To download a PDF copy of this list, see the download link at the bottom of the page.

Keyboard Shortcuts for Excel

Ctrl + N = New workbook Ctrl + mouse wheel = Zoom in and out
Ctrl + O = Open workbook via backstage view Alt + F4 = Close the program
Ctrl + F12 = Open workbook via Open dialog F1 = Launch Help
Ctrl + S = Save workbook F2 = Edit current cell
Ctrl + P = Print preview F4 = Repeat last action/set Absolute cell reference
Ctrl + W = Close current workbook F7 = Spell Check
Ctrl + A = Select all F11 = Create a quick chart
Ctrl + Z = Undo last action F12 = Save As
Ctrl + Y = Redo last action Ctrl + Home = Go to top of worksheet
Ctrl + X = Cut Ctrl + End = Go to last cell in worksheet
Ctrl + C = Copy Ctrl + Shift + ~ = Apply General number format
Ctrl + V = Paste Ctrl + Shift + $ = Apply Currency format
Ctrl + B = Bold Ctrl + Shift + % = Apply Percentage format
Ctrl + U = Underline Ctrl + Spacebar = Highlight current column
Ctrl + I = Italics Shift + Spacebar = Highlight current row
Ctrl + F = Find/Search Shift + Home = Highlight current cell back to column A in row
Ctrl + H = Replace Text Ctrl + Shift + Home = Highlight current cell back to cell A1
Ctrl + G = Open Go To dialog box Ctrl + Shift + End = Highlight current cell to last cell in worksheet
Ctrl + K = Insert hyperlink Ctrl + Page Up = Move between worksheets
Ctrl + E = Flash Fill Ctrl + Page Down = Move between worksheets
Ctrl + 1 = Display Format Cells dialog box Tab = Move to the next cell
Alt + Tab = Switch betwen open programs Windows key + E = Launch File Explorer window

 

Download a Printable Copy

Call Now Button