0:00
Hey everybody. In this video tutorial,
0:02
I'm going to show you how to make a
0:04
button in a Google Sheets spreadsheet.
0:06
Right? So, if you want to create a
0:08
button that you can click on and in that
0:10
case, something happens. Here's how to
0:12
do that. So, all you have to do is click
0:15
on insert. So, go to the sheets you want
0:18
to add the button to of course. So, we
0:20
have this project management sheet and
0:22
then click on the insert uh in the menu
0:24
bar and you have to select drawing from
0:27
this list. You can either add a shape
0:29
that will look like a button like this
0:32
one and then add text to it or the other
0:35
option you have is to select the text
0:37
box option and then you can add the text
0:42
here. You can reshape the text box add
0:45
fill color uh border color border weight
0:49
change the font and so on and so forth.
0:51
You can also format the text in the
0:54
button. Once you formatted your button,
0:56
just click on save and close. And now,
0:58
as you can see, the button has been
1:00
added to our spreadsheet. So, we have
1:03
successfully created the button. If you
1:05
want to connect a script to this button.
1:08
So, you can click on this button and
1:10
something will happen in your uh
1:12
spreadsheet. What you have to do is
1:14
select the button, then click on this
1:16
three dots, and you're going to see
1:18
assign script. So if you click on that
1:20
you're going to be able to assign a
1:22
script you have written previously in
1:25
appcript module of Google sheets. So add
1:28
the name of that script and then click
1:30
on okay and that script will be applied.
1:33
Uh this is just an example so I'm not
1:34
going to show you. So that's about it.
1:37
Once you have assigned the script you're
1:38
going to be able to click on this button
1:40
and it will execute that script. So now
1:43
this is how to create a button or make a
1:45
button in a Google Sheets spreadsheet. I
1:48
hope you found this tutorial useful. If
1:50
you want to get access to our complete
1:52
Google Sheets function database or our
1:55
Google Sheets shortcut keys ebook for
1:57
free and other Google Sheets resources
1:59
and Google Sheets templates, then make
2:01
sure to check the links in the
2:03
description below. Also, if you want to
2:05
learn more about how to use Google
2:06
Sheets, make sure to check out our
2:08
YouTube channel and playlists where we
2:10
have a ton of tutorials and more Google
2:12
Sheets tutorials are coming up. So, also
2:14
make sure to subscribe.
![Video thumbnail for How To Make A Button In A Google Sheets Spreadsheet? [in 2025]](https://video-meta.open.video/resized-posters/1oD78kNAc62/res640.webp?cb=0)
