There are hundreds of Excel keyboard shortcuts but we don't use them all frequently.
There'll be some that you use more often than me, but in this post I'm listing the keyboard shortcuts I use all the time.
It was hard to pick just a few, it was like being asked to pick your favourite child.
I've also compiled a list of 239 Excel Shortcuts. Learn as many as you can to improve your efficiency and how fast you work.
Let's start with some obvious ones, but still ones that you can't do without.
- The arrow keys move you around the cells in the sheet
- PAGE UP/PAGE DOWN to move up and down a screen at a time
- CTRL+HOME/END to move to the first cell/last cell with data
Save the current workbook. You can't use this often enough.
Create a new workbook.
Close the current workbook.
Cycle through open workbooks.
Move through sheets in active workbook.
Insert new worksheet
CTRL+X : Cut
CTRL+C : Copy
CTRL+V : Paste
Open the Paste Special dialog box. You can then select the paste option you want.
CTRL+Z and CTRL+Y
Undo and Redo.
Create a table. If you haven't discovered tables yet where have you been! Start using them now for all the benefits they bring.
Toggle autofilters. Do ad-hoc analysis of your data by using auto-filters. Quickly turn them on and off with this shortcut.
Edit the cell.
Toggle absolute and relative references. Essential when writing formulas.
Repeat last action.
Open the VBA editor.
Open the list of macros.
Cancel selection, cancel editing, cancel dialog box etc.
Show names. If you have created named ranges, use F3 to see a list of them, then quickly insert one into your formula.
Format. Use this to format cells, charts, all sorts of things.
Use the Quick Access Toolbar
You can customize the QAT and add commands to it that are accessible by using ALT+Num where Num is 1, 2, 3 etc.
How many of these do you use, and what other ones do you use regularly?
Very helpful…& very nyc effort…keep in touch…..
I’m finding the shortcut key to data validation as i need to use it frequently for my current work
wonderful and excellent to know much of excel short cuts.
Glad to help Edwin
Thank you very much Philip for sharing this time-saving shortcuts! Definitively it is a good resolution to learn some of them this year.
Do these shortcuts work in all Excel versions, regardless of the language?
Most of them will work at least in 2007-2016 versions. However, Microsoft has 4 different lists for these versions: keyboard-shortcuts-in-excel-for-windows
There is also a list of keyboard shortcuts that will work in Excel Online too: Keyboard-shortcuts-in-Excel-Online
Navigation – the arrow keys in conjunction with CTRL or CTRL & SHIFT, to move around or select, the ‘current region’
Not sure why this is, but in my Excel 2016 (I use Office 365), the keyboard shortcut for creating a table is CTRL+L, not CTRL+T. Which is really strange because it used to be and it even says so when I hover over the icon in the ribbon.
Anyway, thought I would share in case someone else was having the same issue.
To create an excel table, both shortcuts are functional (tables were previously referred to as lists).
It is possible that your Ctrl+T key to be customized and assigned to another operation.
and as an extension to F4 Repeat last action:
when you get over-zealous with F4ing and have to Ctrl+Z to undo, you can restart the repeat process at another location with alt+Enter (F4 will just redo your undo)
2 alternatives to the above:
I use Ctrl+W to close the current workbook (less far to stretch and I think it’s the same?)
and Ctrl+L to create a table (or move the right pinkie up slightly to become Ctrl+Shift+L for filter)
There are so many others I use frequently that I can only recall them when I need them
The first 9 on my QAT (and hence Alt+Num) are Toggle Protect Sheet , Create Pivot Table, AutoFit Column, Freeze Sheet, Paste Values, Clear Formats, Autofilter on current, Remove Duplicates and Unhide columns (Ctrl+shift+0 doesn’t work)
If anyone knows of normal single-stroke keyboard shortcuts to any of those, I’d be delighted to hear
there are also some utilities in Personal.xlsx given shortcuts (eg unhide all sheets, centre across selection, remove password, toggle status bar, remove Style bloat, convert to Proper Case), many of which should be in Excel proper imho – or am I still stuck in 2007 and they’re there already?
I don’t think that they added those actions as shortcuts, as you can see in this article, which has the shortcuts detailed by excel version: keyboard-shortcuts-in-excel-for-windows
There is also a link in that page for Excel Online shortcuts.
Hope it helps 🙂
Ctrl+. moves the Active cell in a selected region to the next corner cell of the region in a clockwise fashion.
Some of my regular shortcut keys are:
F12 (Save As)
F5 (Go To)
CTRL + ~ (Switch between show Formulas and Values mode)