moderated Excel 2016


John Doering
 

Hello:

I have Office 2016 on my home computer running Windows 10 with all updates and JAWS 2022 with all updates.

When trying to do formulas/functions in Excel, I do not get the drop down choices to arrow to like I get with Office 360 on my work computer.

Does anyone know if I need to change a setting in Excel 2016 or are the drop downs not available in the 2016 version?

Any advice would be appreciated.

 

Thanks in advance,

 

John Doering
Pricing Analyst

Office: 4147783040 Extn:4063
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org

Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.


Van Lant, Robin
 

There is a setting for this. I think it’s under File / Options / Formulas. 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of John Doering
Sent: Wednesday, August 10, 2022 8:41 AM
To: JAWS List <main@jfw.groups.io>
Subject: Excel 2016

 

WARNING: This email originated externally. Exercise caution. Think before clicking links or opening attachments.

 

Hello:

I have Office 2016 on my home computer running Windows 10 with all updates and JAWS 2022 with all updates.

When trying to do formulas/functions in Excel, I do not get the drop down choices to arrow to like I get with Office 360 on my work computer.

Does anyone know if I need to change a setting in Excel 2016 or are the drop downs not available in the 2016 version?

Any advice would be appreciated.

 

Thanks in advance,

 

John Doering
Pricing Analyst

Office: 4147783040 Extn:4063
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org

Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.



KeyCorp Public

KeyBanc Capital Markets Inc. prohibits the use of texts or other unapproved messaging applications for business purposes.

This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. No confidentiality or privilege is waived or lost as a result of any transmission errors. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you have received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy.

This communication is for informational purposes only, is not an offer, solicitation, recommendation or commitment for any transaction or to buy or sell any security or other financial product, and is not intended as investment advice or as a confirmation of any transaction. Any market price, indicative value, estimate, view, opinion, data or other information herein is not warranted as to completeness or accuracy, is subject to change without notice, and KeyBanc Capital Markets Inc. accepts no liability for its use or to update or keep it current. Any views or opinions are those of the individual sender, not necessarily of KeyBanc Capital Markets Inc.

The sender of this communication is a licensed securities representative employed by or associated with KeyBanc Capital Markets Inc. Member FINRA/SIPC and may also represent KeyBank National Association (“KeyBank N.A.”). Securities products and services are offered by KeyBanc Capital Markets Inc. Banking products and services are offered by KeyBank N.A.

127 Public Square, Cleveland, OH 44114

If you prefer not to receive future e-mail offers for products or services from Key send an e-mail to DNERequests@... with 'No Promotional E-mails' in the SUBJECT line.


 

Robin,

It's probably the formula autocomplete checkbox.  I didn't know, until I just checked, that this feature can be toggled on/off while editing formulas by hitting ALT + Down Arrow.

It is ON by default, and I'll bet at one point an ALT + Down Arrow was hit during a formula editing that toggled it off.
--

Brian - Windows 10, 64-Bit, Version 21H2, Build 19044  

Here is a test to find out whether your mission in life is complete.  If you’re alive, it isn’t.
     ~ Lauren Bacall


Van Lant, Robin
 

Wow, had no idea it could toggle!  I don’t normally pay attention to it, so I turned it off in the Options, but I could see using it sometime.  I was on an Excel class a couple weeks ago and the teacher was telling people to follow the prompts to fill in the formulas. I forgot to ask him where that was visually on the screen to see if I could get JAWS to read it.  I’ll ask one of my fellow classmates.   I learned that hitting tab after starting to type a formula will populate the function name and the opening parenthesis.  I love Excel classes for learning new tricks, but it’s hit or miss as to how much is presented visually that I have to find alternate options to use. 

 

 

 

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Brian Vogel
Sent: Wednesday, August 10, 2022 10:17 AM
To: main@jfw.groups.io
Subject: Re: Excel 2016

 

WARNING: This email originated externally. Exercise caution. Think before clicking links or opening attachments.

 

Robin,

It's probably the formula autocomplete checkbox.  I didn't know, until I just checked, that this feature can be toggled on/off while editing formulas by hitting ALT + Down Arrow.

It is ON by default, and I'll bet at one point an ALT + Down Arrow was hit during a formula editing that toggled it off.
--

Brian - Windows 10, 64-Bit, Version 21H2, Build 19044  

