Add a button

To add a button from the Toolbar or a command from the main menu or command menu to the Favorites:

1.Run the add command in one of the following ways:

•If the Favorites group is empty, click  Add in it.

•Right-click anywhere in the Favorites group and run the Add action command from the context menu.

2.In the window that opens, select the desired command or button.

To quickly add a button from the Toolbar to the Favorites, right-click the button and run the Add to favorites command. You can use this method to add any button to the Favorites, except those buttons that are located in the Home tab, in the Font group and are displayed after clicking the button.

When added to the Favorites, the button is not removed from the Toolbar tab in which it is located.

To add a button to the Favorites to run a macro, follow the steps below:

1.On the Sidebar, click  Macros.

2.Hover the mouse cursor over the name of the desired macro and click  More.

3.In the drop-down menu, hover your mouse over the Add to Favorites command.

4.In the pane that appears, choose the icon for the button to run the macro.

When you hover the mouse cursor over the button, a tooltip will be displayed in the following format: Macro: <macro name>. When you click the button, the corresponding macro command will be run.

The button to run the macro is displayed in all spreadsheet documents on the current computer. If there is no corresponding macro in the document, the button is inactive and when you hover the mouse cursor over it, a tooltip will be displayed in the following format: Macro from another document: <macro name>.