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
To hide the Ribbon so you have more room to work, press Ctrl+F1. To go to the Ribbon, press Alt, and then, to move between tabs, use the Right Arrow and Left Arrow keys. Then, press the key for the button you want. When you display a tab this way, the Key Tip badges for that tab’s buttons also appear. 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)