Here is a test to find out whether your mission in life is complete.  If you’re alive, it isn’t.
     ~ Lauren Bacall



KeyCorp Public

KeyBanc Capital Markets Inc. prohibits the use of texts or other unapproved messaging applications for business purposes.

This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. No confidentiality or privilege is waived or lost as a result of any transmission errors. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you have received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy.

This communication is for informational purposes only, is not an offer, solicitation, recommendation or commitment for any transaction or to buy or sell any security or other financial product, and is not intended as investment advice or as a confirmation of any transaction. Any market price, indicative value, estimate, view, opinion, data or other information herein is not warranted as to completeness or accuracy, is subject to change without notice, and KeyBanc Capital Markets Inc. accepts no liability for its use or to update or keep it current. Any views or opinions are those of the individual sender, not necessarily of KeyBanc Capital Markets Inc.

The sender of this communication is a licensed securities representative employed by or associated with KeyBanc Capital Markets Inc. Member FINRA/SIPC and may also represent KeyBank National Association (“KeyBank N.A.”). Securities products and services are offered by KeyBanc Capital Markets Inc. Banking products and services are offered by KeyBank N.A.

127 Public Square, Cleveland, OH 44114

If you prefer not to receive future e-mail offers for products or services from Key send an e-mail to DNERequests@... with 'No Promotional E-mails' in the SUBJECT line.


John Doering
 

Brian and Robin:

I was not able to get either of your suggestions to work.

Alt down arrow while in a formula after hitting F2 or while trying to create a formula, does not seem to toggle what I need.

I also could not find the formula auto complete.

Could either of you please give me step by step to find the formula auto complete check box?

 

Thanks,

 

 

John Doering
Pricing Analyst

Office: 4147783040 Extn:4063
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org

Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Brian Vogel
Sent: Wednesday, August 10, 2022 11:17 AM
To: main@jfw.groups.io
Subject: Re: Excel 2016

 

External Message - Use caution when opening links or attachments

Robin,

It's probably the formula autocomplete checkbox.  I didn't know, until I just checked, that this feature can be toggled on/off while editing formulas by hitting ALT + Down Arrow.

It is ON by default, and I'll bet at one point an ALT + Down Arrow was hit during a formula editing that toggled it off.
--

Brian - Windows 10, 64-Bit, Version 21H2, Build 19044  

Here is a test to find out whether your mission in life is complete.  If you’re alive, it isn’t.
     ~ Lauren Bacall


Chris Chaffin
 


Ok, hopefully this might help.

Auto Formula complete will only work if the setting, Allow editing directly in cells, is turned on.
So here is where to find both settings.

Turn on / off Auto Formula complete (check if turned on).
Go to File, Options, then in the list, arrow down to formulas.
Then tab about 5 or 6 times until you get to the auto complete check box.  Again, needs to be checked.

Next, turn on allow editing directly in cells.
Go to file, options, and in the list arrow down to advanced.
Then tab about 6 or 7 times until you hear, allow editing directly in cells checkbox.  Again, this must be turned on in order for the auto formula complete to work.

I have tested this on my system, and if both of these settings are on, then it works just fine.

Hope this helps.

Chris



On Aug 15, 2022, at 8:13 AM, John Doering <john.doering@...> wrote:



Brian and Robin:

I was not able to get either of your suggestions to work.

Alt down arrow while in a formula after hitting F2 or while trying to create a formula, does not seem to toggle what I need.

I also could not find the formula auto complete.

Could either of you please give me step by step to find the formula auto complete check box?

 

Thanks,

 

 

John Doering
Pricing Analyst

Office: 4147783040 Extn:4063
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org

Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Brian Vogel
Sent: Wednesday, August 10, 2022 11:17 AM
To: main@jfw.groups.io
Subject: Re: Excel 2016

 

External Message - Use caution when opening links or attachments

Robin,

It's probably the formula autocomplete checkbox.  I didn't know, until I just checked, that this feature can be toggled on/off while editing formulas by hitting ALT + Down Arrow.

It is ON by default, and I'll bet at one point an ALT + Down Arrow was hit during a formula editing that toggled it off.
--

Brian - Windows 10, 64-Bit, Version 21H2, Build 19044  

Here is a test to find out whether your mission in life is complete.  If you’re alive, it isn’t.
     ~ Lauren Bacall


