Some helpful tips on how to get someone to look at a particular cell in your sheet.
Academy ↓
Hey there stranger!
How To Get Someone to look at a Cell in Your Sheet
About this Tutorial
Video Transcript
0:00 So you want someone to look at something in a Google Sheet, and you want to bring their attention to it.
0:05 And sometimes it's actually really difficult because there's a lot of stuff going on in Google Sheets. So in this case, we have like a trip itinerary.
0:12 We have a start date, and we maybe don't know the end date. We're like, hey, someone in our group needs to select an end date.
0:19 We may even select something say, hey, we want everyone to like look at this. So we'll use some colors like even this garish blue over here which what I like to use sometimes when I'm like, you really have to look at this because it's one of the most contrasting colors.
0:36 But if your sheet is a lot of colors or it has a lot of information, maybe just a color might not actually help here, especially if you have lots of colors with, uh, in drop down menus and you're maybe using a lot of drop down menus, a lot of chips.
0:55 I like to actually sometimes bring these down to advanced options back to the arrow. Here, that makes it a little bit bigger over here, and as you can see, it's sort of, again, getting muddled.
1:09 We can add a few sort of notes and comments, right? Actually, there's a couple ways to do notes and comments.
1:15 One is right click, insert note, and it says like, hey, look at this, at this. But, if we click away, it's just this tiny little red corner in this note.
1:28 We can delete that note. If we add a comment, let's comment, hey, look at this, everyone. We'll comment it, and when we're not clicking on it, the, it's a little orange button.
1:49 We can click on it and see it here. We can also see, I think, over on the right side, there'll be like a comment.
1:55 You can view the comments over here. Show all comments. They'll be over here. And comments are really good for discussing topics and looking at things because they're tracked, and someone can say, mark as resolved, they can reply to that comment, you can have like a whole conversation about things.
2:16 But it still like doesn't, sometimes that gets muddled if you have lots of conversations and you're like, hey, at the end of the day, I just need someone to look at this end date and make sure it's correct.
2:26 Well, I want to show you a little thing that you might not know about. Which is you can bring interesting shapes and colors into Google Sheets.
2:35 You can go Insert, Drawing, and you can bring arrows, you can even write your own, create your own here, uhm, sort of shapes and lines.
2:45 We can have a scribble, and we can say, hey, look at this. We can do crazy things like this. We can increase the pixel size.
3:02 A lot. And make a really crazy arrow, right? Save. And that's going to show right here. And we can change that size. And we can say, right there.
3:14 But like, that's a little bit crazy, but it really is well defined. Like it's out of the shape of normal Google Sheets, right?
3:24 We can do something a little more, uh, defined, which is they have some arrow shapes here. We can select, say, this arrow.
3:36 And draw it here. We can also change the angle. Changing the angle actually helps a lot. Change the color. We will add new border.
3:49 We want to make it a little bit longer, maybe? A little bit wider. actually a little bit shorter there see if it and close and this one is definitely garish, but you're going to see it.
4:06 You're going to be like, hey, I can definitely see this. Like, I know someone should be looking at this, wherever this arrow is, right?
4:17 You can't miss it. Like the color, right, this blue color works, but maybe we don't want to have that blue color.
4:23 Maybe it's a little bit like there. But we're like, that arrow we definitely see. And I think the arrow is helpful because it's a different angles.
4:31 You can do different colors, but the angles really, we look at Google Sheets like a grid, right? We see rows, we see columns, and these are relationships we see all the time.
4:40 But this kind of angled arrow is going to really bring attention to the thing we need. We can't rely on comments, can't rely on, especially can't rely on notes, uh and colors sometimes get busy here.
4:55 So this angled arrow, I think, is a really good tip to add to your sheets if you're reading trying to get someone to see one particular part of your sheet.
0:05 And sometimes it's actually really difficult because there's a lot of stuff going on in Google Sheets. So in this case, we have like a trip itinerary.
0:12 We have a start date, and we maybe don't know the end date. We're like, hey, someone in our group needs to select an end date.
0:19 We may even select something say, hey, we want everyone to like look at this. So we'll use some colors like even this garish blue over here which what I like to use sometimes when I'm like, you really have to look at this because it's one of the most contrasting colors.
0:36 But if your sheet is a lot of colors or it has a lot of information, maybe just a color might not actually help here, especially if you have lots of colors with, uh, in drop down menus and you're maybe using a lot of drop down menus, a lot of chips.
0:55 I like to actually sometimes bring these down to advanced options back to the arrow. Here, that makes it a little bit bigger over here, and as you can see, it's sort of, again, getting muddled.
1:09 We can add a few sort of notes and comments, right? Actually, there's a couple ways to do notes and comments.
1:15 One is right click, insert note, and it says like, hey, look at this, at this. But, if we click away, it's just this tiny little red corner in this note.
1:28 We can delete that note. If we add a comment, let's comment, hey, look at this, everyone. We'll comment it, and when we're not clicking on it, the, it's a little orange button.
1:49 We can click on it and see it here. We can also see, I think, over on the right side, there'll be like a comment.
1:55 You can view the comments over here. Show all comments. They'll be over here. And comments are really good for discussing topics and looking at things because they're tracked, and someone can say, mark as resolved, they can reply to that comment, you can have like a whole conversation about things.
2:16 But it still like doesn't, sometimes that gets muddled if you have lots of conversations and you're like, hey, at the end of the day, I just need someone to look at this end date and make sure it's correct.
2:26 Well, I want to show you a little thing that you might not know about. Which is you can bring interesting shapes and colors into Google Sheets.
2:35 You can go Insert, Drawing, and you can bring arrows, you can even write your own, create your own here, uhm, sort of shapes and lines.
2:45 We can have a scribble, and we can say, hey, look at this. We can do crazy things like this. We can increase the pixel size.
3:02 A lot. And make a really crazy arrow, right? Save. And that's going to show right here. And we can change that size. And we can say, right there.
3:14 But like, that's a little bit crazy, but it really is well defined. Like it's out of the shape of normal Google Sheets, right?
3:24 We can do something a little more, uh, defined, which is they have some arrow shapes here. We can select, say, this arrow.
3:36 And draw it here. We can also change the angle. Changing the angle actually helps a lot. Change the color. We will add new border.
3:49 We want to make it a little bit longer, maybe? A little bit wider. actually a little bit shorter there see if it and close and this one is definitely garish, but you're going to see it.
4:06 You're going to be like, hey, I can definitely see this. Like, I know someone should be looking at this, wherever this arrow is, right?
4:17 You can't miss it. Like the color, right, this blue color works, but maybe we don't want to have that blue color.
4:23 Maybe it's a little bit like there. But we're like, that arrow we definitely see. And I think the arrow is helpful because it's a different angles.
4:31 You can do different colors, but the angles really, we look at Google Sheets like a grid, right? We see rows, we see columns, and these are relationships we see all the time.
4:40 But this kind of angled arrow is going to really bring attention to the thing we need. We can't rely on comments, can't rely on, especially can't rely on notes, uh and colors sometimes get busy here.
4:55 So this angled arrow, I think, is a really good tip to add to your sheets if you're reading trying to get someone to see one particular part of your sheet.