Re: Editing Excel Cells
Louis Maher <ljmaher03@...>
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: email@example.com <firstname.lastname@example.org> On Behalf Of Cearbhall O'Meadhra
Sent: Monday, April 23, 2018 12:48 PM
Subject: Re: [nvda] Editing Excel Cells
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: