If editing a formula, toggle Point mode off or on so you can use arrow keys to create a reference. Or, if editing is turned off for the cell, move the insertion point into the formula bar. Or, in a protected worksheet, move between unlocked cells.įormat in cells: keyboard shortcuts To do thisįormat a cell by using the Format Cells dialog box.įormat fonts in the Format Cells dialog box.Įdit the active cell and put the insertion point at the end of its contents. Move one cell to the right in a worksheet. Move to the previous sheet in a workbook. Move one screen to the left in a worksheet. Move one screen to the right in a worksheet. Home Move to the beginning of a worksheet. Move to the beginning of a row in a worksheet. Move to the cell in the upper-left corner of the window when Scroll Lock is turned on. Move to the last cell on a worksheet, to the lowest used row of the rightmost used column.Įxtend the selection of cells to the last used cell on the worksheet (lower-right corner). If the cells are blank, move to the last cell in the row or column. Move to the edge of the current data region in a worksheet.Įnter End mode, move to the next nonblank cell in the same column or row as the active cell, and turn off End mode. Move to the previous cell in a worksheet or the previous option in a dialog box. Reference: Keyboard shortcuts in Excel 2016 Navigate in cells: keyboard shortcuts To do this Move to the submenu when a main menu is open or selected. Shift+F10 or Context key (Windows keyboard only) When a menu or submenu is open, move to the next command. The Down Arrow, Up Arrow, Left Arrow, or Right Arrow key Move down, up, left, or right, respectively, among the items on the Ribbon. Move the focus to commands on the Ribbon. To move to a different tab, use access keys or the arrow keys. Select the active tab of the Ribbon, and activate the access keys.Īlt or F10. Work in the Ribbon tabs and menus with the keyboard shortcuts To do this
EXCEL SYMBOLS SHORTCUTS KEYS WINDOWS
Open the View tab and preview page breaks and layouts, show and hide gridlines and headings, set zoom magnification, manage windows and panes, and view macros. Open the Review tab and check spelling, add comments, and protect sheets and workbooks. Open the Data tab and connect to, sort, filter, analyze, and work with data. Open the Formulas tab and insert, trace, and customize functions and calculations. Open the Page Layout tab and work with themes, page setup, scale, and alignment. Open the Draw tab to select a drawing tool, color and line thickness. Open the Insert tab and insert PivotTables, charts, add-ins, Sparklines, pictures, shapes, headers, or text boxes. Open the Home tab and format text and numbers and use the Find tool. Open the File page and use Backstage view. Open the Tell me box on the Ribbon and type a search term for assistance or Help content. To go directly to a tab on the Ribbon, press one of the following access keys: To do this
EXCEL SYMBOLS SHORTCUTS KEYS PLUS
To display a tab on the Ribbon, press the Alt key plus the letter for the tab-for example, press Alt+ N for the Insert tab or Alt+M for the Formulas tab. To button you key tips for the access keys, just press the Alt key. The Ribbon comes Tip badges shortcuts, called Access Keys. If you’re new to the Ribbon, the information in this section can help you understand the Ribbon’s keyboard shortcut model. Keyboard shortcuts to navigate the Ribbon This table lists the most frequently used shortcuts in Excel 2016. If you have to press one key immediately after another, the keys are separated by a comma (,). If a shortcut requires pressing two or more keys at the same time, this topic separates the keys with a plus sign (+).Keys for other layouts might not correspond exactly to the keys on a US keyboard. These shortcuts refer to the US keyboard layout.Tip To keep this reference available when you work, you may want to print this topic. This includes the shortcuts that you can use to access the ribbon.īefore the start, do have a look on “ What’s new in Excel 2019 for Windows“ This article describes keyboard shortcuts, function keys, and some other common shortcut keys for Microsoft Excel 2016 for Windows.
0 kommentar(er)
