A50Go to line 50, Column ACtrl+ G then type e.g. Navigate WorksheetsArrow KeysNavigate by one cell at a time in any directionPage Down/ Page UpMove one screen down/ upAlt+ Page Down/ Page UpMove one screen right/ leftTab/ Shift+ TabMove one cell to the right/ to the left in a worksheetCtrl+ Arrow KeysMove to the edge of next data region (cells that contains data)HomeMove to the beginning of rowCtrl+ HomeMove to the beginning of worksheetCtrl+ EndMove to the last cell with content of worksheetCtrl+ GDisplay the GoTo dialog boxCtrl+ G then type e.g. Overall if you are a legacy Excel user, try to get used to the Ribbon Shortcuts they seem cumbersome at first but worth the effort learning. Most all shortcuts are most likely to work exactly the same on previous versions. This should be one of the most complete Shortcut References for Excel updated to the latest versions. This is a major rework compared to previous versions. Format Cells.Ĭlick here to start your search.Other Resources. 253 Shortcuts for Microsoft Excel 2016 (Windows) 1. Then you can use the shortcut keys shown in Table 5.6. Press Ctrl+PgDn until you arrive at the Border tab. Press Ctrl+1 to display the Format Cells dialog. There are shortcut keys specifically for using the Border tab in the Format Cells dialog.
This page is intended to be a reference that you can search in your browser at any time to quickly find the shortcut keys that you want to use.Search Office SitesYou can search the websites that have the most useful and valuable information about using Microsoft Office products by using the Search Office Sites search box in the banner. The problem with shortcut keys is that we can remember only a relatively small number of them. Quick Reference for this PageShortcut keys provide the fastest and easiest way to perform many tasks, especially tasks that you need to perform repeatedly.
0 kommentar(er)
