Page Layout – provides tools to manage the worksheet appearance, both onscreen and printed.

This tab is available in Excel 2013 and later, but like the Developer tab it is not visible by default. Insert – is used for adding different objects in a worksheet such as images, charts, PivotTables, hyperlinks, special symbols, equations, headers and footers.ĭraw – depending on the device type you're using, it lets you draw with a digital pen, mouse, or finger. Home – contains the most frequently used commands such as copying and pasting, sorting and filtering, formatting, etc. This tab was introduced in Excel 2010 as the replacement for the Office button in Excel 2007 and the File menu in earlier versions. The standard Excel ribbon contains the following tabs, from left to right:įile – allows you to jump into the backstage view that contains the essential file-related commands and Excel options.

Command button is the button you click to perform a particular action.

Dialog launchers appear in groups that contain more commands than available space.

Dialog launcher is a small arrow in the lower-right corner of a group that brings up more related commands.

Ribbon group is a set of closely related commands normally performed as part of a larger task.

Ribbon tab contains multiple commands logically sub-divided into groups.

The ribbon in Excel is made up of four basic components: tabs, groups, dialog launchers, and command buttons.

In Excel 2010, Microsoft added the ability to personalize the ribbon. The ribbon first appeared in Excel 2007 replacing the traditional toolbars and pull-down menus found in previous versions. It looks like a kind of complex toolbar, which it actually is. Microsoft Excel ribbon is the row of tabs and icons at the top of the Excel window that allows you to quickly find, understand and use commands for completing a certain task. What to know what Excel is capable of? Go explore the ribbon! A complete guide to using ribbon in Excel explains the ribbon structure, main tabs as well as how to customize, hide and restore ribbon in Excel.Īs with other Office applications, Excel ribbon is your primary interface that contains every command and feature you'll ever need.

Get developer tab in excel mac