John Doering
 

Chris:

Did as you indicated below.  Still no Joy, but thanks for the help.

 

Regards,

 

 

John Doering
Pricing Analyst

Office: 4147783040 Extn:4063
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org

Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Chris Chaffin
Sent: Monday, August 15, 2022 8:29 AM
To: main@jfw.groups.io
Subject: Re: Excel 2016

 

External Message - Use caution when opening links or attachments

 

Ok, hopefully this might help.

 

Auto Formula complete will only work if the setting, Allow editing directly in cells, is turned on.

So here is where to find both settings.

 

Turn on / off Auto Formula complete (check if turned on).

Go to File, Options, then in the list, arrow down to formulas.

Then tab about 5 or 6 times until you get to the auto complete check box.  Again, needs to be checked.

 

Next, turn on allow editing directly in cells.

Go to file, options, and in the list arrow down to advanced.

Then tab about 6 or 7 times until you hear, allow editing directly in cells checkbox.  Again, this must be turned on in order for the auto formula complete to work.

 

I have tested this on my system, and if both of these settings are on, then it works just fine.

 

Hope this helps.

 

Chris

 

 



On Aug 15, 2022, at 8:13 AM, John Doering <john.doering@...> wrote:



Brian and Robin:

I was not able to get either of your suggestions to work.

Alt down arrow while in a formula after hitting F2 or while trying to create a formula, does not seem to toggle what I need.

I also could not find the formula auto complete.

Could either of you please give me step by step to find the formula auto complete check box?

 

Thanks,

 

 

John Doering
Pricing Analyst

Office: 4147783040 Extn:4063
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org

Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Brian Vogel
Sent: Wednesday, August 10, 2022 11:17 AM
To: main@jfw.groups.io
Subject: Re: Excel 2016

 

External Message - Use caution when opening links or attachments

Robin,

It's probably the formula autocomplete checkbox.  I didn't know, until I just checked, that this feature can be toggled on/off while editing formulas by hitting ALT + Down Arrow.

It is ON by default, and I'll bet at one point an ALT + Down Arrow was hit during a formula editing that toggled it off.
--

Brian - Windows 10, 64-Bit, Version 21H2, Build 19044  

Here is a test to find out whether your mission in life is complete.  If you’re alive, it isn’t.
     ~ Lauren Bacall


Van Lant, Robin
 

John,

I’ve not used this feature in the past, but I’m really curious now and exploring it with you. So, here are my observations from playing around.

It seems that the driving factor of whether this works is if you have the setting to allow editing in cells turned on or off.  Recall that that is under Options in the Advance category.  That needs to be turned on.

 

From my testing, Brian is right that  the alt down arrow is a toggle for the setting to have formula autocomplete on., but I was misunderstanding how it worked.  I wonder if this is the issue you are having, too.  Whether I have the checkbox on the Options  menu for formula autocomplete turned on or if it’s off an i use the alt down arrow, I only get results if I type a letter after the equals sign. So, even if the formula autocomplete is turned on and I only type an equals sign in the cell, nothing happens and the  cell until I type a single letter, at which point it suggests functions with that letter. If you hear JAWS say a suggestion, you can arrow down through the options, If you don’t hear JAWS read out an option, you’ll need to do the alt down arrow, just like you would with a combo box. Then you can arrow through the list of suggestions and hit enter on the one you want.

 

Disappointedly, I don’t think there is a way to read the  tag that shows the syntax for the formula.  I’d like to figure out of there are options for that.

 

An alternative, especially for common functions or ones you don’t know is to type the equals sign, then hit Alt F3. This puts you in the formula bar and, if you hit alt down arrow, you get a list of common functions.   Hitting enter one of these opens a dialog box for arguments.  Further in the list is a More button you can use to search for functions alphabetically or with keywords.

 

The other trick I learned recently was to type the equals sign then a couple letters of the function you want then hit tab, which autocomplete the function and enters the opening parenthesis.  I suppose that works only if you are doing a function like vlookup or xlookup that is more unique that, say, a count function that could end multiple ways.

 

Using Windows 10, JAWS 2022, Office 365.

Robin Van Lant

 

 

 

 

 

 



KeyCorp Public

KeyBanc Capital Markets Inc. prohibits the use of texts or other unapproved messaging applications for business purposes.

