MS Excel StandardsRequirements for Microsoft (MS) Excel workbooks that are developed, procured, maintained, or used under the purview of the California Department of Education (CDE).
The CDE prefers to have its websites (i.e., cde.ca.gov base domain) comprised primarily of web pages. MS Excel workbooks posted to CDE websites must have an approved use.
- Content that is at least 100 rows in length.
- Content that is required by law or by CDE policy to be in a specific format, layout, or to specifically be in MS Excel.
- Content that is already in MS Excel from an external (non-CDE) source, the source content cannot be linked to, and it would be inappropriate to convert the content into one or more CDE web pages.
- Content that is difficult to format as a web page, and the format in MS Excel is essential to the effectiveness of the presentation of the content.
- When related to a CDE funding profile and posted in the appropriate "R" folder on the primary CDE website.
- Workbooks used for meetings of the California State Board of Education (SBE) or its sub-committees, including agenda item attachments.
- Content that is data-only and intended to be imported into another application. Data-only content must be provided as a Comma Separated Value (CSV) file or as a Tab Separated Value (TSV) and not in .xlsx file format.
- Has a single row of headings in the first row.
- When used as a replacement for web pages. For example, the workbook functions as a landing page rather than as a stand-alone workbook.
File Properties & Required Elements
- Is saved as a .xlsx format file.
- Opens in a consistent and predictable manner.
- In Normal view.
- Zoom is set to 100 percent.
- The first worksheet (first tab) is displayed.
- Cell A1 has text and is selected as the active cell in all worksheets.
- All worksheets have content; blank worksheets are deleted.
- Has a metadata Title and Description (Subject) in the file Properties. See the Metadata Title & Description section for more information.
- Has the appropriate default language set.
- Text is contained in cells. No text boxes are used.
- A workbook title (i.e., Heading 1) is present at the top of the workbook (top of first worksheet). When possible, the workbook title should be the first item on the first worksheet. See the Headings section for more information.
- Content that provides attribution of ownership/authorship is present near the top or at the bottom of the first worksheet. For example, "California Department of Education," "State Board of Education," or "U.S. Department of Education."
- A date of authorship or of posting is present near the top or at the bottom of the first worksheet.
- All worksheet tabs have unique and meaningful titles that relate to the worksheet content.
- Each worksheet contains only one table, graph, or chart.
- "End of Worksheet" is present in the first cell of column A after the last row of data on each worksheet.
- Hide unused columns to the right of the last column used and rows below the last row used.
- If a workbook or worksheet is unusually complex, include instructions at the beginning of the workbook.
Features & Styles
- Uses the built-in MS Excel features and styles where available, including:
- Blank rows, columns, cells, and spaces are not used for structure or formatting. Row height and column width may be adjusted to create visual space.
- Comments are removed unless they are intended for viewing.
- Is free of spelling and grammar errors. Use the built-in MS Excel Spelling tool to check spelling.
- Is free of MS Excel accessibility checker errors. Use the bult-in MS Excel Check Accessibility tool.
- Warnings indicated by the MS Excel accessibility checker must be fixed unless they are verified not to be accessibility violations.
- Active hyperlinks are not broken. See the Hyperlinks section for more information.
- Is navigable in a logical and intuitive order, and all workbook functionality is available when used with keyboard only.
- All locked and unlocked cells must be capable of being selected and navigated with the keyboard.
- Keyboard focus is never locked or trapped at one particular document element. The user can navigate to and from all navigable elements using only a keyboard.
- Vital content contained in a page header, page footer, or watermark is duplicated in the body of the workbook.
- Is free of content that relies solely upon shape, size, visual location, color, or sound to convey meaning.
- All other CDE content adheres to the CDE Style Manual.
- Exception: Abbreviations do not need to be spelled out upon first use in the metadata Title. See the Metadata Title & Description section for more information.
- Exception: Abbreviations do not need to be spelled out upon first use in a heading if doing so makes the heading excessively long. Abbreviations not spelled out in headings need to be spelled out at the next available opportunity.
- The Inspect Document tool is used to remove the following:
- Exception: Do not remove Comments if Comments are intended for viewing.
- Document Properties and Personal Information
- Hidden Names
- Hidden Rows and Columns
- Invisible Content
Note: Using the Inspect Document tool removes both the metadata title and description. See the Metadata Title & Description section for more information.
- Works with common screen readers (e.g., Narrator, Immersive Reader, JAWS, NVDA).
- Works well on all devices, including phones and tablets.
MS Excel workbooks posted to CDE websites (i.e., cde.ca.gov base domain) have filenames that are created in a consistent manner by adhering to the following:
- Is less than or equal to 24 characters.
- To the extent possible, relates to the workbook title.
- Does not use spaces or symbols other than hyphen ( - ).
- Starts with an alphabetic character.
- Is all lowercase.
Note: Metadata standards for workbooks related to CDE Funding Profiles and for workbooks posted to State Special Schools and Diagnostic Centers websites differ from those for other CDE workbooks, and are available to CDE staff on the CDE Intranet website.
Note: The metadata Title is the Title in the workbook File Properties.
- Is unique on its website.
- Is concise, identifies the workbook, and is similar to the H1 title of the workbook.
- Uses title case.
- Only uses abbreviations if they are defined within the metadata Title or if there is not enough space to spell out whole words.
- If not defined in the metadata Title, abbreviations must be defined in the metadata Description.
Additional Requirements for Workbooks Posted to the Main CDE or the CDE Intranet Websites
Note: The Main CDE website is https://www.cde.ca.gov. The CDE Intranet website is http://intranet.cde.ca.gov.
- Has a metadata title that is comprised of the following three parts:
- Document Title: The Document Title meets the following:
- Is less than or equal to 50 characters, inclusive of spaces and punctuation.
- Is followed by one space, a hyphen, and one space.
- Sub-sub-topic: The name of the directory where the workbook is housed follows the Document Title, and is followed by one space. Most workbooks are housed at the Sub-sub-topic level. If the workbook is housed at the Sub-topic level, use the Sub-topic name instead.
- Website: The name of the website is enclosed in parentheses.
- Use (CA Dept of Education) for the Main CDE website.
- Use (CDE Intranet) for the CDE Intranet website.
- Document Title: The Document Title meets the following:
Example Metadata Title for a Workbook Posted to a CDE Website: Friendships and Mental Health Data - Mental Health (CA Dept of Education)
Note: The metadata Description is the Subject in the workbook File Properties.
- Uses up to 250 characters (inclusive of spaces and punctuation) to describe the presentation, its audience, and purpose or usage. Can be a sentence, multiple sentences, or sentence fragments.
- Is not a mere restatement of the title.
- Defines any abbreviations not spelled out in the metadata Title and any abbreviation used in the metadata Description.
- Ends with a period.
This section contains general standards for all MS Excel workbooks and additional standards for those developed by or on behalf of CDE for consistency.
- Uses text, not images of text. See the Visual Elements section for more information.
- Uses fonts that are easy to read and that are available on most devices.
- Text must be readable and functional when resized up to 200%.
- All characters are Unicode values.
- Uses Office Equation Editor (Office Math Markup Language [OMML]) or MathML for mathematical equations.
- Whenever possible, semantic text is used instead of special characters, symbols.
- "Yes/No" is used instead of "Y/N."
- "X" (or any other symbol) is not used to mean applicable.
- "0," "none" or "N/A," is used instead of a blank space to convey "zero," "nothing," or "not applicable."
- When special characters or symbols are used (including letters as symbols), the symbols are defined on or before their first use.
- Exception: Asterisks do not need to be defined when used for standard notes.
- Does not use device-specific words (e.g., click, hover) when there is an available alternative (e.g., select, navigate).
- When formatting such as strikethrough is added to text, the meaning of the formatting is explained in a bracketed note immediately after the formatted text.
- Extensive use of strikethrough or similar formatting requires indications of where the formatting begins and ends (e.g., diff-marking).
- Note: As an alternative to strikethrough and diff-marking, consider using a comparison table that shows the original text compared with the modified text. This works well for long sections of modified language, such as changes in law.
Additional Requirements when Developed by or on Behalf of CDE
- Uses 12-point font or larger.
- Uses Arial font.
- Exception: Content that is in a language other than English may use other fonts when necessary, as long as the font is comparable in readability to Arial 12-point font or larger.
- Underlines are not used except with active hyperlinks.
- Exception: Underlines may be used to indicate the text of laws or regulations that are being added, modified, or deleted as prescribed by the California Office of Administrative Law.
- All caps are not used unless for acronyms and initialisms.
- Large sections of bold or italicized text are not used.
- Justified text alignment is not used.
- Increase visual spacing around text by increasing column width and row height.
- Uses the built-in MS Excel styles Heading 1 through Heading 4 to identify the workbook title and section divisions in the workbook.
- Visual alterations of text are not used in place of heading styles to indicate the workbook title and section divisions. Text that is not the workbook title or section division does not use heading styles.
- Heading styles are not combined with other formatting, such as hyperlinks or table headers.
- Exception: Italics are permitted when otherwise required, but not for additional emphasis.
- The built-in MS Excel Title style is not used.
- Custom heading style names, including those that are mapped to the built-in heading styles, are not permitted.
- Heading levels are used in a hierarchical order (most important to least important) throughout the workbook as a whole, or worksheet by worksheet, depending on the organization of the workbook.
- Standard: Heading 1 is used for the overarching workbook title in cell A1 on Sheet 1. Subsequent worksheets have a Heading 2 in cell A1.
- Variant: Each worksheet title within a workbook is independent from one another and has a Heading 1 in cell A1.
- When the workbook is a sub-section of a larger set of files, the main title of the complete set of files must be included as part of the Heading 1 on worksheet 1. For example, "Attachment 1" is not a sufficient workbook title on its own, since it clearly implies that the workbook is part of something larger.
- Each heading level maintains consistent formatting throughout the workbook (e.g., all heading 2s are formatted the same throughout the workbook).
- Visual hierarchy of headings corresponds with the actual hierarchy of the headings. For example, using formatting such as text size and weight, a Heading 1 will be visually more impressive than a Heading 2, and so on.
- Headings use Title Case.
- Headings are not followed by a colon or period.
At the CDE, MS Excel workbooks can use either hyperlinked descriptive text, hyperlinked Uniform Resource Locators (URLs), or both. Generally, descriptive links are best, however linked URLs may be more useful in workbooks that will be printed.
- Hyperlinks are not broken. A hyperlink is considered broken if it does not resolve to the indicated content or returns an HTTP 404 error.
- Hyperlinks are used and styled (including color) consistently throughout the workbook.
- Hyperlinks with the same linked text or the same URL resolve to the same destination.
- Exception: Tables may contain multiple hyperlinks with the same hyperlink text but different underlying destinations, as long as they are defined by table row.
- Example: 'Add,' 'Edit,' 'Delete' links are often used in a table 'Action' column.
- Exception: Tables may contain multiple hyperlinks with the same hyperlink text but different underlying destinations, as long as they are defined by table row.
- Hyperlinks are underlined and have sufficient color contrast to distinguish them visibly from non-hyperlinked content. See the Color section for more information.
- Use hyperlinked descriptive text rather than hyperlinked URLs unless there is a need to use hyperlinked URLs.
- Avoid using words and phrases that indicate the hyperlink is a link. For example, do not include "link," "link to," or "this link goes to" in hyperlinked descriptive text or in a link's ScreenTip.
- Very short adjacent hyperlinks have sufficient size or adequate whitespace between them.
- Although not usually recommended in MS Excel workbooks, hyperlinks may contain date notations. See the Link Notations sub-section for more information.
Hyperlinked Descriptive Text
- Hyperlink text by itself provides a clear and concise description of the link destination (e.g., no “click here” or “more” links).
- Recommendation: If the title on the hyperlink's destination web page gives an accurate summary, consider using it for the hyperlink text.
- Hyperlinks that point to a domain (e.g., cde.ca.gov is a domain) that is different from the host domain of the MS Excel workbook, indicate the external source in the hyperlinked descriptive text or in a link notation. See the Link Notations sub-section for more information. See the Link Notations sub-section for more information.
URLs and Email Addresses
- All URLs and email addresses are active hyperlinks.
- Exception: Public comments must not include active hyperlinks.
- Exception: Data within tables (optional, be consistent).
- Exception: Stricken, inactivated, and noted as a broken link.
- Descriptive text is added to the hyperlinked URL's ScreenTip.
- URLs begin with "https://" protocol.
- The visible URL or email address is the same as the underlying URL or email address.
- URL length may be reduced by using the following URL shortening service:
Some hyperlinks require linked meta information to provide users of assistive technology with pertinent details about the hyperlinks. This is referred to as link notation. Structuring link notation consistently throughout a workbook is recommended. Link notations may be comprised of the following two elements, in the following order:
- External Source (Required if applicable.)
- Date & Modifier (Optional)
- Is only used with hyperlinked descriptive text, not with hyperlinked URLs.
- Hyperlinks that point to a domain (e.g., cde.ca.gov is a domain) that is different from the host domain of the MS Excel workbook, and do not contain the external source in the hyperlinked descriptive text, use either the actual external source (e.g., US Department of Education) or "External Link" in the link notation.
Date & Modifier
The addition of a date in Excel workbooks is not recommended but is optional and may be used with any kind of hyperlink. Date link notations must adhere to the following, if used:
- Follows the DD-Mmm-YYYY or Mmm-YYYY format.
- Is prepended with one of the following modifiers:
- New (May be used for 60 days or less.)
- Notice Published
"Coming Soon" is not link notation but may be used similarly with text that will become a link within 60 days.
- Bold is applied to text that will become a link.
- "Coming Soon" is placed within parentheses, one space after the text that will become a link. "(Coming Soon)" is not bold.
Link Notation Formatting
- Link notations are included as part of the associated hyperlink.
- Link notations are placed in parentheses, one space after the hyperlink text or URL.
- All applicable link notation elements are separated by a semicolon and a space.
Note: This section contains examples of links in an MS Excel workbook to a different MS Excel workbook. They are styled to look like hyperlinks but are not functional.
- US Department of Education Web Workbook Name
- Note: This example does not require a link notation since the source is included in the hyperlinked descriptive text.
- Web Workbook Name (US Department of Education)
- Web Workbook Name (External; Added Sep-2023)
- https://www.sampledomain/sampleworkbook.xlsx (Posted 05-Sep-2023)
- Note: This example requires a link notation because of the inclusion of a posted date.
- Web Workbook Name (Coming Soon)
- Color alone does not convey meaning.
- Non-text content (e.g., visual elements) use patterns to convey the same information as color.
- Ensure sufficient color contrast between all content that conveys meaning and its background, with a contrast ratio of at least 4.5:1.
- Exception: Text that is considered large-scale (i.e., at least 18 point or at least 14 point and bold) must meet a lesser contrast ratio of 3:1, at minimum.
- Exception: Non-text elements have a contrast ratio of at least 3:1 against adjacent colors.
- Exception: If a non-text element is accompanied by contrast-conformant text that conveys the same information as the non-text element, there is no required contrast ratio between adjacent colors.
- Example: Though not recommended, a pie chart with minimal contrast between adjacent colors is acceptable as long as each pie wedge has contrast-conformant labels that convey the same information.
- Exception: Text and non-text elements that are part of a logo or brand name have no contrast requirement.
- When there is a mixed or gradient background, measure color contrast at the point with the least contrast to determine compliance.
- Applies to all hyperlink states (e.g., visited, unvisited).
- Ensure sufficient color contrast between hyperlink text and non-hyperlink text, with a contrast ratio of at least 3:1. See the Recommendations sub-section for more information.
- For consistency, most MS Excel workbooks should predominantly use a black font on a white background.
- For consistency, if using red as an alert, a reminder, or a warning, use Boston University Red (#CC0000 or Red Green Blue [rgb] 204,0,0).
- While standard hyperlink blue is not required, it is the most expected color for hyperlinks and helps with usability. For consistency, use a medium-dark shade of cyan-blue (#0563C1 or Red Green Blue [rgb] 5,99,193) for hyperlink text.
CDE defines visual elements as objects such as charts, diagrams, figures, flow charts, graphics, illustrations, images, maps, organizational charts, photos, and shapes. Only the following Visual Elements are permitted in CDE MS Excel workbooks.
- Excel charts and graphs may be used if they are based upon data within the workbook and adhere to the following guidelines:
- The Chart Title field (chart element) is used for a descriptive chart or graph title.
- Data labels are clear and useful.
- Has equivalent text in the form of alternative text, adjacent text, or a long description. Equivalent text indicates the tab name and cell range where the visual element's supporting data can be found within the workbook. Alternative text is placed in the Description field of the Alternative Text dialog box, not in the Title field.
- Alternative Text: Where an Alt Text field is available, alternative text is added to the Alt Text field. Alternative text is sufficient if it describes the content and purpose of the visual element equivalently in 30 words or less. If alternative text alone cannot provide full equivalency, it must be combined with adjacent text or a long description.
- Adjacent Text: Text adjacent to the visual element describes the content and purpose of the visual element equivalently. Alternative text is added to provide the name of the visual element and indicates where the associated adjacent text or data table is located. If alternative text alone is not sufficient, and adjacent text is not preferred, practical or possible, a long description must be used.
- Long Description: Text or a data table that is located anywhere other than adjacent to the visual element that provides content that is fully equivalent to the visual element, and Alternative Text is added to the visual element that provides the name of the visual element and the location of the nearby hyperlink to the long description. An active hyperlink adjacent to the visual element is present with hyperlink text that names the visual element and indicates the hyperlink leads to a long description of the visual element. An active hyperlink adjacent to the long description leads back to the Excel workbook, and directly to the visual element if possible.
- Organizational logos may be used.
- Watermarks may be used if similar text is provided in the body of the document and there are no color contrast issues created by the inclusion of the watermark.
- MS Excel built-in table element (Insert > Table) is used for tabular data; no images of tables are used.
- The title or broad nature of the table is provided using a heading, Table Name, or alternative text.
- No more than one table is used on any worksheet.
- Tables must be simple and have regularity.
Until MS Excel is capable of making complex tables accessible, do not include complex tables. Complex tables should be simplified or split into multiple simple tables (tables with regularity), on separate worksheets. Ensure that tables have regularity per the following guidelines:
- Tables contain one single column header row as the first row, and have no intermediary sub-headers (rows used to delineate sub-sections of a table, including sub-total rows).
- Column headers are appropriately identified by ensuring "My table has headers" is selected in the Create Table dialog box.
- Tables contain no blank cells, columns, or rows.
- Exception: The last row in a table may have blank cells if the row is being used as a totals row where one or more of the cells is used to total column data. The first cell of the last row must have "Total" or a similar word or phrase.
- Exception: Cells using MS Excel form fields or form controls. See the Forms Standards (Coming Soon) for more information.
- Tables contain no merged or split cells.
- Tables do not use visual-only formatting or alignment (e.g., all caps, bold, italics, and indenting) to convey data association or hierarchy.
- Avoid fixed width tables and columns, so that tables render properly on all devices and Magnifier works without horizontal scrolling.
- When a worksheet's tabular data extend beyond the visible area of the average computer monitor, consider using one or more of MS Excel's Freeze Pane tools, so key column headings or row content will remain visible.
- Column headers are repeated at the top of each page when printed by ensuring column header rows are included in "Rows to repeat at top" in the Page Setup dialog box.
- CDE's Accessibility Standards
Requirements for all CDE content, including MS Excel workbooks.
- CDE Forms Standards (Coming Soon)
Requirements for forms that are developed, procured, maintained, or used under the purview of the CDE, including guidance and examples for form use in MS Excel workbooks.
- CDE Standards References
The CDE's MS Excel Standards are built on the guidance of a number of highly regarded authorities in information and communications technology (ICT) accessibility. See specific references used in developing our MS Excel Standards.