January 29th, 2014 By: Ash
Do you use a Mac? If so, we’ve got you covered. Check out these awesome keyboard shortcuts on Excel for Mac and these 45 universal keyboard shortcuts for Macs.
Once you incorporate them into your daily routine they’ll save your hours each week!
In terms of time management hacks keyboard shortcuts are right up there with my 15 Siri voice commands to save an hour a week, 3 steps to overcoming procrastination using mindfulness and my 3 steps to creating targeted to do lists.
I mean, think about it. Each time you want to copy a bit of text you’ve got to go through all these steps:
You could be achieving exactly the same outcome by hitting two buttons on your keyboard CTRL + C.
Sure it’s painful to remember to use CTRL + C rather than reach for your mouse every time you want to copy. But a mindful approach can dramatically increase your chances of cultivating the habit.
And once you’ve cultivated the habit of using your keyboard rather than your mouse you’ll be amazed at how much faster you get.
Once I started using keyboard shortcuts about 8 years ago, I found that my entire workflow improved. Remembering they key combinations e.g. CTRL + C requires little or no cognitive input. Much like driving a car. It all seems to happen at a ‘spinal level’. Sort of like breathing.
Not only do I save on time executing on those 4 steps but I also have the luxury of uninterrupted “thought flow”. This is very useful when I’m hurtling towards a deadline on an excel model or a word document I promised myself I would get done.
The best piece of advice I can give you is learn one keyboard shortcut first. Go really slow and really master than one shortcut before moving to the next one.
Once you’ve started to see the dramatic time saving benefits of having learnt that first keyboard shortcut, you will find yourself dying to master the rest of them. Once your mind is open to the idea you will find your ability to memorise the shortcuts also improves quite dramatically.
What’s even better is that many of these keyboard shortcuts are universal across the various Microsoft office applications. So once you’ve learnt them on excel you’ll find that some of them can be used on word, powerpoint too.
Routine activities such as copying and pasting stuff, navigating quickly around and between spreadsheets, adding or removing formatting, are critical skills for a good excel user. Even more so if you work a lot with excel models.
So if you want to be an excel ninja then the tools are right here for you to make it happen.
Mastering these keyboard shortcuts saves me HOURS each week. It also helps dramatically when I’m in ‘the flow’ of creating a model. The thinking process is not compromised by the mechanics of navigating around a spreadsheet because that requires no more cognitive engagement on my part than riding a bike.
Also quite a few of these shortcuts translate across to the Mac – just use the Command key instead of the CTRL key in the combinations below:
I’ve categorised the shortcuts for your convenience:
Basic editing and saving shortcuts:
What’s cool is you can use these in combinations too. So for example if you want to copy to contents of an entire worksheet to another worksheet you’d just have to hit CTRL + A (to highlight all the data), hit CTRL + C (to copy all the data), move the cursor to the destination worksheet where you want to paste the data, and then hit CTRL + V.
Switching between open programs on your PC:
Border formatting shortcuts:
Entering time and date stamps into cells (super useful when creating a work tracker):
These shortcuts are incredibly powerful in creating your own work tracker – something to be explored in a future blog post. Feel free to remind me in the comments section if I forget 🙂
Navigating within and between worksheets:
This list is a great start but by no means comprehensive. What shortcuts do you use? What shortcuts do you think are missing in this post? Feel free to share your thoughts in the comments below.
If you find this information useful then please share it via email, Facebook, Twitter and any other social networks. Your referral is the ultimate compliment!