If you press the End key followed by the down arrow, your cursor moves to the last cell (A15), because A16 is an empty cell. Consider this example: Your cursor is at A1, and you have records down to A15 and fields out to column G. The End key moves the cursor to the end of any column or row that contains data before an empty cell. We also have some great tips for managing huge spreadsheets.Ĭtrl+ Home moves the cursor to the Home position (A1).
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. 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. 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. The more complex features, like formulas, pivot tables, macros, and custom Visual Basic programming, are the areas where most users need guidance.
0 kommentar(er)
