![how to open excel on mac keyboard shortcuts how to open excel on mac keyboard shortcuts](https://p7.storage.canalblog.com/76/02/992013/85918144.png)
Ctrl+Alt+V: Open the Paste Special dialog box.Ctrl+V or Shift+Insert: Paste contents of a cell, selected data, or selected cell range.Ctrl+C or Ctrl+Insert: Copy contents of a cell, selected data, or selected cell range.Ctrl+X: Cut contents of a cell, selected data, or selected cell range.Ctrl+Shift+Space: Select the entire worksheetĮxcel also provides some keyboard shortcuts for editing cells.Shift+Left/Right Arrow: Extend the cell selection to the left or right.There are also a few other combos for speeding up selection, as well. Using the Shift key to modify the arrow keys lets you extend your selected cells.
![how to open excel on mac keyboard shortcuts how to open excel on mac keyboard shortcuts](https://99signals.b-cdn.net/wp-content/uploads/2016/03/Excel-Shortcuts-Mac-v2.png)
You may have noticed from the previous section you use the arrow keys to move between cells, and the Ctrl key to modify that movement. Ctrl+Page Up/Down: Move to the previous or next worksheet.Alt+Page Up/Down: Move one screen to the right or left in a worksheet.Page Up/Down: Move one screen up or down in a worksheet.Ctrl+Home: Move to the beginning of a worksheet.Home: Go to the leftmost cell in the current row (or go to the beginning of the cell if editing a cell).F5: Go to any cell by pressing F5 and typing the cell coordinate or cell name.Ctrl+End: Go to the most bottom right used cell.Ctrl+Up/Down Arrow: Move to the top or bottom cell in the column.Up/Down Arrow: Move one cell up or down.Ctrl+Left/Right Arrow: Move to the farthest cell left or right in the row.Left/Right Arrow: Move one cell to the left or right.You can use keyboard shortcuts to easily navigate throughout your worksheet, within a cell, or throughout your entire workbook. Alt+F11: Open the Microsoft Visual Basic For Applications Editor.Alt+F8: Create, run, edit, or delete a macro.Ctrl+Tab: Switch between open workbooks.Ctrl+F: Search in a spreadsheet, or use Find and Replace.Alt+F1: Create an embedded bar chart based on select data (same sheet).F11: Create a bar chart based on selected data (on a separate sheet).Ctrl+Shift+U: Expand or collapse the formula bar.F9: Calculate all worksheets in all open workbooks.Alt+Q: Go to the “Tell me what you want to do” box.For example, if the last thing you typed in a cell is “hello,” or if you change the font color, clicking another cell and pressing F4 repeats that action in the new cell. F4: Repeat the last command or action.First, let’s take a look at some general keyboard shortcuts for manipulating workbooks, getting help, and a few other interface-related actions.