Re: Excel: Stop Saying "Formula Bar"


Sarah k Alawami
 

Would editing directly in cells be in excel? I'm guessing yes. I recall seeing that setting somewhere. Oh wouldn't it be nice if I could search the settings panel for "editing" and get a narrow list of options? Oh well, such is life. I'm not in excel, not even on my windows computer right now so I'll look when I next launch excel, probably the next time I generate a report.

--

Sarah Alawami, owner of TFFP. . For more info go to our website.

Check out my adventures with a shadow machine.

to subscribe to the feed click here and you can also follow us on twitter

Our discord is where you will know when we go live on twitch. Feel free to give the channel a follow and see what is up there.

For stream archives, products you can buy and more visit my main lbry page and my tffp lbry page You will also be able to buy some of my products and eBooks there.

Finally, to become a patron and help support the podcast go here

On 30 Mar 2021, at 2:58, Cearbhall O'Meadhra wrote:

Sara, Brian and all who follow this thread,

 

I am running:

Microsoft Excel 2016

Windows 10 Version 2004 (OS Build 19041.867)

NVDA Version: 2020.4

 

After trying various combinations of the following two settings under the Advanced tab in the excel Options,

When I pressed the “=” key to edit  a cell,

I found

First, that NVDA says "Formula Bar editing Equals" When:

"Allow editing directly in cells" is disabled

“Show formula bar” is enabled

 

Next, I found that NVDA stops saying "Formula Bar editing Equals"

and says "Pane" instead When:

"Allow editing directly in cells" is disabled

“Show formula bar” is disabled.

 

The good news is that

I found that NVDA stops saying "Formula Bar editing Equals" and, instead, says "Editing Equals" When:

"Allow editing directly in cells" is enabled

“Show formula bar” is either enabled or disabled

 

Conclusion:

So, to disable the annoying "Formula Bar editing Equals”, the setting for Allowing editing in cells" needs to be enabled and it does not matter whether "Show formula bar" is enabled or disabled.

 

I hope this helps.

 

All the best,

 

Cearbhall

 

m +353 (0)833323487 Ph: _353 (0)1-2864623 e: cearbhall.omeadhra@...

 

 

From: nvda@nvda.groups.io <nvda@nvda.groups.io> On Behalf Of Sarah k Alawami
Sent: Monday, March 29, 2021 11:44 PM
To: nvda@nvda.groups.io
Subject: Re: [nvda] Excel: Stop Saying "Formula Bar"

 

I actually have that issue as well. When I edit my reports I hear "entering formula bar" when I hit f2 to edit and it doesn't matter what i enter, a call sign? Text? Numbers? What ever I enter I do hear it, and sometimes I do not.

--

Sarah Alawami, owner of TFFP. . For more info go to our website.

Check out my adventures with a shadow machine.

to subscribe to the feed click here and you can also follow us on twitter

Our discord is where you will know when we go live on twitch. Feel free to give the channel a follow and see what is up there.

For stream archives, products you can buy and more visit my main lbry page and my tffp lbry page You will also be able to buy some of my products and eBooks there.

Finally, to become a patron and help support the podcast go here

On 29 Mar 2021, at 9:49, Brian Vogel wrote:

On Mon, Mar 29, 2021 at 12:37 PM, Pele West wrote:

Is there a setting to stop NVDA saying "Formula Bar" every time I type in a cell in Excel?

-
What are you typing?

If it is indeed a formula, this is NVDA's way of letting you know that Excel has caught that fact and the cell formula is being entered in the formula bar.

If it's just text, or a number, or something else then you shouldn't hear that announcement, as a formula has not been detected.

I know of no way to turn that off and, for myself, would not want to.
--

Brian - Windows 10 Pro, 64-Bit, Version 20H2, Build 19042  

Always remember others may hate you but those who hate you don't win unless you hate them.  And then you destroy yourself.

       ~ Richard M. Nixon

 

Join nvda@nvda.groups.io to automatically receive all group messages.