How To Add Button In Google Sheets скачать в хорошем качестве

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 :) https://www.buymeacoffee.com/FilipDelac ► LET'S CONNECT: Facebook:   / filipdelac2   Linkedin:   / filip-delac   SUBSCRIBE FOR MORE TUTORIALS ► http://bit.ly/subscribe-for-more-tuto... SHARE THIS VIDEO: ►    • How To Add Button In Google Sheets   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.