Three ways to make a button in Excel

The spreadsheet Excel processor contains a huge number of options and functions, not even excluding the possibility of creating a button. At first glance, an absolutely unnecessary element may be necessary for some users. This article will show you how to make a button in Excel and snap it to a cell.

Auto figure

If you are not faced with the task of creating an original button and you do not want to bother with its complex design, then the easiest way is to make it using the standard set of tools in the program. Such a button will serve as a kind of hyperlink to go to other internal or external elements. Well, now let's go directly to the instructions on how to make a button in Excel:

1. Open the program.
2. Click the Insert tab.
3. In the “Illustrations” tool group, find the “Shapes” button and click on it.
4. A menu appears in which all kinds of geometric shapes are located. You need to choose the one that will serve as the button for clicking on the hyperlink. In this case, we will use a rounded rectangle. Click on it.
5. The selected item appears on the sheet of the table. Initially, it is unlikely to be of a suitable shape, so move it to the desired area of ​​the sheet (in some cell) and resize using special markers on the four sides of the rectangle.

After resizing and installing in a cell, our peculiar button can set the action that will occur after clicking.

1. To do this, right-click (RMB) on the rectangle.
2. Select Hyperlink.
3. In the window that appears, you need to select one of four types of links. You can make a link to an external file or an Internet resource by selecting “file, web page”; You can make a link to a place in the document by selecting the item of the same name; You can also link to another document and email. In the latter case, after clicking the button, a new letter will be created to the specified mail address.
4. We will show an example of creation with reference to a place in the document. Click on the button of the same name.
5. In the corresponding menu, you can specify the address of the cell or define another place in the document.
6. After selection, click OK.

On this, the creation of the button in the first way is completed. Now after clicking on it you will go to another sheet in the document. If you encounter any difficulties or if this method just did not suit you, then go to the second method, how to make a button in Excel.

Own image

If you think that you can create a button only from regular elements and only a hyperlink can be assigned from actions, then you are deeply mistaken. Now it will be told how to make a button in Excel to run the macro, while the button will not be ordinary, but in the form of an image that can be downloaded from the Internet:

1. In the program, go to the "Insert" tab.
2. Click on the “Picture” button, which is located in the “Illustrations” tool group.
3. The Explorer file manager window will open. It is necessary to go to the folder with the picture of the button, select it and click "Paste".
4. The selected image will appear on the program sheet. Change its location and size to your preference.
5. Click on RMB and select the "Assign Macro" action.
6. A window with a list of macros appears. You just have to select the one you need and click "OK".

After that, an interactive button will be created, respectively, you can assign a hyperlink to it, as was shown in the first method.

ActiveX Element

We have already examined two ways to make a button in Excel, move on to the third one, which is fundamentally different from the previous ones:

1. Turn on the Developer panel. To do this, in the options in the "Tape Settings" section, check the box next to "Developer".
2. Click the newly added Developer tab.
3. Click on the “Insert” button and select the first item from the drop-down menu in the “ActiveX Elements” section, which looks like a button.
4. Click anywhere on the sheet to insert a button.
5. If desired, you can change the location and size of the item.
6. To add an action to a button, double-click on it with the left mouse button.
7. A window opens with a field for entering a macro. In it you can prescribe any necessary action.
8. After entering the macro, close the window.

Now, after clicking on the button, the macro that you specified will be executed. Now you know all three ways to make a button in Excel.

Conclusion

So we examined three ways how to make active buttons in Excel. As you can see, each of them is significantly different from each other, therefore, having familiarized yourself with each of them, you can choose the most optimal one for yourself.