Excel shortcuts

15 Mac Shortcuts for Excel You Need to Know

If you're a Mac user, you know that there are certain shortcuts that make using your computer a lot easier. The same is true for Microsoft Excel. If you're not familiar with all the different shortcuts available to you, you're missing out on a lot of time-saving potential. Here are 15 Mac shortcuts for Excel that you need to know.

1. Command + N: This shortcut will create a new workbook for you. No need to go through the File menu.

2. Command + O: This shortcut will open an existing workbook. Again, no need to go through the File menu.

3. Command + S: This shortcut will save your workbook. You can also use Command + Shift + S to save your workbook as a different file type.

4. Command + P: This shortcut will print your workbook. You can also use Command + Shift + P to print to a PDF.

5. Command + Z: This shortcut will undo your last action. You can also use Command + Y to redo your last action.

6. Command + F: This shortcut will open the Find dialog box. You can also use Command + G to find the next instance of what you're looking for.

7. Command + H: This shortcut will open the Replace dialog box. You can also use Command + Shift + H to replace all instances of what you're looking for.

8. Command + A: This shortcut will select all cells in your worksheet. You can also use Command + Shift + A to select all cells in your workbook.

9. Command + B: This shortcut will bold the selected cells. You can also use Command + I to italicize the selected cells or Command + U to underline the selected cells.

10. Command + 1: This shortcut will format the selected cells as General. You can also use Command + 2 to format the selected cells as Currency or Command + 3 to format the selected cells as Percentage.

11. Command + -: This shortcut will insert a row above the selected cell. You can also use Command + Shift + - to insert a column to the left of the selected cell.

12. Command + =: This shortcut will insert a formula in the selected cell. You can also use Command + Shift + U to insert a function in the selected cell.

13. Command + ;: This shortcut will insert the current date in the selected cell. You can also use Command + Shift + ; to insert the current time in the selected cell.

14. Command + ': This shortcut will insert the value of the cell above in the selected cell. You can also use Command + Shift + ' to insert the value of the cell to the left in the selected cell.

15. Command + Shift + O: This shortcut will open the Excel Options dialog box. From here, you can change a variety of different settings to customize Excel to your liking.

These are just a few of the many different shortcuts available to you as a Mac user. By taking the time to learn these shortcuts, you can save yourself a lot of time and frustration. Do you have a favorite Excel shortcut? Share it with us in the comments below.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.