How To Add Button In Google Sheets

Add button to your google sheets, plus assign a macro that runs randomization :)

► Get Filip a coffee so he can work longer at night :)

► LET'S CONNECT:

SUBSCRIBE FOR MORE TUTORIALS

SHARE THIS VIDEO:

Hello everyone I created this button that randomizes this column of hashtags.
You can see how it works if I click it.

Let’s create a button and a simple macro.
To create the button go to insert, drawing.
Select shape for the button.
Double click it inside and write some text.
Change background color to be green, for example.
And font color to be white.
Select text, align it in the middle and make few adjustments.

Click save and close.

Now select the column.
Go tools macros.
It will start to record macro.
Now right click the column and hit randomise range.
Click save recording.
Add name like m1.
It will save the macro.
Now just click the button and click these three little dots.
select assign a script.

Type in the name of the macro.
Hot ok.

Now if you click the button it will randomize the column.

And this is it, a quick video about how to add a button in google sheets and assign script.
If you find this video helpful let me know in the comments below.
Thanks for watching and have a nice day.

[didulanimesh]

hi friend i want to create a hyperlink button in google sheet how can i do it

[MaksymIvasenko]

Did you make your blue button work from cell or just resize it to look like it is in cell? If the first option please tell how you manage that🙏

[kgftech]

I am Neeraj kashyap form India you are great 👍👍👍 teacher

[orkayen]

Hi, My macro involves Cell specified cell>save. So, I am going out of googlesheet to select a file from the downloads folder and save it at the first cell (3 columns and 20 rows data). When I edit the macro, I only see
/** @OnlyCurrentDoc */

function Import() {
var spreadsheet = SpreadsheetApp.getActive();

};
None of the tasks outside of googlesheet are there. Any reason for this? Does the macro work only in the sheet?

[StevenDavidsIsNo]

Just what I was looking for. Quick, easy and simple.

[esthetin]

I have no makros and i have no three dots in my button aftefr "save and close"