Windows from The Keyboard Tips, Microsoft Excel Reviewing Formulas, December 9, 2020

Attention: This blog series ends today. This is the last post. If you have an idea for a future GTT blog series email it to:

GTT@ccbnational.net

Hello. This is Gerry Chevalier from the GTT Edmonton Chapter. This weekly blog provides tips that I find useful as a keyboard user of Windows 10 and Office 365.

The tips do not require a screen reader unless specifically noted. Thus, the tips apply whether you are a keyboard user or low vision mouse user. Here is the last tip of this series.

Microsoft Excel – Reviewing Formulas

When arrowing up/down/left/right among the cells in a spreadsheet the screen reader will announce the value of the cell and if there is a formula attached to the cell, the screen reader will also tell you. You can edit the cell’s data/formula by pressing F2. To quickly review formulas in multiple cells without the need to press F2 on each cell, simply press Control+` and the display will revert to formulas instead of values. As you arrow around the cells, you will now hear the screen reader announce the cell formulas instead of cell values. Press Control+` to revert to displaying cell values.

That’s it for this blog series on Windows from the Keyboard Tips. Don’t forget to contact CCB if you have ideas for future blogs. I hope you have enjoyed reading the tips as much as I have enjoyed researching and writing them.

Here’s a bonus tip courtesy of Albert Ruel to round out the series. Many of the tips have focused on Microsoft Office. There is a user support email list for those who use the Office suite of programs with assistive technology such as screen readers and magnification software. To learn more, visit:

Office-Accessibility at Groups.IO

Or you can subscribe directly by sending an email to:

office-accessibility+subscribe@groups.io

Happy computing, Gerry Chevalier

2 thoughts on “Windows from The Keyboard Tips, Microsoft Excel Reviewing Formulas, December 9, 2020

  1. Gerry, what a spectacular service you have provided to the Canadian blind community over these past 14 months! Thank you from the bottom of my heart. I have enjoyed reading your well researched and written offerings, many of which I now use in my daily computing. I for one will miss receiving your weekly Wednesday treats. Stay safe, be well and have a very Merry Christmas and a Happy, Healthy and Prosperous New Year.

    Like

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.