1,231 views
In video 27 of the Google Sheets series I will show you how to create an interactive button with a script. ****** SCRIPT ******* function Button_name() { var sheet = SpreadsheetApp.getActiveSpreadsheet(); var sheet = sheet.getSheetByName('Page1'); SpreadsheetApp.setActiveSheet(sheet); } ************************ In this series of videos I will teach you how to create filters in spreadsheets, drop-down lists, formulas, create a spreadsheet, create charts, pivot tables, functions, cell configuration, cell formation, vlookup function, work with images in Google Sheets, text formulas, date and time calculations, convert cell values and other important concepts to master Google Sheets. See how to create sum and subtract formulas in Google Sheets, create complex functions and advanced features in Google Sheets. ::Chapters:: 00:00 Start 01:21 Creating a button with a drawing 02:50 Editing drawings and button text 05:50 Adding an image to the button 07:15 Creating a script in Google Sheets 09:26 Scripts for buttons in a spreadsheet Class from the Google Sheets course created on the Help Digital channel. ▶️Watch all the videos in the Google Sheets course series▶️ ???? • GOOGLE SHEETS [Google Sheets] 01 -... ⤵️ Do you have any questions? Leave them in the comments! ➥ LEAVE YOUR LIKE???? ➥ SUBSCRIBE TO THE CHANNEL AND ACTIVATE THE BELL! ???? ➥ CONTACT ???? [email protected] Ⓜ️????Ⓜ️????Ⓜ️????Ⓜ️????Ⓜ️ ????On Instagram: / _techtodos ????On TikTok: / techtodos ???? ???????????????????? ???????????????????? ????????????????????: Become a member. This way you will help the channel and have access to exclusive content! ???????????????????????? ⤵️ Other videos from the Channel ▶ COMPLETE MS WORD COURSE ???? • WORD COURSE CLASS 01 - KNOWING THE AREA ... ▶ COMPLETE EXCEL COURSE ???? • EXCEL FOR BEGINNERS - CLASS 01 CONCE... ▶ COMPLETE POWER POINT COURSE ???? • POWERPOINT COURSE CLASS 01 - KNOWING ... #googleplanilhas #googlesheets