Cut down unnecessary seconds spent browsing through menus and use shortcuts instead. Using shortcuts is one of the most effective ways of speeding up your workflow. Go to the Picture Format tab when cursor is on an image Keyboard shortcuts have been around for as long as Microsoft Excel itself. Go to the Table Design tab when cursor is on a table Top 100+ Best Microsoft Excel Shortcut Keys (Excel 2013 to MS Office 365) Excel Filter Shortcuts Ctrl + Shift + L: Apply or clear filter of a range of data (. Go to the Format tab when cursor is on a chart Go to the Chart Design tab when cursor is on a chart Toggle between displaying formulas and cell valuesĬopy and paste the formula from the cell above into the current oneĬalculate all worksheets in all workbooks that are open When in the formula bar, select all text from the cursor to the endĭisplay Quick Analysis options for selected cells that contain dataĭisplay the Style dialog box (Windows) / Modify Cell Style dialog box (Mac)Īpply the Currency format with two decimal placesĪpply the Percentage format with no decimal placesĪpply the Date format using day, month, and yearĪpply the Time format using the 12-hour a hyperlink When in the formula bar, move the cursor to the end of the text
From the drop-down menu under Choose commands from, select All Commands. Click the Quick Access Toolbar category on the left. To customize the Quick Access Toolbar and create keyboard shortcuts: Click the File tab in the Ribbon and then click on Options. Shift-PgDn / Shift-PgUp or Shift-Fn-down arrow / Shift-Fn-up arrowĮxtend selection to the beginning of a rowĮxtend selection to the beginning of the worksheetĬontrol-Shift-Home or Control-Shift-Fn-left arrowįinish entering data in a cell and move to the next cell down / up Creating a keyboard shortcut by customizing the Quick Access Toolbar. If more than one worksheet is open, switch to the next one Switch between the worksheet, the Ribbon, the task pane, and Zoom controls Move to the word to the right while in a cell Move to the word to the left while in a cell selection w/o holding down the CTRL key extend the selection to the last cell. Move to the last cell that has content in it This table lists the most frequently used shortcuts in Excel 2016. Move one worksheet tab to the left / rightĬontrol-Page Down / Control-Page Up or Option-right arrow / Option-Left arrow Option-Page Up / Option-Page Down or Fn-Option-up arrow / Fn-Option-down arrow
Microsoft excel keyboard shortcuts pdf#
Page Up / Page Down or Fn-down arrow / Fn-up arrow Download the Free Excel Shortcuts Cheat Sheet PDF Print, ctrl+p, ctrl+p Save, ctrl+s, ctrl+s Save as, f12, +shift+s Go to next workbook, ctrl+tab, +. Spell-check the active worksheet or selected range Useful Excel keyboard shortcuts Source: Microsoft Action Note: On Macs, the ⌘ key is the same as the Command or Cmd key. Can also click the top left square of the worksheet to select all spreadsheet cells. Press Alt again to see KeyTips for the options for the selected tab. For example, press Alt+H to open the Home tab, and Alt+Q to move to the Tell me or Search field. For even more shortcuts, see Microsoft’s Office site. You can combine the Key Tips letters with the Alt key to make shortcuts called Access Keys for the ribbon options. Most work whether you’re using a subscription (Microsoft 365/Office 365) or non-subscription version of Excel. We’ve listed the shortcuts we’ve found the most useful below. (Fewer shortcuts are available for the Mac, but you can create your own custom keyboard shortcuts if you like.)
Microsoft excel keyboard shortcuts mac#
There are keyboard shortcuts to accomplish a vast array of tasks in the Excel desktop client, in both the Windows and Mac versions. Handy Excel keyboard shortcuts for Windows and Mac Get work done more quickly by using keyboard shortcuts in the Microsoft Excel desktop app for Windows or macOS. Why bother to lift your hands from the keyboard if you want to open or close a file, apply formatting to cells, navigate through workbooks, undo and redo actions, calculate all worksheets in all open workbooks, and more? With keyboard shortcuts you won’t have to. If you use Excel a lot in your job or personal life, these are really worth knowing and using.Excel’s Ribbon is great for finding everything you might ever want to do in a spreadsheet, particularly things you don’t do frequently, like managing and querying data connections or automatically grabbing geographic statistics from the internet and inserting them into cells.īut if you’re looking to do things fast, you’ll find keyboard shortcuts far more useful. There are a lot of others, but I think these are the most useful. These are the keyboard shortcuts I have found essential.