1
00:00:01,040 --> 00:00:05,260
Let's quickly take a look at working with objects and cells in Excel.

2
00:00:05,310 --> 00:00:08,810
On this invoice template that we took a look at in the previous lecture.

3
00:00:09,080 --> 00:00:11,210
I have one object.

4
00:00:11,210 --> 00:00:14,350
It's the picture or this logo sitting up here.

5
00:00:14,510 --> 00:00:17,100
It's sitting on top of the cells.

6
00:00:17,120 --> 00:00:20,330
These here are sitting inside the cells.

7
00:00:20,390 --> 00:00:24,620
Anything that sits on top of a cell is considered an object.

8
00:00:24,620 --> 00:00:28,110
So for example a chart sits on top of the cells.

9
00:00:28,110 --> 00:00:30,530
It's seen as an object in Excel.

10
00:00:30,530 --> 00:00:36,980
You can insert object so you can import any type of picture or logo you want by going to the Insert

11
00:00:36,980 --> 00:00:39,540
tab and clicking on pictures.

12
00:00:39,620 --> 00:00:46,610
You just have to find the picture from your directory click on it and then click on insert. That automatically

13
00:00:46,610 --> 00:00:52,610
inserts that picture on top of the cells. So you can move it where you want, you can change its size by

14
00:00:52,610 --> 00:00:59,030
just dragging the sides, and you get an additional tab in Excel called Picture format.

15
00:00:59,030 --> 00:01:01,730
You might be familiar with some of these options.

16
00:01:01,940 --> 00:01:08,720
If you've used PowerPoint or Word. You have the ability to add picture styles to this. If you hover over

17
00:01:09,110 --> 00:01:15,660
these files you can see the end result. If you like one of them you can select them, you can add picture

18
00:01:15,680 --> 00:01:24,470
border, add an effect, you can crop the picture or manually set its height and width if you want it to be very exact.

19
00:01:24,530 --> 00:01:33,140
In addition to inserting pictures you can also insert shapes by selecting a shape

20
00:01:33,140 --> 00:01:34,130
from here.

21
00:01:34,130 --> 00:01:37,220
So let's say I want to add this star to it.

22
00:01:37,220 --> 00:01:43,160
I just need to draw it out anywhere I want then I can move it where I want. This time I don't get that

23
00:01:43,160 --> 00:01:51,080
picture format, I get shape format. Here I can decide on the shape fill, that's the color filling of the

24
00:01:51,140 --> 00:01:57,620
object here and I can decide on the shape outline. If I don't want an outline so that's the border

25
00:01:57,650 --> 00:02:06,050
around the shape. If I don't want it I can select no outline that takes away the border. If I wanted an

26
00:02:06,050 --> 00:02:11,840
outline I select the color and I can adjust the weight of that outline. So I could make it as thick

27
00:02:11,840 --> 00:02:19,970
as I want or I can add a dash line as the outline instead of a straight thick line. I have the ability

28
00:02:19,970 --> 00:02:27,830
to rotate the image and again I can add some shape effects to this if I want. I can also add text to

29
00:02:27,830 --> 00:02:32,820
this. Right mouse click here, edit text, type text on there.

30
00:02:32,930 --> 00:02:38,240
Now that really depends on the shape and how much space you have inside the shape.

31
00:02:38,390 --> 00:02:46,280
You can also add text boxes if you want your text to sit on top of the cell. If you don't want it

32
00:02:46,280 --> 00:02:54,590
to be constrained to the cell size you can add a text box. And that's also in the Insert tab. You see

33
00:02:54,590 --> 00:03:01,820
it directly sitting here. Text box, you can also find it under shapes. The first option here is the

34
00:03:01,820 --> 00:03:05,380
text box so you just have to click on it and draw it out.

35
00:03:05,540 --> 00:03:11,120
This gives you a chance to put a header as big as you want on top of your report.

36
00:03:11,900 --> 00:03:17,180
So again this is an object that's sitting on top of the cells.

37
00:03:17,250 --> 00:03:23,390
Now the only thing that you need to keep in mind when you work with objects is that because they are

38
00:03:23,390 --> 00:03:27,200
sitting on top of the cells they can get stretched out.

39
00:03:27,350 --> 00:03:31,880
If your cells get wider. But you can stop that if you want.

40
00:03:31,880 --> 00:03:39,350
So there is a specific setting in the properties of these objects, right mouse click, and go to format shape.

41
00:03:39,410 --> 00:03:48,800
Under the size and properties expand the properties option and select Don't move or size with

42
00:03:48,800 --> 00:03:53,220
cells or move but don't size with cells.

43
00:03:53,300 --> 00:03:56,870
So this makes sure that your objects don't get stretched.

44
00:03:56,870 --> 00:03:58,090
In this case I'm going to select

45
00:03:58,090 --> 00:04:00,630
Don't move or size with cells.

46
00:04:00,740 --> 00:04:08,540
If I stretch this out this is not going to get stretched and even if I insert a new column here this

47
00:04:08,570 --> 00:04:10,700
object is not going to shift.

48
00:04:10,820 --> 00:04:16,820
The other option was move but don't size with cells which means that if I insert new columns here this

49
00:04:16,820 --> 00:04:17,829
is going to move.

50
00:04:17,870 --> 00:04:21,060
It's just that its size is not going to shift.

51
00:04:21,140 --> 00:04:27,470
One other thing to point out when you work with shapes is that you can hide shapes from view.

52
00:04:27,470 --> 00:04:35,600
So if I go to Find and Select and bring up these selection pane. I'm just going to drag it here, close

53
00:04:35,600 --> 00:04:42,860
the other one. On the selection pane you can see all the objects that I have on this sheet.

54
00:04:42,860 --> 00:04:48,440
So here is the text box seven that's this one, here is the star 5 points 6.

55
00:04:48,440 --> 00:04:51,880
You can just click on it and change the name if you want.

56
00:04:51,890 --> 00:04:52,700
Picture five.

57
00:04:52,760 --> 00:04:54,280
And picture one.

58
00:04:54,320 --> 00:04:59,680
Now let's say I wanted to print this but I don't want to see the logo when I print it.

59
00:04:59,900 --> 00:05:05,450
I can click on this eye icon and this hides that picture from view.

60
00:05:05,450 --> 00:05:10,770
So if I even click on this cell, I don't even realize that there is a picture there.

61
00:05:10,790 --> 00:05:17,300
The only way to bring it back is to go back to the selection pane and click on the icon right here to

62
00:05:17,300 --> 00:05:19,380
make it visible again.

63
00:05:19,400 --> 00:05:20,780
Okay so that's it for now.

64
00:05:20,780 --> 00:05:27,560
For objects versus cells, just keep these points in mind when you insert different types of Excel objects

65
00:05:27,800 --> 00:05:28,850
in your worksheets.