If you’re like most people, you probably use Microsoft Excel for a variety of tasks. Whether you’re a student, a business owner, or just someone who likes to keep track of things, Excel is a powerful tool that can help you get your work done faster.
While Excel is already a pretty fast program, there are a few shortcuts that can help you work even faster. Here are more than 20 Excel shortcuts for Mac that will save you time:
- Command + N: Create a new workbook
- Command + O: Open an existing workbook
- Command + S: Save the current workbook
- Command + W: Close the current workbook
- Command + P: Print the current workbook
- Command + Z: Undo the last action
- Command + Y: Redo the last action
- Command + F: Find a value in the current workbook
- Command + G: Go to a specific cell in the current workbook
- Command + H: Replace a value in the current workbook
- Command + 1: Format the selected cells as numbers
- Command + 2: Format the selected cells as percentages
- Command + 3: Format the selected cells as currency
- Command + 4: Format the selected cells as dates
- Command + 5: Format the selected cells as time
- Command + 6: Format the selected cells as text
- Command + B: Bold the selected cells
- Command + I: Italicize the selected cells
- Command + U: Underline the selected cells
- Command + 7: Apply the border style to the selected cells
- Command + 8: Apply the shading style to the selected cells
- Command + 9: Apply the fill color to the selected cells
- Command + 0: Apply the font color to the selected cells
- Command + Shift + F: Apply the number format to the selected cells
- Command + Shift + G: Apply the percentage format to the selected cells
- Command + Shift + C: Apply the currency format to the selected cells
- Command + Shift + D: Apply the date format to the selected cells
- Command + Shift + T: Apply the time format to the selected cells
- Command + Shift + B: Apply the fill color to the selected cells
- Command + Shift + U: Apply the font color to the selected cells
- Command + A: Select all cells in the current workbook
- Command + Shift + A: Select all cells in the current worksheet
- Command + Spacebar: Select the entire column of the active cell
- Command + Shift + Spacebar: Select the entire row of the active cell
- Command + Arrow keys: Move to the next or previous cell in the current row or column
- Command + Shift + Arrow keys: Select multiple cells in the current row or column
- Command + Page Up/Page Down: Move to the next or previous worksheet
- Command + Home/End: Move to the first or last cell in the current row
- Command + Shift + Home/End: Select all cells from the active cell to the first or last cell in the current row
- Command + Up Arrow/Down Arrow: Move to the first or last cell in the current column
- Command + Shift + Up Arrow/Down Arrow: Select all cells from the active cell to the first or last cell in the current column
- Command + Option + Arrow keys: Move to the next or previous worksheet in the workbook
These are just a few of the many shortcuts that can save you time when you’re using Excel on your Mac. For a complete list of shortcuts, consult the Excel Help menu or visit the Microsoft website.
Excel is a powerful tool that can help you manage and analyze data with ease. However, if you’re not using shortcuts, you’re not taking full advantage of its capabilities. In this article, we’ll cover 20+ Mac Excel shortcuts that will save you time and make your work more efficient.
Navigation Shortcuts
1. Move to the beginning or end of a row or column
Press Command + Left Arrow to move to the beginning of a row or Command + Right Arrow to move to the end of a row. To move to the beginning or end of a column, press Command + Up Arrow or Command + Down Arrow.
2. Move to the next or previous worksheet
Press Command + Page Down to move to the next worksheet or Command + Page Up to move to the previous worksheet.
3. Move to the last cell in a worksheet
Press Command + End to move to the last cell in a worksheet.
Selection Shortcuts
4. Select an entire row or column
To select an entire row, click on the row number on the left side of the screen. To select an entire column, click on the column letter at the top of the screen. Alternatively, you can use Shift + Spacebar to select an entire row and Command + Spacebar to select an entire column.
5. Select multiple cells
To select multiple cells, click and drag your mouse over the cells you want to select. Alternatively, you can hold down the Shift key and use the arrow keys to select multiple cells.
6. Select non-adjacent cells
To select non-adjacent cells, hold down the Command key and click on the cells you want to select.
Editing Shortcuts
7. Copy and paste
To copy a cell or range of cells, select the cells and press Command + C. To paste the copied cells, select the destination cell and press Command + V.
8. Cut and paste
To cut a cell or range of cells, select the cells and press Command + X. To paste the cut cells, select the destination cell and press Command + V.
9. Undo and redo
To undo your last action, press Command + Z. To redo your last action, press Command + Y.
10. Insert a new row or column
To insert a new row, select the row below where you want to insert the new row and press Command + Shift + + (plus sign). To insert a new column, select the column to the right of where you want to insert the new column and press Command + Shift + + (plus sign).
11. Delete a row or column
To delete a row, select the row and press Command + – (minus sign). To delete a column, select the column and press Command + – (minus sign).
Formatting Shortcuts
12. Bold, italicize, or underline text
To bold text, press Command + B. To italicize text, press Command + I. To underline text, press Command + U.
13. Change font size
To increase font size, press Command + Shift + > (greater than sign). To decrease font size, press Command + Shift + < (less than sign).
14. Change font color
To change font color, select the cells you want to change and press Command + Shift + F. Select the color you want from the drop-down menu.
Formula Shortcuts
15. Insert a formula
To insert a formula, select the cell where you want the formula to appear and press Command + = (equal sign).
16. AutoSum
To quickly add up a range of cells, select the cell where you want the sum to appear and press Command + Shift + T.
17. Fill down or fill right
To fill down, select the cell with the formula and the cells below it, and press Command + D. To fill right, select the cell with the formula and the cells to the right of it, and press Command + R.
Other Shortcuts
18. Zoom in or out
To zoom in, press Command + + (plus sign). To zoom out, press Command + – (minus sign).
19. Hide or unhide rows or columns
To hide a row or column, select it and press Command + 0 (zero). To unhide a row or column, select the rows or columns on either side of the hidden row or column and press Command + Shift + 0 (zero).
20. Save your work
To save your work, press Command + S.
21. Print your worksheet
To print your worksheet, press Command + P.
By using these shortcuts, you can save time and work more efficiently in Excel. Try incorporating them into your workflow and see how much time you can save!
