To master how the Ribbon works, open your copy of Excel 2016 and click on each tab individually, carefully studying the Microsoft Excel Ribbon areas.ġ. The dialog box launcher button is very small and easily missed – we have magnified it for you in the screenshot above. For example, if you are looking for a font option that you cannot see within the Font group under the Home tab, click on the dialog box launcher to see additional options, like superscript and strikethrough. The dialog box launcher opens a box that has additional and advanced options relating to a specific group on the Ribbon. This makes it easy to find functions on the Ribbon in the Excel screen.Ĥ. For example, the Font group contains function buttons pertaining to changing the font type, size and color. In the example below, the Home tab is selected and the functions which display relate to essential Excel functions such as cutting and pasting, formatting text and setting cell alignment.ģ. The function buttons on the Ribbon in Excel is divided into groups of similar function buttons. To select a tab, click on any of the default tabs on the Excel 2016 Ribbon: File, Home, Insert, Page Layout, Formulas, Data, Review, View or Developer.Ģ. The function buttons that display on the Ribbon relate to the Tab that is selected. Tabs – the Excel Ribbon will change, displaying different function buttons, depending on which tab is selected. Let’s investigate each area of the Ribbon:ġ. Study the image of the Excel screen below. The Ribbon in Excel 2016 contains options for everything: from making your Excel worksheet look good and setting out how your worksheets print, to building complex financial or programmatic formulas and functions.īefore you can explore the rest of the MS Excel screen, understanding how the Ribbon and menu items are organized, is essential. The Microsoft Excel Ribbon is where you will find all the functions, options and settings to use Excel efficiently.
Test your Excel skills with the corresponding FREE Online Multiple Choice The Parts of the Excel Screen – 2016 Excel Basics Test The Excel screen comprises elements such as the Ribbon, Tabs, Quick Access Toolbar, Name Box, Formula Bar, Column and Row Labels, cells and Worksheet Tabs. If you are new to Excel, it is highly recommended that you familiarize yourself with the layout and terminology for all the parts of the Excel 2016 screen.
* Rows and columns in Excel spreadsheet / worksheet 2016
* Quick Access Toolbar in Excel – QAT options 2016 * The Ribbon in Excel 2016 – How does it work? Learn Excel Basics 2016 Free Online Microsoft Excel Tutorials The Parts of the Excel Screen Tutorial – Excel 2016 Tutorial – Learn Excel Basics 2016