![excel 2016 shortcut keys excel 2016 shortcut keys](https://media.gcflearnfree.org/content/563b9b9dca7fac0d9c7b3f7c_11_05_2015/getting_started_interface_interactive2.png)
We also have some great tips for managing huge spreadsheets.Ĭtrl+ Home moves the cursor to the Home position (A1).
EXCEL 2016 SHORTCUT KEYS FULL
Nail these basics to speed up your work, and check out Microsoft’s full list of Excel keyboard shortcuts for even more shortcuts. Excel navigation and shortcut keysĮxcel’s navigation and shortcut keys can help you move faster and more precisely around a spreadsheet of any size.
EXCEL 2016 SHORTCUT KEYS PC
PC World / JD SartainĮxcel’s Tell me what you want to do tab lets you type in a search query or natural-language request to help you find the right menu item or further information. Select one of the options from the list that appears, and Excel will provide instructions or take you directly to the correct place in the program. Just click this tab (or press Alt+ Q) and type your question, subject, command, feature, or option. There’s a new tab called Tell me what you want to do at the end of the Ribbon menu.
![excel 2016 shortcut keys excel 2016 shortcut keys](https://i.pinimg.com/originals/30/6d/9b/306d9bd7d9c06cc3961e3bbefbc6cdaa.jpg)
In version 2016, Excel has added a more intuitive way to access the Help information. Excel then returns a submenu list with more detailed options or provides instructions for the original request. Scroll through the options and select (double-click) the one that fits your specific needs. You can type a subject, command, feature, or option in the Search box, and Excel returns a long menu list of related items. In Excel, the Function key F1 and the white question mark at the top right side of the Ribbon menu offer access the online Help menus. Use Excel’s extensive Help menus to learn about its more complex features. We’ll be covering some of these topics in related articles, but meanwhile, you can use Excel’s heavily revamped Help files to learn about them.
![excel 2016 shortcut keys excel 2016 shortcut keys](https://i.pinimg.com/600x315/b0/d2/05/b0d2055419135d9b553851644e42d581.jpg)
Hold down shift for additional functions in Excel's menuThe more complex features, like formulas, pivot tables, macros, and custom Visual Basic programming, are the areas where most users need guidance. When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet Pressing CTRL+SHIFT+SPACEBAR a second time selects the entire worksheet. If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. With multiple cells selected, select only the active cell. Select the visible cells in the current selection. Select cells that contain formulas that directly or indirectly reference the active cell. Select cells that contain formulas that directly reference the active cell. Select all cells directly or indirectly referenced by formulas in the selection. Select all cells directly referenced by formulas in the selection. In a selected column, select the cells that don’t match the formula or static value in the active cell. In a selected row, select the cells that don’t match the formula or static value in the active cell. Select the array containing the active cell. In a workbook: activate previous workbookįill the selected cell range with the current entry. Tools, Options, View, Objects, Show All/Hide Insert, (Rows, Columns, or Cells) Depends on selectionĭelete, (Rows, Columns, or Cells) Depends on selectionįormat, Cells, Font, Font Style, Underlineįormat, Cells, Font, Effects, Strikethrough In a PivotTable report, select the entire PivotTable report. Select the current region around the active cell. Place outline border around selected cells Tools, Macro, Macros in Excel 97 Tools,Macros - in earlier versionsĬreate name by using names of row and column labelsįormat, Cells, Number, Category, Currencyįormat, Cells, Number, Category, Percentage In versions prior to 97 - Insert, Macro, 4.0 Macro Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. Hold down shift for additional functions in Excel’s menuĬalculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
![excel 2016 shortcut keys excel 2016 shortcut keys](https://i.ytimg.com/vi/s8eMqxQiUf0/maxresdefault.jpg)
While typing a formula, switch between absolute/relative refs