Contents
Ribbon in Microsoft Excel is the main working tool and contains most of the commands necessary to solve the tasks. In this lesson, we will look at what the Ribbon consists of, and also learn how to hide it as needed.
If you have used Excel 2010 or 2007 before, then Excel 2013 will look familiar to you. It uses all the same Tape и Quick Access Toolbar, where you can find commands for the most commonly used tasks, and backstage view.
Introduction to Lenta
Excel 2013 replaces the traditional menu with a system of logical groups and tabs called the Ribbon. The ribbon contains a series of command tabs that provide tools for performing the most common tasks in Excel.
Home
Tab Home contains the most basic commands used when working with Microsoft Excel 2013, such as copy, paste, formatting, and styles. It opens by default when you start Excel.
Insert
Tab Insert allows you to insert charts, tables, sparklines, filters, and more, which makes it possible to visualize and visualize data in your workbook.
Page layout
Tab Page layout allows you to change book formatting, including margin width, paper orientation, and theme. These commands will be especially useful when preparing a book for publication.
formula
Tab formula provides access to the most commonly used Excel tools – functions and formulas. With them, you can calculate and analyze numerical data, for example, find the average value or percentage.
Data
Tab Data simplifies sorting and filtering information in your workbook, which is especially useful when an Excel workbook contains a large amount of data.
Reviewing
Tab Reviewing opens up a wide range of text editing options, including adding notes and tracking revisions. These tools make it easy to share and work on Excel workbooks.
View
Tab View allows you to switch views of an Excel workbook and freeze panes for ease of working with them. These commands are also needed when preparing a book for printing.
Contextual tabs
Contextual tabs appear on the Ribbon when you work with certain Excel elements, such as tables or figures. These tabs contain special groups of commands that allow you to format these elements as needed.
Some programs, such as Adobe Acrobat, may install additional tabs on the Excel Ribbon. They are called Add-ons.
How to collapse and expand the Ribbon
The Ribbon is designed to make it easier to perform ongoing tasks in Microsoft Excel. However, if the Ribbon takes up too much screen space, you can always minimize it.
- Click on the arrow in the top right corner to bring up the menu Ribbon display options.
- Select the appropriate folding option from the drop-down menu.
- Auto-hide the Ribbon: When this option is selected, the document is displayed in full screen mode, and the Ribbon is minimized completely. To see the Ribbon, click on the command Expand Ribbon at the top of the screen.
- Show tabs: When this option is selected, all unused command groups are hidden and the tabs remain visible. To open the Ribbon, simply click on any tab.
- Show tabs and commands: When this option is selected, the Ribbon expands completely. All tabs and commands will be visible. This option is selected by default when you first open Microsoft Office Excel.
- Auto-hide the Ribbon: When this option is selected, the document is displayed in full screen mode, and the Ribbon is minimized completely. To see the Ribbon, click on the command Expand Ribbon at the top of the screen.
To learn how to add custom tabs and commands to the Ribbon, take a look at Customizing the Ribbon.
To learn how to use the Ribbon on touch screen devices, check out the tutorial on activating touch mode.