Re: Excel 2016: Formulas
|
Louis Maher
In editing Excel cells, sometime it is necessary to make the following configuration change.
You can try unchecking the box which says “allow editing directly in cells”. In Excel 365, do this: Open an Excel spreadsheet. Type alt + f. Up arrow to options, hit enter. Down arrow to advanced. Tab until you find the box which says “allow editing directly in cells. Uncheck that box. Shift + Tab until you reach OK. Hit enter.
Regards Louis Maher Phone: 713-444-7838 E-mail ljmaher03@...
From: nvda@nvda.groups.io <nvda@nvda.groups.io> On Behalf Of
Jonathan COHN via groups.io
Sent: Sunday, January 17, 2021 11:47 AM To: nvda@nvda.groups.io Subject: Re: [nvda] Excel 2016: Formulas
F2 brings you to the formula bar. This does have something to do with the auto complete, but I haven't edited formulas in Excel in a couple years, so I don't remember exactly why there are issues. Using arrow keys, I believe jumps you to the excel table to select a cell or group s of cells to add to the formula.
|
|
|