Attachment8_Section508_Excel QuickCard 2017.pdf

PDF 120 KB Posted

Attached to
Harris South Project Environmental Impact Statement
Solicitation number
1168154
Issued by

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 .