347 647 9001+1 714 797 8196Request a Call
Call Me

10 Handy Excel tips for Mac Users

February 12, 2015
, , , , , ,

Time is money and therefore we bring to you some amazing time saving, convenient and easy Excel tips that will help you to carry excel functions in a quicker way. So give a break to your mouse and try using these Excel shortcuts.

1.Open New worksheet – Opening a new worksheet is easy but it can be a lot easier.

Use⇧+F11 and the new worksheet shall appear.

Excel shortcut for opening a new worksheet in Mac

2.Selecting, Adding and Deleting an entire column – While working on Excel sheet many a times you will require to select, add or delete the entire column so use shortcuts and save your time.

To Select the column Use^ + Spacebar

To Add the column Use^ + I

To Delete the column Use ^ + -

3.Repeat Action – If you want to repeat the same function again in the excel sheet then

Use⌘ + Yand your actions shall be repeated

Excel shortcut for repeating action in Mac

4.Insert and delete comment – Stop searching for the add/delete comment option in the ribbons menu instead use the shortcut as mentioned below.

Use⇧+Fn+F2 for inserting or editing a comment

Use⇧+Fn+F10 for deleting a comment

How to add and delete comment in excel in Mac

5.Hyperlink– Add a hyperlink in just a few seconds by using a keyboard shortcut.

Use ⌘+K and you can easily add your hyperlink

Excel shortcut to add hyperlink in Mac

6.Hide or unhide ribbon menu – With the blink of an eye you can either hide or unhide the ribbon menu in Mac.

Use⌥ +⌘ + Rto Hide as well as Unhide the Ribbon menu

How to hide/unhide the ribbon menu in Mac

7.Format Cell– Use the quick and easy way to format the cells in Excel.

Use⌘ + 1 that will open a dialog box and then you can easily format your cells.

Excel shortcut to format cells in Mac

8.Display formula– Sometimes you might want to change some data in cells but it makes no sense to change the dependent cells. So in order to find the independent cells,

Use ⌃ + ` as this will help you to differentiate between dependents and independent cells.

How to display formula in Excel

9.Create new workbook- Without the help of mouse you can easily create a new workbook.

Use ⌘ + N and the new workbook shall appear

Shortcut keys to create a new workbook in Mac

10.Create name for data- When you need to use certain data repeatedly then instead of copying again and again you can use shortcut .

Use⌃ + L and name the data to be used in future and then you can use it whenever you want by clicking on the data name.

How to create name for data in excel

Well, that’s not all we have many more tips and tricks coming up in our next blog so stay tuned and do let us know in the comments section if these tips were helpful to you.


About the Author

Trusted by Fortune 500 Companies and 10,000 Students from 40+ countries across the globe, it is one of the leading International Training providers for Finance Certifications like FRM®, CFA®, PRM®, Business Analytics, HR Analytics, Financial Modeling, and Operational Risk Modeling. EduPristine has conducted more than 500,000 man-hours of quality training in finance.


Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to and we will rectify it.

Popular Blogs: Whatsapp Revenue Model | CFA vs CPA | CMA vs CPA | ACCA vs CPA | CFA vs FRM

Post ID = 71220