#Excel shortcuts mac cheat sheet for mac#
#Excel shortcuts mac cheat sheet full#
#Excel shortcuts mac cheat sheet mac#

Alternatively, you can use Shift + Spacebar to select an entire row and Command + Spacebar to select an entire column. To select an entire column, click on the column letter at the top of the screen. To select an entire row, click on the row number on the left side of the screen. Press Command + End to move to the last cell in a worksheet. Press Command + Page Down to move to the next worksheet or Command + Page Up to move to the previous worksheet. To move to the beginning or end of a column, press Command + Up Arrow or Command + Down Arrow. Press Command + Left Arrow to move to the beginning of a row or Command + Right Arrow to move to the end of a row. Move to the beginning or end of a row or column

#Excel shortcuts mac cheat sheet mac#

In this article, we'll cover 20+ Mac Excel shortcuts that will save you time and make your work more efficient.

#Excel shortcuts mac cheat sheet full#

However, if you're not using shortcuts, you're not taking full advantage of its capabilities. For a complete list of shortcuts, consult the Excel Help menu or visit the Microsoft website.Įxcel is a powerful tool that can help you manage and analyze data with ease. These are just a few of the many shortcuts that can save you time when you're using Excel on your Mac. Command + Option + Arrow keys: Move to the next or previous worksheet in the workbook.Command + Shift + Up Arrow/Down Arrow: Select all cells from the active cell to the first or last cell in the current column.Command + Up Arrow/Down Arrow: Move to the first or last cell in the current column.Command + Shift + Home/End: Select all cells from the active cell to the first or last cell in the current row.Command + Home/End: Move to the first or last cell in the current row.Command + Page Up/Page Down: Move to the next or previous worksheet.Command + Shift + Arrow keys: Select multiple cells in the current row or column.Command + Arrow keys: Move to the next or previous cell in the current row or column.Command + Shift + Spacebar: Select the entire row of the active cell.Command + Spacebar: Select the entire column of the active cell.Command + Shift + A: Select all cells in the current worksheet.Command + A: Select all cells in the current workbook.Command + Shift + U: Apply the font color to the selected cells.Command + Shift + B: Apply the fill color to the selected cells.Command + Shift + T: Apply the time format to the selected cells.Command + Shift + D: Apply the date format to the selected cells.Command + Shift + C: Apply the currency format to the selected cells.Command + Shift + G: Apply the percentage format to the selected cells.

Command + Shift + F: Apply the number format to the selected cells.Command + 0: Apply the font color to the selected cells.Command + 9: Apply the fill color to the selected cells.Command + 8: Apply the shading style to the selected cells.Command + 7: Apply the border style to the selected cells.Command + U: Underline the selected cells.Command + I: Italicize the selected cells.Command + 6: Format the selected cells as text.

Command + 5: Format the selected cells as time.

Command + 4: Format the selected cells as dates.

Command + 3: Format the selected cells as currency.

Command + 2: Format the selected cells as percentages.

Command + 1: Format the selected cells as numbers.

Command + H: Replace a value in the current workbook.

Command + G: Go to a specific cell in the current workbook.

Command + F: Find a value in the current workbook.

Command + P: Print the current workbook.

Command + W: Close the current workbook.

#Excel shortcuts mac cheat sheet for mac#

Here are more than 20 Excel shortcuts for Mac that will save you time: While Excel is already a pretty fast program, there are a few shortcuts that can help you work even faster. 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. If you're like most people, you probably use Microsoft Excel for a variety of tasks.