ACCESSIBLE EXCEL: Brrrr! Freeze Those Row and Column Headings

Microsoft Excel Icons

Need to make your Excel spreadsheets more accessible?

Start by “freezing” column or row headings.

Why is this helpful?

According to the folks at the University of Minnesota’s Accessible U:

“Long lists of data are much easier to read if you freeze column or row headings to allow users to keep both the heading and the data visible. Freezing data aids usability by minimizing cognitive load, and it doesn’t interfere with a screen reader’s ability to read the data.”

Here’s how to freeze rows or columns in an Excel spreadsheet

NOTE: You can only freeze rows at the top and columns on the left side of the worksheet. Freezing rows and columns in the middle of the worksheet will not work.

1) To lock one row only, choose the View tab, and then click Freeze Top Row.

2) To lock one column only, choose the View tab, and then click Freeze First Column.

3) To lock more than one row or column, or to lock both rows and columns at the same time, choose the View tab, and then click Freeze Panes. You will want your cursor to be below the row(s) you want to freeze and to the right of any column(s) you want to freeze.

4) To lock multiple rows (starting with row 1), select the row below the last row you want frozen, choose the View tab, and then click Freeze Panes.

5) To lock multiple columns, select the column to the right of the last column you want frozen, choose the View tab, and then click Freeze Panes.

Find more instructions for freezing Excel spreadsheet rows and columns at the New Mexico State University website.

==

WEBSITE ACCESSIBILITY TESTING & REMEDIATION SERVICES: Mary Gillen is an experienced Website Accessibility Compliance Auditor and Remediator. She can test your website to determine if it meets accessibility standards:

WCAG 2.1: 312 checkpoints covering A, AA and AAA W3 accessibility guidelines
Section 508: 15 US federal guidelines covered by 59 accessibility checkpoints

Find out more about Mary Gillen’s Accessibility Testing & Remediation Services: Websites, PDFs, Office Docs & Videos

===

ACCESSIBLE EPUBS: Use the Ace by DAISY App Testing Tool

Epub Icons

Are the EPUB files you are creating really accessible?

Ace by DAISY is a free, open source EPUB accessibility checking tool which has been created to assist in the evaluation of conformance to the EPUB Accessibility Specification.

Available for Windows, MacOS and Linux

The Ace by DAISY App is a desktop application for Windows, MacOS and Linux, allowing EPUB accessibility testing directly from your desktop, helping to ensure your EPUB content conforms with the EPUB Accessibility 1.0 specification.

Download the Ace by DAISY App and find further developer’s notes, along with installation instructions.

==

WEBSITE ACCESSIBILITY TESTING & REMEDIATION SERVICES: Mary Gillen is an experienced Website Accessibility Compliance Auditor and Remediator. She can test your website to determine if it meets accessibility standards:

WCAG 2.1: 312 checkpoints covering A, AA and AAA W3 accessibility guidelines
Section 508: 15 US federal guidelines covered by 59 accessibility checkpoints

Find out more about Mary Gillen’s Accessibility Testing & Remediation Services: Websites, PDFs, Office Docs & Videos

===

ACCESSIBLE WEB DEVELOPMENT: How to Allow Pinching to Zoom Text

Illustrations of human hands pinching text on mobile phones to increase the type size

According to the WCAG 2.1 – 1.4.4 Resize text (Level AA) Guideline, a user should be able to resize text to 200% without loss of content or function.

The action of “pinching to zoom” text on a mobile phone or tablet is often used by older individuals or users with low vision.

Question
How can you make sure that users can use the “pinching to zoom” technique when viewing your responsive website content?

Answer
Use the correct viewport META tag within the HTML5 header code.

The viewport is the user’s visible area of a web page. It varies with the device, and will be smaller on a mobile phone than on a desktop monitor screen.

Here is the standard meta tag code for a viewport:

<meta name=”viewport” content=”width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no”>


===
width=device-width:
width of the screen in CSS pixels at a scale of 100%
initial-scale: Zoom level when the page is first visited.
minimum-scale: Minimum zoom level to which a user can zoom the page.
maximum-scale: Maximum zoom level to which a user can zoom the page.
user-scalable: Flag which allows the device to zoom in or out. (value= yes/no).

===

Here are the attributes NOT to use in the viewport META tag as well as the values to change:

<meta name=”viewport” content=”width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=yes“>

By eliminating the minimum and maximum scale attributes and setting the user-scalable value to “yes”, the user can then pinch and zoom the text content to a size they can comprehend.

===

