Looking for more help with Excel for Windows? If you have an Office subscription, see " Excel for Office 365/Microsoft 365 cheat sheet." If you have a non-subscription version of Office, see " Excel 20 cheat sheet." We've also got cheat sheets for an array of other Microsoft products, including older versions of Office. Go to the Picture Format tab when cursor is on an image Go to the Table Design tab when cursor is on a table 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 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 Scroll through the list or use the Index to quickly go to the section you want. Below is a huge list of 239 Excel keyboard shortcuts + a Periodic Table you can use to work faster.
Mac shortcuts for excel windows#
Simply select the last row in your table, press Command + Shift + T, and Excel will automatically insert a new row with the AutoSum formula. Excel Keyboard Shortcuts for Windows & Mac. This shortcut allows you to quickly insert a total row at the bottom of your table. If more than one worksheet is open, switch to the next one The first shortcut on our list is Command + Shift + T. 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 Move to the last cell that has content in it 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
Page Up / Page Down or Fn-down arrow / Fn-up arrow 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. For even more shortcuts, see Microsoft’s Office site. Most work whether you’re using a subscription (Microsoft 365/Office 365) or non-subscription version of Excel.
Mac shortcuts for excel for windows 10#
Excel for Microsoft 365 Word for Microsoft 365 Outlook for Microsoft 365 PowerPoint for Microsoft 365 Access for Microsoft 365 OneNote for Microsoft 365 Project Online Desktop Client Visio Plan 2 Visio in Microsoft 365 Visio Plan 1 Excel 2021 Word 2021 Outlook 2021 PowerPoint 2021 Access 2021 Project Professional 2021 Visio Professional 2021 Visio Standard 2021 Office 2021 OneNote 2021 Excel 2019 Word 2019 Outlook 2019 PowerPoint 2019 Access 2019 Project Professional 2019 Visio Professional 2019 Visio Standard 2019 Office 2019 Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 Access 2016 OneNote 2016 Project Professional 2016 Visio Professional 2016 Visio Standard 2016 Office 2016 Excel 2013 Word 2013 Outlook 2013 PowerPoint 2013 Access 2013 OneNote 2013 Office 2013 Excel for iPhone Word for iPhone PowerPoint for iPhone Excel 2010 Word 2010 Outlook 2010 PowerPoint 2010 Access 2010 OneNote 2010 Office 2010 Excel 2007 Word 2007 PowerPoint 2007 Office 2007 Excel for Android phones Outlook Calendar for Windows 10 Outlook Mail for Windows 10 PowerPoint for Android phones Word for Android phones More.We’ve listed the shortcuts we’ve found the most useful below.
0 kommentar(er)