This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. No confidentiality or privilege is waived or lost as a result of any transmission errors. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you have received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy.

This communication is for informational purposes only, is not an offer, solicitation, recommendation or commitment for any transaction or to buy or sell any security or other financial product, and is not intended as investment advice or as a confirmation of any transaction. Any market price, indicative value, estimate, view, opinion, data or other information herein is not warranted as to completeness or accuracy, is subject to change without notice, and KeyBanc Capital Markets Inc. accepts no liability for its use or to update or keep it current. Any views or opinions are those of the individual sender, not necessarily of KeyBanc Capital Markets Inc.

The sender of this communication is a licensed securities representative employed by or associated with KeyBanc Capital Markets Inc. Member FINRA/SIPC and may also represent KeyBank National Association (“KeyBank N.A.”). Securities products and services are offered by KeyBanc Capital Markets Inc. Banking products and services are offered by KeyBank N.A.

127 Public Square, Cleveland, OH 44114

If you prefer not to receive future e-mail offers for products or services from Key send an e-mail to DNERequests@... with 'No Promotional E-mails' in the SUBJECT line.


Randy Meyer
 

I will add to this discussion how I work with formulas in Excel.

 

I use a lot of financial formulas,: present value (pv), future value (fv), and similar formulas.  I know the starting point for each formula.

 

For example if I want to figure out a present value.  When in the cell where I want the formula, I press equals followed by pv, then I generate the rest of the formula by pressing control-shift-a and press enter, which puts me down one cell.  I arrow back up to the cell I am placing the formula in, ignore the error message regarding the formula and press f2 to edit the formula.  In this case it allows me to edit the following: =pv(rate,nper,pmt,fv,type).  I then fill in my numbers and delete the words, for example 4% where it says rate and I delete rate.  Since I know these formulas, I repeat the inserting of numbers or cell references, leaving the commas and deleting the words.

 

This works well for me when using formulas I am familiar with.

 

I look forward to trying some of the suggestions in this thread.  I don’t know if what I shared above will be helpful to anyone, but I thought I would share it.

 

Randy Meyer

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Van Lant, Robin via groups.io
Sent: Wednesday, August 17, 2022 11:12 AM
To: main@jfw.groups.io
Subject: Re: Excel 2016

 

John,

I’ve not used this feature in the past, but I’m really curious now and exploring it with you. So, here are my observations from playing around.

It seems that the driving factor of whether this works is if you have the setting to allow editing in cells turned on or off.  Recall that that is under Options in the Advance category.  That needs to be turned on.

 

From my testing, Brian is right that  the alt down arrow is a toggle for the setting to have formula autocomplete on., but I was misunderstanding how it worked.  I wonder if this is the issue you are having, too.  Whether I have the checkbox on the Options  menu for formula autocomplete turned on or if it’s off an i use the alt down arrow, I only get results if I type a letter after the equals sign. So, even if the formula autocomplete is turned on and I only type an equals sign in the cell, nothing happens and the  cell until I type a single letter, at which point it suggests functions with that letter. If you hear JAWS say a suggestion, you can arrow down through the options, If you don’t hear JAWS read out an option, you’ll need to do the alt down arrow, just like you would with a combo box. Then you can arrow through the list of suggestions and hit enter on the one you want.

 

Disappointedly, I don’t think there is a way to read the  tag that shows the syntax for the formula.  I’d like to figure out of there are options for that.

 

An alternative, especially for common functions or ones you don’t know is to type the equals sign, then hit Alt F3. This puts you in the formula bar and, if you hit alt down arrow, you get a list of common functions.   Hitting enter one of these opens a dialog box for arguments.  Further in the list is a More button you can use to search for functions alphabetically or with keywords.

 

The other trick I learned recently was to type the equals sign then a couple letters of the function you want then hit tab, which autocomplete the function and enters the opening parenthesis.  I suppose that works only if you are doing a function like vlookup or xlookup that is more unique that, say, a count function that could end multiple ways.

 

Using Windows 10, JAWS 2022, Office 365.

Robin Van Lant

 

 

 

 

 

 



KeyCorp Public

KeyBanc Capital Markets Inc. prohibits the use of texts or other unapproved messaging applications for business purposes.

This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. No confidentiality or privilege is waived or lost as a result of any transmission errors. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you have received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy.

