Versions Compared

Key

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

How do I create accessible texts and fonts in Microsoft Excel?

Table of Contents

\uD83D\uDCD8 Instructions

Guide to Accessible Fonts in MS Excel

As cool as some fonts look, its best to just use the ones that are easiest to read.

...

Info

Font sizes should never be smaller than size 12.

Guide to Accessible Capitalization

Screen readers do not recognize capitalized letters, so there is no point to relying on capital letters to emphasize text.

...

Tip

Use capitalizations to show the IMPORTANT text. Be sure to use capitalizations sparingly.

Guide to Accessible Bold, Italic, and Underlined Text

Screen readers do not recognize bold, italic, or underlined text. They will just read it as if it were normal text. In order to emphasize meaning in the text, you need to create a second way for people to see the text. A good rule of thumb is to use bold text, italics, and underlined text sparingly.

...

Warning

This an example that is difficult to read, has way too many things bolded and italicized. The underlining also distracts readers and can make it harder to understand.

Tip

This example uses bold, italics, and underlining text sparingly. Only change the important words. This will make the content easier to read.

Guide to using Strikethrough

When a screen reader reads text with strikethrough like normal text. So when you use strikethrough, be sure to give a second indicator. This will give the screen reader another queue to give the reader.

...

Tip

This table shows both queues. The screen reader will tell the reader the completed tasks as labeled

Guide to Highlighting

When highlighting, it is important to be sure it is not the only way to convey meaning. Screen readers will not recognize the highlighted text as highlighted text. So it will only read it as normal text. This will be confusing to someone with visual problems.

...

Tip

This example gives a second queue for the screen reader to read. This will help a reader understand the meaning and context behind a highlighted text.

Guide to Text Visibility, and Overflowing Text

All text must be visible in a spreadsheet. Sometimes when we type in a spreadsheet, the words may become invisible when we go to the next cell. To fix that, click the Wrap Text button to reformat the text to fit in the cell.

...

Tip

Now the cell fits inside Cell A1.

How do you use Symbols and Special Characters for Accessibility?

You can use many different symbols and special characters. However, they must always be communicated in regular text as well. This must be done so the screen readers will read the symbol properly to the reader. Here is a list of 15 symbols and special characters that are good to use, as well as the text you should use for the screen reader to read off.

  1. The AT Symbol

  2. The Ampersand

  3. The Slash

  4. The Copyright Symbol

  5. The Trademark Symbol

  6. US Dollar

  7. Euro

  8. British Pound

  9. Japanese Yen

  10. Paragraph Symbol

  11. Bullet

  12. Degrees

  13. One Half

  14. One Fourth

  15. Three Fourths

Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@82d
sortmodified
showSpacefalse
reversetrue
typepage
labelskb-how-to-article
cqllabel = "kb-how-to-article" and type = "page" and space = "AN"