WEBSITE ACCESSIBILITY TESTING & REMEDIATION SERVICES: Mary Gillen is an experienced Website Accessibility Compliance Auditor and Remediator. She can test your website to determine if it meets accessibility standards:

WCAG 2.1: 312 checkpoints covering A, AA and AAA W3 accessibility guidelines
Section 508: 15 US federal guidelines covered by 59 accessibility checkpoints

Find out more about Mary Gillen’s Accessibility Testing & Remediation Services: Websites, PDFs, Office Docs & Videos

===

ACCESSIBLE SOCIAL MEDIA: How to Share Audio on Instagram, YouTube and Facebook

Five audio icons

Instagram, Facebook and YouTube all have video sharing functionality.

Reality

They don’t offer a quick and efficient way to share sound when you want to upload an audio file.

Question

How do you turn an audio track into a video?

Answer

Combine it with a static image file.

This type of “artwork video” technique has been around every since video on the web existed. But content writers and editors needed a quick and easy way to create this content.

Let me introduce you to Artwork.

This online app allows you to combine images and audio into videos. You can then download and share the files on your social media accounts.

Once you register and sign-up for a free trial, creating a video just takes seconds.

Take Artwork for a free spin right now.

[SOURCE]

===

WEBSITE ACCESSIBILITY TESTING & REMEDIATION SERVICES: Mary Gillen is an experienced Website Accessibility Compliance Auditor and Remediator. She can test your website to determine if it meets accessibility standards:

WCAG 2.1: 312 checkpoints covering A, AA and AAA W3 accessibility guidelines
Section 508: 15 US federal guidelines covered by 59 accessibility checkpoints

Find out more about Mary Gillen’s Accessibility Testing & Remediation Services: Websites, PDFs, Office Docs & Videos

===

ACCESSIBILITY TESTING: Common Keys Used in Keyboard Operation of Web Pages and Apps

Blue and White Keyboard Tab Key Icons

Web developers serious about accessible design ensure that all web page and app elements — buttons, links, form controls etc. — are reachable by the tab key on the keyboard.

Why?

Many users are physically unable to use a mouse, and need to navigate through the page using only the keyboard.

How can you test a website or app using only the keyboard?

Here are some common key combinations used when testing keyboard operation of web pages and apps:

Tab – move to the next link, form element or button.
Shift+Tab – move to the previous link, form element, or button.
Enter – activate the current link or button.
Space – check or uncheck a checkbox form element. Will also activate a button that currently has focus.
Up/Down arrow keys – move between radio buttons or, in some cases, menu links.
Right/Left arrow keys – in some cases, move between menu links or adjust sliders in audio and video plugins.
Escape – Close the current modal dialog or dropdown menu and return focus to the element that spawned it.

[SOURCE]

===

WEBSITE ACCESSIBILITY TESTING & REMEDIATION SERVICES: Mary Gillen is an experienced Website Accessibility Compliance Auditor and Remediator. She can test your website to determine if it meets accessibility standards:

WCAG 2.1: 312 checkpoints covering A, AA and AAA W3 accessibility guidelines
Section 508: 15 US federal guidelines covered by 59 accessibility checkpoints

Find out more about Mary Gillen’s Accessibility Testing & Remediation Services: Websites, PDFs, Office Docs & Videos

===

ACCESSIBLE FORMS: Phone Number Fields and Text Labels

Black Labrador Retriever Looking Up at Telephone Receiver

Many people with visual or cognitive disabilities can recognize phone number fields in HTML forms and usually understand what info needs to be provided to fill in the fields.

Phone numbers are frequently formatted in fixed, distinctive ways, and Web developers may feel that just providing visual formatting of the fields will be sufficient to identify them.

Not so fast

Even if all the fields have programmatically determined names, a text label must also identify the set of fields as a phone number. The label alerts screen reader users about the content necessary to complete the form field correctly.

Best Practice in HTML5

In its most basic form, a telephone form input and text label can be implemented like this:

<label for=”telNo”>Phone number:</label>
<input id=”telNo” name=”telNo” type=”tel”>

===

WEBSITE ACCESSIBILITY TESTING & REMEDIATION SERVICES: Mary Gillen is an experienced Website Accessibility Compliance Auditor and Remediator. She can test your website to determine if it meets accessibility standards:

WCAG 2.1: 312 checkpoints covering A, AA and AAA W3 accessibility guidelines
Section 508: 15 US federal guidelines covered by 59 accessibility checkpoints

Find out more about Mary Gillen’s Accessibility Testing & Remediation Services: Websites, PDFs, Office Docs & Videos