This communication is for informational purposes only, is not an offer, solicitation, recommendation or commitment for any transaction or to buy or sell any security or other financial product, and is not intended as investment advice or as a confirmation of any transaction. Any market price, indicative value, estimate, view, opinion, data or other information herein is not warranted as to completeness or accuracy, is subject to change without notice, and KeyBanc Capital Markets Inc. accepts no liability for its use or to update or keep it current. Any views or opinions are those of the individual sender, not necessarily of KeyBanc Capital Markets Inc.

The sender of this communication is a licensed securities representative employed by or associated with KeyBanc Capital Markets Inc. Member FINRA/SIPC and may also represent KeyBank National Association (“KeyBank N.A.”). Securities products and services are offered by KeyBanc Capital Markets Inc. Banking products and services are offered by KeyBank N.A.

127 Public Square, Cleveland, OH 44114

If you prefer not to receive future e-mail offers for products or services from Key send an e-mail to DNERequests@... with 'No Promotional E-mails' in the SUBJECT line.


John Doering
 

Robin:

Tried your suggestions and still no joy.

It seems you are using Office 360.  I am using Office 2016.

Maybe I need to call the MS Accessibility line to see if Office 2016 offers the drop down choices when setting up formulas/functions.

Thanks for your help.

 

Regards,

 

 

John Doering
Pricing Analyst

Office: 4147783040 Extn:4063
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org

Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Van Lant, Robin via groups.io
Sent: Wednesday, August 17, 2022 11:12 AM
To: main@jfw.groups.io
Subject: Re: Excel 2016

 

External Message - Use caution when opening links or attachments

John,

I’ve not used this feature in the past, but I’m really curious now and exploring it with you. So, here are my observations from playing around.

It seems that the driving factor of whether this works is if you have the setting to allow editing in cells turned on or off.  Recall that that is under Options in the Advance category.  That needs to be turned on.

 

From my testing, Brian is right that  the alt down arrow is a toggle for the setting to have formula autocomplete on., but I was misunderstanding how it worked.  I wonder if this is the issue you are having, too.  Whether I have the checkbox on the Options  menu for formula autocomplete turned on or if it’s off an i use the alt down arrow, I only get results if I type a letter after the equals sign. So, even if the formula autocomplete is turned on and I only type an equals sign in the cell, nothing happens and the  cell until I type a single letter, at which point it suggests functions with that letter. If you hear JAWS say a suggestion, you can arrow down through the options, If you don’t hear JAWS read out an option, you’ll need to do the alt down arrow, just like you would with a combo box. Then you can arrow through the list of suggestions and hit enter on the one you want.

 

Disappointedly, I don’t think there is a way to read the  tag that shows the syntax for the formula.  I’d like to figure out of there are options for that.

 

An alternative, especially for common functions or ones you don’t know is to type the equals sign, then hit Alt F3. This puts you in the formula bar and, if you hit alt down arrow, you get a list of common functions.   Hitting enter one of these opens a dialog box for arguments.  Further in the list is a More button you can use to search for functions alphabetically or with keywords.

 

The other trick I learned recently was to type the equals sign then a couple letters of the function you want then hit tab, which autocomplete the function and enters the opening parenthesis.  I suppose that works only if you are doing a function like vlookup or xlookup that is more unique that, say, a count function that could end multiple ways.

 

Using Windows 10, JAWS 2022, Office 365.

Robin Van Lant

 

 

 

 

 

 



KeyCorp Public

KeyBanc Capital Markets Inc. prohibits the use of texts or other unapproved messaging applications for business purposes.

This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. No confidentiality or privilege is waived or lost as a result of any transmission errors. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you have received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy.

This communication is for informational purposes only, is not an offer, solicitation, recommendation or commitment for any transaction or to buy or sell any security or other financial product, and is not intended as investment advice or as a confirmation of any transaction. Any market price, indicative value, estimate, view, opinion, data or other information herein is not warranted as to completeness or accuracy, is subject to change without notice, and KeyBanc Capital Markets Inc. accepts no liability for its use or to update or keep it current. Any views or opinions are those of the individual sender, not necessarily of KeyBanc Capital Markets Inc.

The sender of this communication is a licensed securities representative employed by or associated with KeyBanc Capital Markets Inc. Member FINRA/SIPC and may also represent KeyBank National Association (“KeyBank N.A.”). Securities products and services are offered by KeyBanc Capital Markets Inc. Banking products and services are offered by KeyBank N.A.

