1
00:00:00,780 --> 00:00:05,370
Let's take a look at how we can add tool tips or screen tips in Excel.

2
00:00:05,380 --> 00:00:07,890
Assume you've created this template.

3
00:00:07,890 --> 00:00:12,750
It's an invoice template that you want to share with your colleagues so they can create their invoices

4
00:00:12,750 --> 00:00:19,260
for their clients. To help them know what they should input where, you've decided to add screen tips to

5
00:00:19,260 --> 00:00:20,010
this sheet.

6
00:00:20,010 --> 00:00:26,380
So instead of adding comments for like client name, address, or payment terms, you've added tool tips.

7
00:00:26,400 --> 00:00:32,640
So every time they come and click on the cell they see this additional information that you've shared

8
00:00:32,640 --> 00:00:33,120
with them.

9
00:00:33,330 --> 00:00:40,530
So for example "input your contact person on the client side", for services "add services ensure you have

10
00:00:40,560 --> 00:00:42,330
one line per topic"

11
00:00:42,480 --> 00:00:46,810
Time period you've told them how they should input the date.

12
00:00:46,890 --> 00:00:48,930
Payment terms, they should updated accordingly.

13
00:00:48,930 --> 00:00:54,420
This is a simple feature that can really impress people and it's super easy to use.

14
00:00:54,420 --> 00:00:56,640
So let's go over how we can set this up.

15
00:00:57,180 --> 00:00:59,700
All we need is data validation.

16
00:00:59,790 --> 00:01:02,910
Except we're not going to use a specific criteria.

17
00:01:02,910 --> 00:01:04,620
We're just going to leave that be.

18
00:01:04,680 --> 00:01:10,410
You could of course add a criteria if you want to make sure they input the date correctly or they input

19
00:01:10,470 --> 00:01:15,780
number and not text. But you don't have to if you just want to use the tool tip feature.

20
00:01:16,170 --> 00:01:18,870
It's called input message in data validation.

21
00:01:18,870 --> 00:01:20,160
So let's take a look.

22
00:01:20,250 --> 00:01:23,930
Let's go to Data validation. Now for settings,

23
00:01:23,940 --> 00:01:25,750
I'm just going to leave this as is.

24
00:01:25,770 --> 00:01:29,200
They can input any value in the cell. Input message

25
00:01:29,220 --> 00:01:30,480
that's my tool tip.

26
00:01:31,110 --> 00:01:36,450
I can give it a title if I want or I can just give it the text.

27
00:01:36,480 --> 00:01:40,690
Click on OK and I have the tool tip right here.

28
00:01:40,800 --> 00:01:43,500
I can do that for any cell that I want.

29
00:01:43,500 --> 00:01:50,520
All you have to do is go to Data Validation and put in an input message and that's it.

30
00:01:50,520 --> 00:01:55,080
You don't need to touch any other settings of the data validation.

31
00:01:55,080 --> 00:02:01,680
The only thing you need to be careful of is if you're using this feature, don't move around any of these

32
00:02:01,680 --> 00:02:06,840
tool tips because the moment you start messing with them or touching them or moving them around then

33
00:02:06,930 --> 00:02:12,640
all the tool tips shift to that point where you moved your first tooltip.

34
00:02:12,660 --> 00:02:17,760
So just make sure you don't move them and just leave them be where they were.