===

ACCESSIBLE CSS: How to Detect User Preferences for Minimal Animation Motion

Six motion icons

The vestibular system includes parts of the inner ear and brain, responsible for sensory information processing and spatial orientation.

According to the folks at Vestibular.org, “as many as 35 percent of adults aged 40 years or older in the United States (approximately 69 million Americans) have experienced some form of vestibular dysfunction.”

People with vestibular disorders experience symptoms like motion sickness, balance problems, chronic dizziness, headaches, and nausea when looking at large-scale motion on the screen.

Best Practice

Don’t use animations or transitions in interactions without giving the user a way to turn them off.

Possible Fix

Use the @media (prefers-reduced-motion) media query to respect user preferences.

The prefers-reduced-motion CSS media feature is used to detect if the user has requested that the system minimize the amount of animation or motion it uses.

Read Eric Bailey’s excellent article Revisiting prefers-reduced-motion, the reduced motion media query to find out more about browser compatibility and to see code examples.

Additional Resource: A Guide to Creating Accessible Animations by Anna Monus

===

WEBSITE ACCESSIBILITY TESTING & REMEDIATION SERVICES: Mary Gillen is an experienced Website Accessibility Compliance Auditor and Remediator. She can test your website to determine if it meets accessibility standards:

WCAG 2.1: 312 checkpoints covering A, AA and AAA W3 accessibility guidelines
Section 508: 15 US federal guidelines covered by 59 accessibility checkpoints

Find out more about Mary Gillen’s Accessibility Testing & Remediation Services: Websites, PDFs, Office Docs & Videos

===

ACCESSIBILITY TOOLS: Take Trint for a Transcription Spin

Frowning manager reviewing secretary's work

Does the thought of manually preparing a text transcript for an audio or video file make you want to go do something else…like re-arrange your sock drawer?

Time to get Trint, the DIY online transcription tool for your audio/video files.

I use Trint for my own client work. Love this service.

Drop your audio/video files straight into Trint’s web-based AI transcription software to get searchable, editable transcripts in minutes.

Once your edits are complete, export your file in six different formats:

  • Microsoft Word (.docx)
  • SubRip (.srt)
    Universal subtitling format
  • VTT (.vtt)
    Subtitles for use with HTML video players and other software
  • Edit Decision List (.edl)
    Video editing post-production format for importing into Premiere and Media Composer
  • Interactive transcripts (.html)
    Customisable HTML player
  • Project (.xml)

Take Trint for a spin via their 30-minute free trial.

===

WEBSITE ACCESSIBILITY TESTING & REMEDIATION SERVICES: Mary Gillen is an experienced Website Accessibility Compliance Auditor and Remediator. She can test your website to determine if it meets accessibility standards:

WCAG 2.1: 312 checkpoints covering A, AA and AAA W3 accessibility guidelines
Section 508: 15 US federal guidelines covered by 59 accessibility checkpoints

Find out more about Mary Gillen’s Accessibility Testing & Remediation Services: Websites, PDFs, Office Docs & Videos

===

ACCESSIBLE POWERPOINT: How to Set Real-time Automatic Captions and Subtitles

Three Microsoft Powerpoint Logos Against an Orange Background

PowerPoint for Office 365 can transcribe your words as you present and display them on-screen as captions in the same language you are speaking, or as subtitles translated to another language.

12 spoken languages are supported. Subtitles and captions can be written in over 60 languages.

This can help accommodate individuals in the audience who may be deaf or hard of hearing, or more familiar with another language, respectively. This version of PowerPoint can also create downloadable text transcripts from the live presentation.

See it in action

A group of Chinese students visiting from the University of Washington stopped by the Microsoft AI and Research offices to learn about Microsoft Translator’s speech translation technology. In this video, Will Lewis – Principal Technical PM for Microsoft Translator – demonstrated how the Translator live feature and Presentation Translator for PowerPoint can be used to provide live transcription and translation in the classroom.

Find out more:
Present with real-time, automatic captions or subtitles in PowerPoint

===

WEBSITE ACCESSIBILITY TESTING & REMEDIATION SERVICES: Mary Gillen is an experienced Website Accessibility Compliance Auditor and Remediator. She can test your website to determine if it meets accessibility standards:

WCAG 2.1: 312 checkpoints covering A, AA and AAA W3 accessibility guidelines
Section 508: 15 US federal guidelines covered by 59 accessibility checkpoints

Find out more about Mary Gillen’s Accessibility Testing & Remediation Services: Websites, PDFs, Office Docs & Videos

===