C04m Attachment 10 Section 508 Excel QuickCard 2017 1284LM26Q0117.pdf
PDF 126 KB Posted
- Attached to
- USDA Forest Service Land Management Integrated Resources (LMIR) BPAs Land Mgmt Plan for Greater Sage Grouse
- Solicitation number
- 1284LM26Q0117
- Issued by
-
Department of Agriculture Forest Service
About this file
This document is a Microsoft Excel Accessibility Quick Card providing best practices for creating accessible workbooks. The guidance is issued by the Minnesota IT Services Office of Accessibility and applies to Excel spreadsheet development.
The quick card outlines ten key accessibility requirements for Excel workbooks. Sheet tabs must have unique, descriptive names with blank sheets removed. Titles should be entered in the first row and column, with optional cell merging for centering. Data tables must be accompanied by any associated charts or graphs positioned directly below the data. Row and column headings must be properly specified using Table Tools. Color schemes should employ high contrast and texture variations, tested in black and white printing. Unused rows and columns should be hidden to prevent navigation issues for screen readers and keyboard users. Author and agency identification must use text rather than logos alone. Hyperlinks require meaningful naming that reflects destination or subject matter rather than generic phrases. Layout and white space should be managed through alignment tools and row/column resizing rather than blank rows or columns. All data cells must contain values or explicit notations such as "This cell intentionally left blank" or "No data." The worksheet must conclude with an "end of worksheet" marker in the row following the last data row. Content should be structured by defining title regions, providing data range names, and hiding unused rows and columns. Finally, document properties must be completed with title, subject, and author information. Additional guidance is available at mn.gov/mnit/accessibility.
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 .