Assign a macro to a Graphic | Google Sheets Tutorial 33
In this lesson, We are going to explore:
0:00 Getting started.
0:25 How to assign a macro to a graphic?
1:45 In-cell VS over-cell image.
2:07 How to resize the in-cell and over-cell image?
2:24 How convert the in-cell image to an over-cell image and vice versa?
All explanations are simple and to the point.
#GoogleForEducation #GoogleWorkspace #GoogleSheets
If you found this video helpful, give us an old like and share it with some people you think this could be helpful for. And if you're not already a subscriber, make sure to hit the subscribe button and also the notification bell to be notified every time a video is uploaded
Useful Link:
Ben Collins (Google Developer Expert & Data Analytics Instructor):
https://www.benlcollins.com/
Google Sheets training:
https://support.google.com/a/users/an...
Worldometer | Countries in the World:
https://www.worldometers.info/geograp...
The whole playlist link:
• How to Use Google Sheets - Detailed T...
Follow us on Pinterest:
https://www.pinterest.it/GoogleWorksp...
Sound from Zapsplat.com
Apple logo
https://iconscout.com/contributors/pi...
Windows logo
https://pixabay.com/it/users/
Welcome back, Educators.
What is the difference between the in-cell and over-cell?
Can we add more than one image inside the cell?
How to assign a macro to a graphic?
We’ll create a button using Drawing, then assign a macro to it.
Open Drawing.
Design the button as you like.
Download the graphic as a PNG file.
Click Save and close to add the graphic to the sheet.
Open Script editor.
Copy the name of the macro that we’ve created in the previous lesson.
Click the 3 dots, then click Assign a script.
Paste the function name, then click Ok.
Select the cell, then click the graphic.
Here is it, and now, no need to run the macro from the Tools menu.
We’ll add the image that we’ve download inside the cell.
Select the cell, then click Image in cell.
Select the image.
And here is it.
We resize the in-cell image by changing the column width and wow height.
While the image over cell by dragging the corners.
Right-click, then click Put image over cells.
Assign a macro to the image.
Then test it.
It works correctly.
Right-click, then click the 3 dots, then Put image in selected cell.
But now, the image doesn’t act as a button to run the macro.
We can’t assign a macro to the in-cell image. That is possible just to the over-cell image.
We can’t insert more than one image inside the same cell.
But we can change the borders to make it looks like that.
That’s it, have fun. Thanks for watching.
If you like the video, please give us a thumbs up.
And subscribe to our channel.
Смотрите видео Assign a macro to a Graphic | Google Sheets Tutorial 33 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Google Workspace Tutorial 19 Август 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,372 раз и оно понравилось 18 людям.