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.