![]() ![]() ![]() 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 The very latest formulas are now supported in Excel - the latest ones being the stock formulas. 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 Buy Microsoft 365 for only 6. 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 Originally developed by the Microsoft in 1987, this software received numerous expansions of capabilities, making it the go-to source for spreadsheet editing, use of graphing tools, pivot tables, macro programming, and much more. 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 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 Notice how the Field List on the right shows not just one but a collection of tables. 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 Yes, it is easy once you know how to do it. In Excel for Mac you can use Microsoft Query to make a PivotTable using multiple worksheets from an Excel workbook as your data source. Spell-check the active worksheet or selected range PowerQuery uses the Data Model, a feature that exists but is not exposed in Excel for Mac. 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. We’ve listed the shortcuts we’ve found the most useful below. ![]()
0 Comments
Leave a Reply. |