WEBVTT

1
00:00:06.600 --> 00:00:10.200
In this video,
we will show you how to create a table

2
00:00:10.400 --> 00:00:13.933
with accessible headers.

3
00:00:14.400 --> 00:00:19.400
I'm looking at my summary sheet
and on my summary sheet I've got a table

4
00:00:19.466 --> 00:00:22.866
which I haven't yet
converted into a proper table.

5
00:00:23.600 --> 00:00:27.200
So I'm going to highlight
the cells that I want to be the table.

6
00:00:28.066 --> 00:00:30.866
I'm going to the insert menu

7
00:00:30.866 --> 00:00:33.000
and then click on table.

8
00:00:34.800 --> 00:00:37.200
I want to make sure that the box

9
00:00:37.333 --> 00:00:39.666
for my table has headers is checked

10
00:00:40.666 --> 00:00:42.400
and then click okay.

11
00:00:43.600 --> 00:00:47.333
You can then, if you want to, select
different styles for your table,

12
00:00:47.733 --> 00:00:51.066
but I'm happy with the one given.

13
00:00:51.933 --> 00:00:54.066
I'm then going to click somewhere
in my table

14
00:00:54.266 --> 00:00:56.333
and go to table design.

15
00:00:58.466 --> 00:00:59.800
Table name,

16
00:00:59.800 --> 00:01:01.866
the default is table two.

17
00:01:02.466 --> 00:01:04.066
I'm going to rename that.

18
00:01:05.800 --> 00:01:07.333
The table names in Excel

19
00:01:07.333 --> 00:01:11.133
can't have a space in them,
so I'm going to aim for a one word title.

20
00:01:11.266 --> 00:01:16.133
If I want a multi word title, I would have
to use either a dash or an underscore,

21
00:01:16.800 --> 00:01:19.933
but I'm going to stick with summary
and hit enter.

22
00:01:21.666 --> 00:01:23.733
So now it's enabled me

23
00:01:23.733 --> 00:01:27.333
to filter and search by the header.

24
00:01:27.333 --> 00:01:31.733
Visually, it's turned
these headers into header cells, but

25
00:01:31.733 --> 00:01:35.133
also for a screen reader
it will read them and associate

26
00:01:35.133 --> 00:01:36.266
the data with them.

27
00:01:38.333 --> 00:01:41.866
So that's how you turn a table
into an accessible

28
00:01:41.866 --> 00:01:43.533
table with headers.