Attachment8_Section508_Excel QuickCard 2017.pdf
PDF 120 KB Posted
- Solicitation number
- 1168154
- Issued by
-
Department of Agriculture Forest Service
About this file
This document is a Microsoft Excel Accessibility Quick Card containing best practices for creating accessible Excel workbooks.
The quick card provides eleven key recommendations for ensuring Excel workbooks are accessible to all users, including those utilizing screen readers and keyboard navigation. Sheet tabs should have unique, descriptive names, and blank sheets should be removed. Titles must appear in the first row and column, with cell merging permitted for centering. Data tables should include accompanying charts or graphs positioned directly below the data. Row and column headings must be specified and properly marked using Table Tools. Color schemes should provide high contrast with texture variations for improved readability, tested through black and white printing. Unused rows and columns should be hidden to prevent navigation issues. Blank data cells should be avoided; if truly empty, cells should contain "This cell intentionally left blank" or "No data." Text, rather than logos alone, should identify the author and agency. Hyperlinks must use meaningful text reflecting the destination rather than generic phrases. Alignment tools should manage layout and white space instead of using blank rows or columns. The worksheet end should be marked with "end of worksheet" in the row following the last data row. Content should be structured by defining the title region, providing data range names, and hiding unused areas. Finally, advanced document properties should include title, subject, and author information. The card directs users to mn.gov/mnit/accessibility for additional Excel accessibility resources.
View the file
Other files
Show all 15
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
• Give all sheet tabs unique names
Sheet names should provide information about what is found on the worksheet, making it easier to navigate through a workbook. Remove blank sheets.
• Enter title in first row and column
You may merge cells to center the title.
• Include table data with any data visuals
When displaying charts or graphs within Excel, locate it directly below the data table.
• Specify row and column headings.
Check Table Tools to ensure proper row and column elements are marked.
• Use color carefully
High contrast color schemes and texture variations in graphs improve readability.
Test your designs by printing in black & white.
• Hide Unused Rows and Columns
This prevents screen reader users and keyboard navigators from wandering off into blank cells.
Follow these best practices to help ensure your workbooks are accessible. For more information on Excel® accessibility, visit mn.gov/mnit/accessibility
Accessibility Quick Card
Microsoft Excel® http://mn.gov/mnit/accessibility
• Use text to identify author and agency
Do not use the logo alone to identify the source.
• Name your hyperlinks appropriately
Your link should contain meaningful text that reflects the link destination or subject, rather than simply saying “click here.”
• Use alignment tools for layout and to create white space
Don’t use blank rows/columns for spacing.
Manage your layout by resizing rows and columns, and using the alignment tools to move content (top, bottom, left, right) as needed.
• Avoid blank data cells
Cells should not be left blank. If the cell really has no data, then you can add “This cell intentionally left blank” or “No data.”
• Mark end of worksheet
Type “end of worksheet” in the row immediately following the last row.
• Structure content for better readability
Add structure by defining the title region, providing data range names, and hiding unused rows and columns.
• Fill in document properties
In advanced document properties, enter title, subject, and author.
mn.gov/mnit/accessibility http://mn.gov/mnit/accessibility
File details come from the government source that posted it. Updated .