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

resource, Windows from the Keyboard tips 1 Minute

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

Published by Gerry Chevalier

Gerry Chevalier is a retired IT consultant and assistive technology Product Manager. He currently is the co-coordinator of GTT Edmonton, a chapter of the Canadian Council of the Blind. GTT (Get Together With Technology) Edmonton is a self-help peer mentoring group of blind and visually impaired people who meet monthly to share their experiences and learn how assistive technologies can help them lead more independent lives.

Published

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

    1. Thank you very much, Albert. I’m glad you found the tips useful as I did researching and writing them. Gerry.

      Like

Comments are closed.