Впервые представленная в Excel 2007, лента представляет собой полосу кнопок и значков, расположенных над рабочей областью. Лента заменяет меню и панели инструментов, которые были в более ранних версиях Excel .
Инструкции в этой статье относятся к Excel для Office 365 , Excel 2019, Excel 2016, Excel 2013 и Excel 2010.
Компоненты ленты
Лента содержит вкладки с метками Главная, Вставка, Макет страницы, Формулы, Данные, Просмотр, Просмотр и Справка. При выборе вкладки область под лентой отображает набор групп и внутри групп кнопки, представляющие различные команды.
При открытии Excel открывается вкладка «Главная», а также группы и кнопки внутри нее. Каждая группа представляет функцию. Группа Number включает команды, которые форматируют числа, например, для увеличения или уменьшения количества десятичных разрядов. В группу Cells входят параметры для вставки, удаления и форматирования ячеек.
Selecting a command on the ribbon may lead to further options contained in a contextual menu or dialog box that relate to the chosen command.
Collapse and Expand the Ribbon
The ribbon can be collapsed to increase the size of the worksheet visible on the computer screen.
There are four ways to collapse the ribbon:
- Double-click a ribbon tab, such as Home, Insert, or Page Layout to display only the tabs. To expand the ribbon, double-click a tab.
- Press CTRL+F1 on the keyboard to display only the tabs. To expand the ribbon, press CTRL+F1.
- Select Ribbon Display Options (located above the ribbon in the upper-right corner of Excel and looks like a box with an up-facing arrow) and choose Auto-hide Ribbon. Neither the tabs nor the commands will be visible. To expand the ribbon, select Ribbon Display Options, and choose Show Tabs and Commands.
- Select the up arrow located on the right side of the ribbon to collapse the ribbon and display only the tabs. To expand the ribbon, double-click a tab.
Customize the Ribbon
Since Excel 2010, it has been possible to customize the ribbon using the Customize Ribbon option. Use this option to:
- Rename or reorder the default tabs and groups.
- Display certain tabs.
- Add or remove commands to existing tabs.
- Add custom tabs and custom groups that contain frequently used commands.
There are also command features that cannot be changed on the ribbon, specifically the default commands which appear in gray text in the Customize Ribbon window, for example:
- Names of the default commands.
- Icons associated with the default commands.
- The order of these commands on the ribbon.
To add commands to the ribbon:
-
Select a tab, such as Home, Insert, or Page Layout.
-
Right-click a blank area of the ribbon.
-
Select Customize the Ribbon.
-
Go to the Main Tabs list and select the tab (for example the Layout tab) to which you want to add a command. Then select New Group.
When adding commands to the ribbon, you must create a custom group.
-
A New Group (Custom) item appears under the tab you selected. To give the group a more specific name, select Rename.
-
In the Rename window, select an icon, then go to the Display name text box and enter a descriptive name for the command. Select OK.
-
Select the group you just created.
-
In the Choose commands from list, choose the command to add to this group, then select Add.
-
Select OK. The new group and command appear on the ribbon.