Re: Editing Excel Cells
toggle quoted messageShow quoted text
Thanks for this tip. It is nice to have a work-around. I have always set up Excel to edit directly in the cell, because past experience indicated that was best.
I’ve had Excel issues for more than six weeks now. It began with the PC freezing, when editing a worksheet. After trying several things, I resorted to using the Fresh Start option in Windows 10’s Security Settings. (I did this after checking for updates to Office 365 and finding none.)
When Windows, NVDA 2018.1.1, and Office 365 were reinstalled and set up, I discovered the situation described in this thread. I was annoyed.
I did not have time to add my input until now. Thanks again for this resolution. I hope Microsoft doesn’t break something else. I firmly believe the need to change from editing in the cell to editing in the formula bar is due to some change Microsoft made to the Excel program.
From: firstname.lastname@example.org <email@example.com> On Behalf Of Louis Maher
Sent: Monday, April 23, 2018 2:04 PM
Subject: Re: [nvda] Editing Excel Cells
Following Quentin’s suggestion: I hit alt + f, up-arrowed to options, hit enter, arrowed down to advanced, tabbed to the check box for “directly editing cells “, unchecked that box, and hit OK. This solved my f2 Excel editing problem.
You should not have to concern yourself with maximizing Excel after this change.
From: firstname.lastname@example.org <email@example.com> On Behalf Of Cearbhall O'Meadhra
When I open an excel sheet in OFFice 2016, windows 10 and latest NVDA, NVDA speaks the cell results and so I missed the fact that the worksheet was stil minimised! In that state, when I press F2, NVDA says “blank”. In the case of a formula in the cell, control-shift-home gets “equals” and so it is evident that there is a problem. At this stage I maximise the screen and NVDA speaks the entire formula immediately.
From your question I examined my actions and realised that I should maximise the screen before doing anything else!
I am very pleased with the ease with which NVDA works with Excel and I am able to write macros and build formulas whenever I need them.
All the best,
m +353 (0)833323487 Ph: _353 (0)1-2864623 e: cearbhall.omeadhra@...
Thank you Quentin,
Unchecking the “edit cells directly” option in the advanced options allows f2 to work correctly.
I hadn't actually touched my Excel settings when this started. I just went in and the setting (in Advanced) was checked. When I unchecked it, when I press F2 now visually the caret moves to the function bar rather than editing directly in the cell, and NVDA is currently reading the text correctly while editing.
Cearbhall, I'm not exactly sure what you mean by minimised and maximised here? When you press F2, the Excel window doesn't change dramatically. If editing in cell as I was previously, the caret would appear in the current cell, and if needed the text would flow across to the right of the screen and then down to lower rows, if it didn't fit in the current cell. If editing in the function bar, the caret appears up there instead, but there is no other minimise or maximise aside from the entire Excel window (which was already maximised).
On Mon, Apr 23, 2018 at 8:35 AM, Cearbhall O'Meadhra <cearbhall.omeadhra@...> wrote: