How to Create Accessible Excel Documents

Supriti Tripathy

6th May'21

Excel is one of the most innovative solutions to manage a hassle-free workbook. The best part about this feature is not only the modernity and presentation but also the accessibility to multiple users. It provides built-in templates to make the documents accessible to the end-user and Excel also lets the user make manual changes apart from the default templates. Better accessibility paves way for the user in terms of ease of view of the data, proper acknowledgment of the records, and getting right on the presentation.
Here is a Step by Step process on how to enable the accessibility features. Read on to know more.
 

Systematic Approach for better accessibility

 

Step 1: Choose a Template


A built-in template reduces time and presents your information in a manner that is quite professional. Some of the techniques that can be enabled are:

 

·         A proper name to the spreadsheet via Rename command. A spreadsheet for information about company employees must have a name like Comp_Emp rather than the default as Sheet1.

 

·         Color contrast helps readers to get the information in a clear format. In fact, it also works well with color-blind readers and low vision users. Make sure the font size is large enough, especially more than 12 points.

 

·         Screen-readers help low vision users get access to the data through the descriptive labels by listening to these readers. Also, make sure that the use of white space is proper and there are no blank sheets in the workbook.

 

·         Also, keep in mind the language of the document is as per the need of your end-user. To change the language, go to File-Options-Choose Editing language.

 


Step 2: Create Accessible Tables and descriptive text


·         Using the Insert--Table option from the ribbon, you can select a particular section on your spreadsheet and choose the “My table has headers” option. Screen-readers tend to read table headers to go onto tables.

 

·         Descriptive text for images, charts, graphs, and tables implies text that describes the figure properly so that a visually impaired user can understand it all through the text. For simple images, it should be about 120 characters and more for complex images, tables, and graphs.

 

·         This kind of alternate text describes the content that is similar to what is represented in the image. It lets the user identify the figure correctly.

 

·         Charts, bars, and graphs must be properly described so that the statistics are easily understandable by the user. Example: A bar graph depicts the increase in population from 20000 to 45000 in 4 years from 2001-2004 at a small town Joda due to starting of schools.

 

·         Right-click on the Image—Format. On the left panel, there will be an alt text option. Use it to provide the right description. Do the same for tables as well.
 

 

alttext

 

 

Step 3: Optimizing Tables

 

We know that tables give perfect documentation of any statistics for a bigger group. We already know how to create tables in Excel. We can work on optimizing the tables to give proper accessibility to all kinds of users.

 

·         On the Design tab, change the name of the table to something more descriptive than the default name.

 

·         Select the first column of the table and choose Banded rows. The row separation becomes more clear with this.

 

·         Use the right kind of table style for better accessibility. Darker contrast colors enable greater accessibility.

 

·         From the Home tab, alter the font size to a bigger font so that data inside the table is clearly visible.

 

·         Make rows a little taller by going to Format---Row Height and increase it. There must be enough space between texts too so that it looks well organized. This way users with dyslexia can also access it well.

 

·         Make sure to bold the title of your table to make it stand out.

 


Step 4: Navigation through names


·         For better accessibility and navigation by multiple users, it is a good practice to name the cell sections. Name them with the purpose they solve.


·         Select a range of cells, select Formula on the top ribbon, and select the Define Name option.

 

·         Provide an appropriate title for the cell range under the Name field and mention the scope. The scope determines which all worksheets will follow this naming convention. Click on ok after verifying the range.

 

·         Use Ctrl+G to see the names of the cell sections and hop on from one to another conveniently.

 

 

Step 5: Make Charts, graphs, and plots readily accessible


·         Charts, like tables, must be assigned descriptive text to enable low vision users to get the meaning of the conclusion from the figures.

 

·         After creating a chart from the Insert option, provide a proper name and change the default. Eg: A name like “Emp_Record_Salaryhike_Years” enables a viewer to understand the purpose of the cart better.

 

·         Add axis titles via Design---Add Chart Element---Axis Titles.

 

·         For data labels go to Design---Add Chart Element---Data Labels. Here select the axis, go to Format---Current Selection---Format Selection. It opens a plethora of options of axis crosses, position, type, number format, etc.

 

·         Select bigger font size for clarity of the plot done from the Home tab.

 

 

charts 

 

 

 

Recommended: How Technology is Revolutionizing Beauty Ecommerce

 

 

Conclusion


The above steps ensure that in Excel we can use features to create documents that can be easily deciphered and accessible to any kind of user. We just have to incorporate care when we understand the user type. Screen readers help low vision users get access to and understand documents in a better way. The Accessibility Checker enables you to deal with any accessibility issues that the machine thinks there are. You can click on the File tab on the top left corner of the sheet, select Info, from the drop-down check for issues, and select the Check Accessibility option. The issues can then be addressed.

 

 

We, at OpenGrowth, are committed to keeping you updated with the best content on the latest trendy topics from any major field. Also, both your feedback and suggestions are valuable to us. So, do share them in the comment section below.

 

A believer of good things and pursuer of diverse avocation, she is a fiction lover and a simple writer. Supriti has a number of professions to her list and she feels challenges are the only answers to failures.

Comments

natashathomson124@gmail.com

13th Sep'22 05:26:27 PM

My name is Natasha Thompson from the USA/Texas.. Am so overwhelmed with gratitude to let the world know how Dr Kachi, the great spell caster changed my life for good. It all started when I lost my job and I was down financially and emotionally because I couldn’t be able provide for my two kids and staying home all day Jobless it’s not easy until I was checking on the internet when I saw a series of testimonies hearing people winning the Powerball lottery, I didn’t believed, but being poor no job you have no option. I gave it a try and I contacted Dr Kachi who told me what i have to do before I can become a big lottery winner and I accepted. He made special prayers for me in his temple and gave me the required numbers to play the lottery game and when I used the numbers to play it, I won a massive $344.6 million Powerball jackpot. I was so happy and I choose to review my winning in any platform, I would love other people to seek help from Dr Kachi through WhatsApp/number : +1 (602) 854-4366 or email drkachispellcast@gmail.com by his website: https://drkachispellcast.wixsite.com/my-site

julianadavis877@gmail.com

12th Sep'22 03:26:22 PM

i want to share to the whole world how Dr Kachi the Great of all the Spell Caster, that helped me reunite my marriage back, my Ex Husband broke up with me 3months ago, I have been trying to get him back ever since then, i was worried and so confused because i love him so much. I was really going too much depressed, he left me with my kids and just ignored me constantly. I have begged him for forgiveness through text messages for him to come back home and the kids crying and miss their dad but he wont reply, I wanted him back desperately. we were in a very good couple and yet he just ignores me and get on with his life just like that, so i was looking for help after reading a post of Dr Kachi on the internet when i saw a lady name SHARRON testified that Dr Kachi cast a Pure love spell to stop divorce. and i also met with other, it was about how he brought back her Ex lover in less than 24 hours at the end of her testimony she dropped his email, I contacted Dr Kachi via email and explained my problem to Dr Kachi and he told me what went wrong with my husband and how it happen, that he will restored my marriage back, and to my greatest surprise my Ex husband came back to me, and he apologized for his mistake, and for the pain he caused me and my children. Then from that day our marriage is now stronger than how it was before, Dr Kachi you're a real spell caster, you can also get your Ex back and live with him happily: Contact Email drkachispellcast@gmail.com his WhatsApp number: +1 (602) 854-4366 Visit his Website: https://drkachispellcast.wixsite.com/my-site

julianadavis877@gmail.com

9th Sep'22 06:12:35 PM

i want to share to the whole world how Dr Kachi the Great of all the Spell Caster, that helped me reunite my marriage back, my Ex Husband broke up with me 3months ago, I have been trying to get him back ever since then, i was worried and so confused because i love him so much. I was really going too much depressed, he left me with my kids and just ignored me constantly. I have begged him for forgiveness through text messages for him to come back home and the kids crying and miss their dad but he wont reply, I wanted him back desperately. we were in a very good couple and yet he just ignores me and get on with his life just like that, so i was looking for help after reading a post of Dr Kachi on the internet when i saw a lady name SHARRON testified that Dr Kachi cast a Pure love spell to stop divorce. and i also met with other, it was about how he brought back her Ex lover in less than 24 hours at the end of her testimony she dropped his email, I contacted Dr Kachi via email and explained my problem to Dr Kachi and he told me what went wrong with my husband and how it happen, that he will restored my marriage back, and to my greatest surprise my Ex husband came back to me, and he apologized for his mistake, and for the pain he caused me and my children. Then from that day our marriage is now stronger than how it was before, Dr Kachi you're a real spell caster, you can also get your Ex back and live with him happily: Contact Email drkachispellcast@gmail.com his WhatsApp number: +1 (602) 854-4366 Visit his Website: https://drkachispellcast.wixsite.com/my-site

robertmorrison744@gmail.com

27th Aug'22 06:25:39 AM

READ MY REVIEW HOW I WIN $158m CONTACT DR KACHI NOW FOR YOUR OWN LOTTERY WINNING NUMBERS. I was a gas station truck driver and I always playing the SUPER LOTTO GAME, I’m here to express my gratitude for the wonderful thing that Dr Kachi did for me, Have anybody hear of the professional great spell caster who help people to win Lottery and clear all your debt and buy yourself a home and also have a comfortable life living. Dr Kachi Lottery spell casting is wonders and work very fast. He helped me with lucky numbers to win a big money that changed my life and my family. Recently i won, ONE HUNDRED AND FIFTY EIGHT MILLIONS DOLLARS, A Super Lotto ticket I bought in Oxnard Liquor Store, I am so grateful to meet Dr Kachi on internet for helping me to win the lottery and if you also need his help, email him at: drkachispellcast@gmail.com and he will also help you as well to win and make you happy like me today. His WhatsApp number: +1 (570) 775-3362 visit his Website, https://drkachispellcast.wixsite.com/my-site

Blank ATM Card +393512615163

19th May'22 10:52:35 PM

Get $5,500 USD every day, for six months! See how it works. What'sApp : +393512615163 I want to testify about Dark Web blank atm cards which can withdraw money from any atm machines around the world. I was very poor before and have no job. I saw so much testimony about how Dark Web hackers send them the atm blank card and use it to collect money in any atm machine and become rich. Email : carolblankatmcard@gmail.com Hangout : carolblankatmcard@gmail.com What'sApp : +393512615163 They also sent me the blank atm card. I have used it to get 90,000 dollars. withdraw the maximum of 5,000 USD daily. The Dark Web is giving out cards just to help the poor. Hack and take money directly from any atm machine vault with the use of an atm programmed card which runs in automatic mode.