Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Wrap text within cells so that all text is clearly spaced out and visible.

To unmarkup a table, right click anywhere in it and select Convert to range.

How you know whether a table in a spreadsheet is marked up

...

In this example the merged top row which simply says 2020/21 is either already implicit in the table title, or could be cut and pasted out into a row directly above the table explaining that these are results for 2020 to 2021.

Image Modified

So that it now has only two heading rows - still undesirable, as are the merged cells sitting above the individual columns.

...

Divide long tables with multiple sub-sections into lots of smaller tables

Before

. A long table with sub headings on the left using merged cells, doubly inaccessible.

After

. One fewer columns. Clearer layout. Easier for sighted people to get to the category they want, and much easier for a screen reader to navigate.

...

And also, finally, remove the colour.

Possible Possibly the percentage symbol could be removed and explained in a description sentence above the table , to further reduce clutter. Maybe the sets of year columns could be divided by a thicker cell border for sighted readers.

...

In whatever format notes are indicated, an explanation should be given in the description text in the second or third row, for example: ‘This worksheet contains one table. Some cells refer to notes which can be found on the notes worksheet/at the end of the relevant row’.

Explaining symbols

Hannah Government Statistical Service has suggested a set of universal symbols to be adopted across all government.

...

2. Asterisk should always be avoided. Asterisk notes referring to columns should be either a) included in the column header or, if too long b) explained in a sentence above, eg: ‘In column 3 xxx’the data is based on the 2018 survey.’

Graphs in spreadsheets

Ideally, spreadsheets should not contain graphs or charts but be limited to tables of data.

...