Constructing a Table

A well-structured table typically has three main parts: row headers, column headers, and the table body. Row headers identify what each row represents, while column headers define what each column represents. The table body contains the data itself, usually numeric values such as costs or quantities. For screen reader users, understanding this structure is essential because navigation depends heavily on how clearly these elements are defined.

To improve accessibility, Excel provides a powerful feature called “Define Names,” which allows screen readers to announce row and column headers automatically as you move through the table. Without this feature, navigating a table can be slow and confusing, as you would need to manually move across rows and columns to understand the context of each value. By defining names correctly, the screen reader will read both the header and the cell content together, making navigation much more efficient. To enable this, you must start from the cell where the row and column headers intersect, usually the top-left cell of the table (excluding the title). Once activated, moving horizontally will announce column headers, and moving vertically will announce row headers. Depending on your needs, you can also configure Excel to read only column headers or only row headers.
It is important to manage defined names carefully. If they are applied incorrectly, navigation can become confusing. You may need to delete and redefine them, especially after editing the table or if rows and columns have been added or removed. Additionally, when working with multiple tables on the same worksheet, each table should have its own defined range to prevent overlapping or incorrect header readings. Each defined name must also be unique within the file.
After setting up the structure and accessibility features, the next step is entering data into the table. Data is typically entered row by row or column by column, and you can move between cells using the Enter key or arrow keys. Once data is entered, you can perform calculations such as summing rows or columns. For example, to calculate totals, you use formulas that begin with an equal sign and include cell ranges. Although typing formulas may seem difficult at first, Excel allows you to reuse them efficiently.
This brings us to the concept of relative and absolute cell references. By default, Excel uses relative references, which automatically adjust when a formula is copied to another cell. This is very useful when applying the same calculation across multiple rows or columns. Absolute references, on the other hand, remain fixed regardless of where the formula is copied. These are created by adding a dollar sign before the column letter, the row number, or both. Absolute references are especially important when one part of a formula must remain constant, such as when calculating percentages based on a fixed total.
Copying formulas in Excel follows a slightly different order than copying text. First, you copy the formula, then select the destination cells, and finally paste it. This allows Excel to automatically adjust the references based on their new positions. Using this method, you can quickly apply calculations across large sections of your table without retyping formulas.
Formatting is another important step in making your table readable and meaningful. Numbers can be formatted as currency, percentages, dates, or other types depending on the data. For example, financial data is often formatted as currency with two decimal places. Instead of formatting each cell individually, you can select a range of cells and apply formatting to all of them at once using keyboard shortcuts. This saves time and ensures consistency across the table.
Finally, for presentation purposes, you may choose to merge and center cells, particularly for the table title. Merging combines multiple cells into one, and centering aligns the text in the middle, making it visually clearer for sighted users. However, this step is mainly for visual formatting and does not significantly affect screen reader navigation.
In summary, creating an accessible and functional Excel table involves carefully structuring the table with clear headers, using the Define Names feature to enhance navigation, entering and calculating data efficiently with formulas, applying appropriate formatting, and optionally adjusting visual layout elements. When done correctly, these steps make Excel tables much easier to use, especially for screen reader users, by reducing confusion and improving the flow of information.