127 Public Square, Cleveland, OH 44114

If you prefer not to receive future e-mail offers for products or services from Key send an e-mail to DNERequests@... with 'No Promotional E-mails' in the SUBJECT line.


Van Lant, Robin
 

Office 2016 is such a modern choice and I can’t imagine it’s that different, but I do think it’s time for you to call them. 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of John Doering
Sent: Thursday, August 18, 2022 9:25 AM
To: main@jfw.groups.io
Subject: Re: Excel 2016

 

WARNING: This email originated externally. Exercise caution. Think before clicking links or opening attachments.

 

Robin:

Tried your suggestions and still no joy.

It seems you are using Office 360.  I am using Office 2016.

Maybe I need to call the MS Accessibility line to see if Office 2016 offers the drop down choices when setting up formulas/functions.

Thanks for your help.

 

Regards,

 

 

John Doering
Pricing Analyst

Office: 4147783040 Extn:4063
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org

Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Van Lant, Robin via groups.io
Sent: Wednesday, August 17, 2022 11:12 AM
To: main@jfw.groups.io
Subject: Re: Excel 2016

 

External Message - Use caution when opening links or attachments

John,

I’ve not used this feature in the past, but I’m really curious now and exploring it with you. So, here are my observations from playing around.

It seems that the driving factor of whether this works is if you have the setting to allow editing in cells turned on or off.  Recall that that is under Options in the Advance category.  That needs to be turned on.

 

From my testing, Brian is right that  the alt down arrow is a toggle for the setting to have formula autocomplete on., but I was misunderstanding how it worked.  I wonder if this is the issue you are having, too.  Whether I have the checkbox on the Options  menu for formula autocomplete turned on or if it’s off an i use the alt down arrow, I only get results if I type a letter after the equals sign. So, even if the formula autocomplete is turned on and I only type an equals sign in the cell, nothing happens and the  cell until I type a single letter, at which point it suggests functions with that letter. If you hear JAWS say a suggestion, you can arrow down through the options, If you don’t hear JAWS read out an option, you’ll need to do the alt down arrow, just like you would with a combo box. Then you can arrow through the list of suggestions and hit enter on the one you want.

 

Disappointedly, I don’t think there is a way to read the  tag that shows the syntax for the formula.  I’d like to figure out of there are options for that.

 

An alternative, especially for common functions or ones you don’t know is to type the equals sign, then hit Alt F3. This puts you in the formula bar and, if you hit alt down arrow, you get a list of common functions.   Hitting enter one of these opens a dialog box for arguments.  Further in the list is a More button you can use to search for functions alphabetically or with keywords.

 

The other trick I learned recently was to type the equals sign then a couple letters of the function you want then hit tab, which autocomplete the function and enters the opening parenthesis.  I suppose that works only if you are doing a function like vlookup or xlookup that is more unique that, say, a count function that could end multiple ways.

 

Using Windows 10, JAWS 2022, Office 365.

Robin Van Lant

 

 

 

 

 

 



KeyCorp Public

KeyBanc Capital Markets Inc. prohibits the use of texts or other unapproved messaging applications for business purposes.

This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. No confidentiality or privilege is waived or lost as a result of any transmission errors. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you have received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy.

This communication is for informational purposes only, is not an offer, solicitation, recommendation or commitment for any transaction or to buy or sell any security or other financial product, and is not intended as investment advice or as a confirmation of any transaction. Any market price, indicative value, estimate, view, opinion, data or other information herein is not warranted as to completeness or accuracy, is subject to change without notice, and KeyBanc Capital Markets Inc. accepts no liability for its use or to update or keep it current. Any views or opinions are those of the individual sender, not necessarily of KeyBanc Capital Markets Inc.

The sender of this communication is a licensed securities representative employed by or associated with KeyBanc Capital Markets Inc. Member FINRA/SIPC and may also represent KeyBank National Association (“KeyBank N.A.”). Securities products and services are offered by KeyBanc Capital Markets Inc. Banking products and services are offered by KeyBank N.A.

127 Public Square, Cleveland, OH 44114

If you prefer not to receive future e-mail offers for products or services from Key send an e-mail to DNERequests@... with 'No Promotional E-mails' in the SUBJECT line.