Use These 24 Microsoft Excel Shortcuts to Change Your Life at Work (Windows & Mac)

Blog
·
October 26, 2023
·
By
Nicholas K

For many employers and HR managers, Microsoft Excel is a big part of everyday processes in the office. Of course, Excel is a hugely useful tool that comes in handy for a wide range of tasks and processes, with the capability to format, organise, and calculate data in spreadsheet(s). Plus, with multiple views and filters available, Excel is also a great way for analysts and users to read and assess data, usually housed in a grid of cells that are placed in rows and columns.

Whatever your use for Excel may be, it's clear that these processes and work can be time-consuming and tedious — that is, unless you know the best ways to get the most out of the software, in the quickest way,.

With that in mind, we've compiled a comprehensive list of hotkeys and shortcuts to use on Microsoft Excel to help get your work quicker, and more efficiently. The best part? We've prepared versions for both Windows and Mac OS users.

Windows users:

No alternative text description for this image

No alternative text description for this image

No alternative text description for this image

Mac OS

No alternative text description for this image

No alternative text description for this image

No alternative text description for this image

Why you need Excel shortcuts

So, why do you even need to use these hotkeys? Essentially, keyboard shortcuts and hotkeys significantly cut down on the amount of time it takes to complete an action (this applies to every app/software, of course). For each hotkey, you save valuable seconds searching for specific functions in various menus or toolbars, and these eventually add up to help you save time and energy in the long run.

However, it's difficult to memorise every Excel shortcut out there — which is why we compiled the most handy hotkeys above in image format for your easy reference. Simply save the images above to a convenient folder on your computer, or bookmark this article to find these handy shortcuts readily available.

Need help digitalising your HR?

Speak to the altHR team today!
Contact Us Now

Sign up for altHR

Success!

Your submission has been received! One of our Customer Success Officer will be in touch with you shortly.
Oops! Something went wrong while submitting the form.

Download our FREE Guide to HR Policies

Awesome, here's your download!

If you are interested to learn more about altHR, find out more here.

Oops! Something went wrong while submitting the form.

altHR is now FREE for all customers

Our long-term aim here at altHR is to enable Malaysian businesses to be awesome at doing what they do with CelcomDigi’s super app, altHR. That's why we've now introduced the altHR Free Plan — where you'll have access to 10 powerful modules at zero charge. And if you need more, we have a plethora of add-on modules that are available for RM1/module/employee unless otherwise stated.

Manually keeping track of HR processes like leave entitlements, and performance reviews for employees can be a challenging process for employers and HR professionals — but it doesn’t have to be. You’ll be able to handle the more complex aspects of leave policies, such as the different entitlements for different groups of employees based on tenure with the company, marital status, levels, carry-forward balances, replacement leave policy, and even leave reports.

There are even options for automatic carry-forward leave balances, or custom limits you can set. And of course, all of that works seamlessly with the other modules in the digital era. With automated processes, this makes things even easier for HR professionals, who no longer have to manually update records for leaves, expenses, and others. HR professionals are often faced with daunting, often tedious tasks on a daily basis — tasks that have become even more difficult to handle with the onset of the digital era.

But help is available, if you know where to look. Let us streamline your HR processes by managing and automating day-to-day tasks, so you won’t have to worry about things like paperwork, privacy concerns, time-tracking, or onboarding challenges. Sign up for altHR, the all-in-one digital solution that covers everything from onboarding to staff management and providing employees with information kits. You’ve done it the old way long enough.

Subscribe to the altHR Resources blog

By submitting this subscription request, I consent to altHR sending me marketing communication via email. I may opt out at any time. View altHR's Privacy Policy.
| Please enter a valid email
Awesome! Your submission has been received!
Oops! Something went wrong while submitting the form.

Sign up for altHR

Success!

Your submission has been received! One of our Customer Success Officer will be in touch with you shortly.
Oops! Something went wrong while submitting the form.

Download our FREE Guide to HR Policies

Awesome, here's your download!

If you are interested to learn more about altHR, find out more here.

Oops! Something went wrong while submitting the form.