Excel: Creating Simple Tables

Overview

Simple tables improve accessibility by ensuring screen readers can correctly interpret data relationships.

Considerations

• Use one header row or one header column.

• Avoid merged or split cells.

• Use clear column headers.

• Verify header row designation in the Table tab.

• Banded rows or columns can help differentiate data.

• Shading and gridlines alone do not define tables.

• Check color contrast of table styles.

• Avoid empty rows or columns within tables.

Steps

1. Enter data into the worksheet.

2. Select the data range.

3. Go to Insert > Table.

4. Ensure My table has headers checkbox is checked.

5. To split the merged cell, click the merged cell and go to Home tab > Merge & Center dropdown menu > click Unmerge cell or Split cell.