Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
minLevel1
maxLevel6
outlinefalse
stylenone
typelist
printablefalse

\uD83D\uDCD8 Instructions

Section 1.1: Fonts

MS Excel provides you with hundreds of fonts to choose from. Some of them are good to use, but you want to be careful since many are not accessible.

How to choose a font:

  1. Go to the Home Tab.

    Home Tab in MS Excel.
  2. In the Font Section, click the font dropdown menu.

    The font section in Excel with the font dropdown menu highlighted with a red box.
  3. Choose a font you would like to use.

When using fonts, you want to use fonts that are easily readable and not distracting or fancy. Fonts like Times New Roman, Verdana, and Georgia are examples of good fonts to use. It is not recommended to use fonts like Algerian, Jokerman, or Script MT Bold.

A list of harder to read fonts in MS Excel. Including Algerian, Freestyle Script, Jokerman, Old English Text, and Script MT Bold.
Warning

While these fonts look more interesting, users with disabilities may have a hard time reading them.

A list of easier to read fonts, including Arial, Calibri, Cambria, Times New Roman, and Verdana.
Tip

These fonts are much easier to read.

To keep things simple and easy to read, make sure the font is over 12 points in size. To change your font size,

  1. Go to the Home Tab.

    The Home Tab in MS Excel.
  2. In the Font Section, select the font size button and select the size font you want.

    The font section in Excel with the font size dropdown menu highlighted with a red box.A list of font examples with Times New Roman size 10, 12, 14, and 20.

Section 1.2: Text Attributes

Screen readers do not recognize capitalized letters unless certain settings are changed. You do not need to use all caps to emphasize text. Instead, include an additional cue so the reader will be able to know the difference between content.

A list of people who need to complete required training. The text is in all caps for people who have not finished.
Warning

This list shows unnecessary capitalization in letters. Screen readers will not emphasize the text even when it is in all caps.

A list of people who need to complete required training. The words complete or incomplete are next to each name.Image RemovedA list of people who need to complete required training. The words complete or incomplete are next to each name.Image Added
Tip

This example shows the words “Complete” or “Incomplete” next to the persons name. Now if someone reads this, they will have an easier time knowing if they finished the training or not.

Tip

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

A list of student who owe homework. The students listed in bold text owe homework.
Warning

This list shows unnecessary bold text. Screen readers will not emphasize the text and readers may not be able to tell the bold text from normal text.

A list of students who owe homework. The students that owe homework have their names listed in bold with the words work still owed next to them.
Tip

An additional cue has been provided. Now when a student reads this with a screen reader, they will hear “Name - work still owed.” Now the bold text is not the only cue.

Section 1.3: NVDA Settings for Text

When you use text that is bold, italic, strikethrough, or underlined, be sure to modify the settings in the screen readers. This will allow the screen reader to tell the reader of any bold, italic, strikethrough, or underlined text. To change the settings,

  1. In NVDA, go to the Preference Tab, then click Document Formatting.

    NVDA Settings with Document Formatting highlighted in a red box.
  2. Select the Font Attributes check box in the pop up box. Click Apply in the bottom right corner.

    The Font Attributes box is checked and highlighted in a red box. The Apply button in the bottom right corner is also highlighted in a red box.
  3. In JAWS, you can examine the font attributes at the cursor, including whether or not there is strikethrough, by pressing INSERT + F.

Section 1.4: 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.

Wrap Text button inside a red box.Excel file Cell A1 saying I used to be. Cell B1 says Funny.
Warning

This text is completely hidden. This would be hard for anyone to read.

Cell A1 has been expanded to say I used to be indecisive. Now I am not sure. Cell B1 still says funny.
Tip

Wrap Text has been applied and now all of the text is visible and easy to read

When you have overflowing text, all you have to do is extend the cell. To extend the cell, double click the line between the cell you are typing in and the one next to it. Excel will automatically expand the cell to make the content fit inside.

The text I used to play sports. Then I realized you can buy trophies. Now I am good at everything. goes from Cell A1 to H1.
Warning

The sentence is in Cell A1, but it does not fit inside.

The text I used to play sports. Then I realized you can buy trophies. Now I am good at everything. fits in cell A1..
Tip

Now the cell fits inside Cell A1.

Section 1.5: Symbols and Special Characters

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"