Topic | DO's | DON'Ts | Visual Example |
Hyperlinks | Insert hyperlinks by right clicking in a cell and selecting Hyperlinks. Place the full URL in the address box, which automattically populates the hyperlink in the text to display box. Always double check that your hyperlinks work. Add a screen tip to describe what the link leads to. located in the upper righthand of the highperlinks box. | Do not write anything in the text to display box. Having the hyperlink displayed in the spreadsheet allows those who print the spreadsheet to access the link. |  |
Merged Cells | Leave the workbook in black and white to provide good visual contrast. Increase row height or column width to assist sighted users. Under the Home tab in the cells section, click format where you can adjust the row height and column width. On each worksheet the information should start in A1 and extend right and down. | Do not merge or split cells. Do not have any empty rows or columns. |
|
Spell Check | Be sure to do a spell check on each worksheet. Excel doesn't put a wavy red line under a word it thinks is misspelled. In the Review tab, in the Proofing group, select Spelling, and follow the prompts. | Do not forget to spell check each worksheet. Excel will only spell check one worksheet at a time. |  |
Document Properties | Fill out the Document Properties. This provides background information on the workbook for those reviewing it later and assists search facilities on websites or other document repositories. Click the file tab, and choose the Info tab on the left. On the right side there is a frame listing the properties. You may edit the properties directly here, or use the drop-down menu by the word Properties. Select Advanced Properties, select the Summary tab, and fill out the form. | Do not include information that should be omitted for security or privacy reasons. |   |
Hide Unused Rows | Hide unused rows and columns. This makes the worksheet look less cluttered and prevents your users from wasting time searching. To hide columns, select the first blank column to the right of your data, holding down shift and CTRL keys, presst he right arrow key (Shift + CTRL + Right Arrow). Right-click in the selected area and choose Hide. To hide rows, leave one blank row below your data, then select the next row below that. Holding down Shift and CTRL, press the down arrow key (Shift + CTRL + Right Arrow). Right click in the selected area and choose Hide. | Do not keep empty rows and columns outside the print area. | no example. |
Alt Text and Captions | Insert Alternative Text (ALT text) and captions for informational images or charts. Right click on the image and choose Insert Caption. Right click on the image and choose Format Picture and then, click the third icon over and click on ALT TEXT. | Do not provide ALT text or captions for non-informational or simply decorative images. |   |
Multiple Images | If you have multiple images or objects that are layered over one another, group or combine them into one image. You may be able to do this using the Group option or using a third-party tool such as SnagIt. | Do not overlay or group several objects next to one another so they appear as one object. | no example |
Color to Convey Meaning | When using color to convey meaning, add a non-color method as well, such as text as shown in the visual example column. | Do not use color alone to convey meaning. | Unit | Ready for Release | 1 | No | 2 | Yes |
|
Color Contrast | Use a strong color contrast. This is not usually checked via Microsoft Word. It requires a visual check. The video in the right column under Videos on color and contrast has a brief but good explanation. | Some examples for Don'ts: Do not use white text on a gray background. Do not use red and green text and highlighting together. For more details, see the short video. | no example |
Fonts | Use fonts that are clear and legible (e.g., Arial or Times New Roman), generally in the 10 to 14 point range. The spacing in the document should be enough to show paragraph breaks clearly. Spacing between lines should be at least 120% of the font size. This is the default in Word. | Do not use fancy fonts that are more decorative than functional. This is especially important in headings. | no example |
Accessibility Checker | Always run the accessibility checker when you are finished with your document to see if any issues are identified, then remediate those items prior to publishing your document. You access the checker by clicking File, the Info menu option will display and then select Check for Issues drop down and select Check Assessibility. | Don't assume your document is good, always run the checker as a double check. | 
|