Welcome to Office 2013, Video Project Number 13.
We want to talk about Word Tables and Paste Special Link.
We're going to take an Excel table and bring it into Word
but link it so any time we update it, it updates in Word.
Word tables-- we can go up to Insert and there it is.
Click on that little drop-down.
And we can choose whatever size, whatever number of columns--
I'll have five-- and rows-- we'll have four.
As soon as I click, instantly a table is inserted into Word.
Now, what are tables in Word good for?
For holding stuff in unusual patterns.
So you might have a picture here.
And then, some labels at the top and things in column.
In order to have that organization of things in Word,
it would be hard to do without a table.
Now, let's first look at the mechanics of a table.
If you want to move forward, you've got to the use Tab.
If you want to go backward, Shift Tab.
If you want to go down, you can use the arrow key.
So arrow, arrow or up-arrow, up-arrow.
Now, notice Tab.
That goes to the right.
Shift Tab goes back.
What if you wanted to tab for a real tab?
You'd have to use Ctrl-Tab.
And that would add-- oh, there's our non-printing character.
Hey, speaking of non-printing characters,
what are these things?
Let's turn our non-printing characters off,
either right there in the Home ribbon
Paragraph group or Ctrl-Shift-8.
Yes, those little starry round things-- Ctrl-Shift-8--
that's the non-printing character for a cell.
Now, that's important because, in a lot of templates,
you will see that the table holds things.
But there are no borders.
So knowing that, when you turn on your non-printing
characters, you're like, oh, yeah, there's a table here.
There's also this move cursor up in the top corner
that'll indicate that it's a table.
I'm going to Ctrl-Z. I'm going to click
in the first cell and Backspace.
Now, there's some different kinds of cursor.
This cursor, right here, means, hey, select the whole row.
We've used the selection bar cursor
before to highlight a whole sentence.
This cursor, right here-- this little
black downward pointing one-- that's
highlight the whole column.
That one, right there-- diagonally
pointing black solid arrow-- that means, hey, highlight
the whole cell.
There's also change the column width.
Ctrl-Z-- that one there's like a double parallel vertical line
and two arrows.
Down in the corner, this is the resize.
So I can resize it.
Ctrl-Z. And then, that's the move cursor.
Now, let's try a few things.
I'm going to merge.
So I would like to merge all of these cell.
So I'm going to use my I-beam cursor and click and drag.
Right click, Merge.
Now, you can also Split, which is like almost impossible
to do in Excel.
If I come over to this cell and say, right click, Split.
It will ask me how many columns.
I'm going to say three.
So you can create some unusual patterns
for holding things in a Word table.
I'm going to Ctrl-Z. I'm not going to split that.
Now, it could hold whatever you want-- pictures, text.
I'm going to go ahead and go up to Insert, Pictures.
And I'm just going to select a silly picture-- the penguins.
That's one of the default pictures.
And then, I'm going to make it pretty small.
I'm going to point to the edge and drag diagonally.
Drag a little bit more.
Now, I'd like to come over here and do a few things.
Now, inserting is even easier in 2013.
These little pluses-- if I click it--
it'll insert a whole new column.
I'm going to go right click and point to Insert.
And they give you all sorts of options.
We can Insert Column Left, Right-- and I'm
going to do Rows Above or Below, in this case, and then [BLOOP].
Maybe one more.
I'm going to hit the F4 key.
The F4 key is repeat.
Repeat, the F4 key.
So I inserted a couple rows.
Now, let's type Monday, Tuesday-- I'm
hitting Tab-- Wednesday, Thursday.
And I want to have one more so I'm going to do [BLOOP]--
it looks like I've got Friday and Thursday mixed up.
So it doesn't like that R there.
I'm going to highlight this whole set of headers here
and Ctrl-B.
So the idea here is we're constructing something
that would be holding our labels up here.
And we're going to put some stuff
in these columns and a picture.
So it'd be really hard to do this without a table.
Down arrow.
Let's come over here.
Arrow.
Now, we could do some formatting, too.
If we go up to Design in the Table Tools,
click our little drop-down arrow.
And you could select some.
This is Grid Table 4 Accent 5.
And the cool thing about this is,
if we were to right click, Insert,
it's got the dark, light, dark, light.
So I right click, Insert.
It retains.
And I'm going to say, Insert Rows Above.
It retains that same pattern.
Now, we could turn all of our lines off.
I'm actually going to Ctrl-Z and undo that formatting.
Ctrl-Z-- because I want to keep it there.
And I just want to make those lines go away
and see there's a few places we could go.
No borders.
And there-- so all of a sudden, if I Ctrl-Shift-8
to turn my non-printing characters on,
that's a pretty cool construction
we did in Word, using a table.
Now, I'm going to Ctrl-Z. Now, I'm
going to turn my non-printing characters back on.
And we want to look at creating something similar in Excel
and then copying and pasting it over here with a link.
Now, I'm going to go down to my taskbar and open up a brand
new blank workbook.
And I'm immediately going to F12 to save as.
I'm going to call it the same thing--
Word Tables in Excel Paste Special Link.
And I'm going to direct it right to the same folder
because these two files are going
to be communicating with each other.
We're going to have a link between them.
So I'm going to save them to the same place, Class Notes
and for Word.
So in Word.
There's my Excel workbook name.
Click Save.
So I'm going Alt Tab.
So I have a Word document, Alt Tab, an Excel workbook file.
Now, over in A1, I'm going to hold Ctrl and Roll.
Then, I'm going to type the word Monday, M-O-N.
And I'm going to use-- instead of Enter or Tab-- I'm
going to use Ctrl-Enter.
Ctrl-Enter puts something into the cell
and keeps the cell selected.
Now, I'm going to Ctrl-B. Oh, hey, that's the same keyboard
as over in Word.
And now, this cursor in Excel is called the Selection cursor.
You can actually click in a cell and drag to select.
You can select a cell with some content.
And in the lower right corner of that little box is called
the fill handle.
Now, if you move your selection cursor close,
right when it gets over the fill handle,
it turns to a cross hair.
Or I like to call it an angry rabbit.
And that angry rabbit does some special things.
If you click and drag, it will increment days.
If you were to type January, Ctrl-Enter, and then point
to your fill handle.
When your selection cursor turns to an angry rabbit,
click and drag.
That's fun with Excel.
We'll start our study of Excel in about a week.
I'm going to Ctrl-ZZ.
Now, I'd like to highlight this.
So I'm going to click in cell A1 with my selection cursor.
And I'm holding the click and dragging.
And I'm going to go down to row 6.
I'm going to go up to the Home ribbon.
And I'm going to go to this Border button
with the drop-down.
Select All Borders.
I'm going to type Thing 1, Ctrl-Enter.
I'm going to get my angry rabbit and click and drag.
Oh, look at that.
And now I'm going to click and drag to the side
just so I can fill up the table.
Oh, that's a lot of things.
I'm even going to highlight the very first row, Home,
and do some sort of fill.
I'm going to do a the light color fill.
Now, we'll study Excel later.
But what we want to see is that we can create something
in Excel, highlight it.
And we're going to copy it.
And we'll see, when we copy something, [BOOM], the dancing
ants start dancing.
Now, this is Excel 2013.
The dancing ants actually are moving really slow.
In earlier versions, they danced a lot faster.
But the dancing ants-- that means it's been copied.
Now, I'm going to Alt Tab.
And I'm going to make sure that my cursor is
two hard returns below.
In fact, I'm just going to hit another hard return.
So I have a few hard returns.
And then two hard returns below the Word table-- if I Ctrl-V,
it actually pastes the content and formatting from over there,
but as a Word table.
You can see, if I hover my cursor,
it's got all those cursors.
I want to Ctrl-Z because I don't want that.
I want it to look just like Excel-- over in Excel.
And I want it to be linked.
So if I change anything in Excel, it'll update here.
The way you do that-- Paste, Drop-Down, Paste Special.
Be sure to click the Paste Link.
That's what connects it.
That's what allows it to update automatically.
Then I'm going to select Microsoft Excel
worksheet object.
Click OK.
And now, that it is linked, Alt Tab.
This is a Thing 4 and 5.
Alt Tab.
Instantly it updates.
Now, I want to save both of these.
Ctrl-S. And I'm going to close this.
I'm going to change something over here.
And I'll highlight both of these and point to my fill
handle with my angry rabbit and click and drag.
That's Thing 3, Thing 3-- hey, look, that didn't work.
Ctrl-Z. I'll do one at a time.
Then it will increment.
[BLOOP]
Ctrl-S to save it.
And I'm going to close this.
Over in Windows Explorer, we want to take a look.
I'm going to open up and drill all the way down to our Class
Notes for Word.
So there's the Excel Word Tables Excel Paste Special.
And here's the Word.
I'm going to click on the Word table.
And then, open it-- double click or hit Enter.
Now, we will get this message.
This is very important.
It says, hey, there's some links.
Do you want me to update them?
I'm going to click Yes.
And there, we can see we have our updating.
Now, I'm going to close this Word document.
Save it.
Now, I'm going to open up the Word table.
I've added something while the Word document was closed.
Ctrl-S, I'm going to close the Excel file.
Now, when I open up the Word, it will ask me--
it'll be polite again.
It'll ask me, hey, do you want to update?
Yeah.
And sure enough, it will update.
Now, if you ever want to check where your links are in Word,
you go to File.
Then on Info, down at the bottom over here, Edit Links to Files.
And I'm going to click on that.
And then, you can Update Now, if you
had selected No, Don't Update on that first message.
You can open the source-- actually,
it'll open this Excel file-- change the source, or break.
Sometimes, once you're done and it's no longer going to update,
you don't want to see that message anymore.
So you can come here and break.
I'm going to click Close on that and Esc
to get out of this backstage view.
One last thing about links-- Alt Tab over to Windows Explorer--
these two files-- if you move this somewhere else
and it can't communicate, that's when the link will be broken.
And then, you may need to re-establish.
So if we Alt Tab, you could go to Info, Edit Links, and then
Change Source.
You would actually open this and dig down to wherever it is,
using this Change Source dialogue box.
And then reconnect it-- double-click on the file,
once you find it-- and then it reconnect it.
Esc, Esc, Esc.
We learned a little bit about Word tables.
And we learned about Paste Special Link.
We'll see you next video.