moderated How do I edit in a cell in Excel 2016


Sieghard Weitzel <sieghard@...>
 

Same here

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Richard Turner
Sent: Monday, April 26, 2021 5:04 PM
To: main@jfw.groups.io
Subject: Re: How do I edit in a cell in Excel 2016

Interesting.
Mine is checked and f2 works absolutely perfectly.
I use it all the time.
Jaws 2021 April update, Microsoft Excel Subscription Version 16.0.13901.20400 from Office 365, Windows 10 Home 64 bit.



Richard
"The highest reward for a person's toil is not what they get for it, but what they become by it."
- John Ruskin, 1819-1900

Web site: www.turner42.com



-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne
Sent: Monday, April 26, 2021 5:01 PM
To: main@jfw.groups.io
Subject: Re: How do I edit in a cell in Excel 2016

this actually wants to be *unchecked! It has to do with something visual, editing in the formula bar maybe. Absolutely *uncheck it.
At 04:59 PM 4/26/2021, you wrote:

Press alt+f then t for options,

Then a to advanced, tab to the checkbox:

Allow editing directly in cells check box

And make sure it is checked.



Richard

"The highest reward for a person's toil is not what they get for it,
but what they become by it."

- John Ruskin, 1819-1900



Web site:
<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.tu
rner42.com%2F&amp;data=04%7C01%7C%7C225aa81708ff4d9a842b08d9090f97e0%7C
84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637550784832398874%7CUnknown
%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJX
VCI6Mn0%3D%7C1000&amp;sdata=VckRTD3fHVfjAiEoSEWC9sFw%2BV%2BNmx7OC%2FOsi
uelLbU%3D&amp;reserved=0>https://na01.safelinks.protection.outlook.com/
?url=http%3A%2F%2Fwww.turner42.com%2F&amp;data=04%7C01%7C%7C225aa81708f
f4d9a842b08d9090f97e0%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C6375
50784832398874%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2lu
MzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=VckRTD3fHVfjAiEoSEW
C9sFw%2BV%2BNmx7OC%2FOsiuelLbU%3D&amp;reserved=0







From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Marty
Hutchings
Sent: Monday, April 26, 2021 2:51 PM
To: main@jfw.groups.io
Subject: How do I edit in a cell in Excel 2016



I'm using Windows 10, JAWS 2021, and MS Office Excel 2016. I used to
be able to press F2 in any cell to edit in that cell in Office
2007 Excel, but I can no longer do that. I know that it is a matter of
unchecking a check box, but where is it?


 

On Mon, Apr 26, 2021 at 08:03 PM, Richard Turner wrote:
Mine is checked and f2 works absolutely perfectly.
-
My guess is that one group of us is talking right past the other because we're coming at "what's being edited" from opposite sides.

I had presumed that it was the formula that what was wanted to be edited directly in the cell, and in that case the checkbox for Allow editing directly in cell should be checked.

Values in non-computed cells are directly editable after hitting F2 when focus is on those cells with the above noted checkbox checked.  The cursor is put to the rightmost side of the cell and you can backspace out the content one character at a time.

If I have that checkbox UNchecked, if I try to edit a cell by hitting F2, focus is thrown to the formula box and the editing takes place there. And that's whether the cell content is an actual formula or is text, a number with no formula, etc.  Any and all editing takes place in the formula box.

The default is that the checkbox is checked.
--

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

It is better to be hated for what you are than to be loved for what you are not.

           ~ André Gide


Richard Turner <richardturner42@...>
 

Interesting.
Mine is checked and f2 works absolutely perfectly.
I use it all the time.
Jaws 2021 April update, Microsoft Excel Subscription Version 16.0.13901.20400 from Office 365, Windows 10 Home 64 bit.



Richard
"The highest reward for a person's toil is not what they get for it, but what they become by it."
- John Ruskin, 1819-1900

Web site: www.turner42.com

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne
Sent: Monday, April 26, 2021 5:01 PM
To: main@jfw.groups.io
Subject: Re: How do I edit in a cell in Excel 2016

this actually wants to be *unchecked! It has to do with something visual, editing in the formula bar maybe. Absolutely *uncheck it.
At 04:59 PM 4/26/2021, you wrote:

Press alt+f then t for options,

Then a to advanced, tab to the checkbox:

Allow editing directly in cells check box

And make sure it is checked.



Richard

"The highest reward for a person's toil is not what they get for it,
but what they become by it."

- John Ruskin, 1819-1900



Web site:
<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.tu
rner42.com%2F&amp;data=04%7C01%7C%7C225aa81708ff4d9a842b08d9090f97e0%7C
84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637550784832398874%7CUnknown
%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJX
VCI6Mn0%3D%7C1000&amp;sdata=VckRTD3fHVfjAiEoSEWC9sFw%2BV%2BNmx7OC%2FOsi
uelLbU%3D&amp;reserved=0>https://na01.safelinks.protection.outlook.com/
?url=http%3A%2F%2Fwww.turner42.com%2F&amp;data=04%7C01%7C%7C225aa81708f
f4d9a842b08d9090f97e0%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C6375
50784832398874%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2lu
MzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=VckRTD3fHVfjAiEoSEW
C9sFw%2BV%2BNmx7OC%2FOsiuelLbU%3D&amp;reserved=0







From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Marty
Hutchings
Sent: Monday, April 26, 2021 2:51 PM
To: main@jfw.groups.io
Subject: How do I edit in a cell in Excel 2016



I'm using Windows 10, JAWS 2021, and MS Office Excel 2016. I used to
be able to press F2 in any cell to edit in that cell in Office
2007 Excel, but I can no longer do that. I know that it is a matter of
unchecking a check box, but where is it?


Ann Byrne
 

this actually wants to be *unchecked! It has to do with something visual, editing in the formula bar maybe. Absolutely *uncheck it.

At 04:59 PM 4/26/2021, you wrote:

Press alt+f then t for options,

Then a to advanced, tab to the checkbox:

Allow editing directly in cells check box

And make sure it is checked.



Richard

"The highest reward for a person's toil is not what they get for it, but what they become by it."

- John Ruskin, 1819-1900



Web site: <http://www.turner42.com>www.turner42.com







From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Marty Hutchings
Sent: Monday, April 26, 2021 2:51 PM
To: main@jfw.groups.io
Subject: How do I edit in a cell in Excel 2016



I'm using Windows 10, JAWS 2021, and MS Office Excel 2016. I used to be able to press F2 in any cell to edit in that cell in Office 2007 Excel, but I can no longer do that. I know that it is a matter of unchecking a check box, but where is it?


Alan Robbins <arobbins1057@...>
 

Marty,

 

Here are the steps I did a couple of years ago to fix the problem, hopefully they still work.

1. Have Excel open.

2. Press “alt+f” to open the file menu then press “t” for the options.

3. Press “control+tab” until the focus is on the “Advanced” options page.

4. Press “alt+e” to toggle the “Allow editing directly in cells”

option. Ensure that this is unchecked.

5. Press “enter” to save the changes. Editing cell contents should now work again.

 

 

Alan

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Marty Hutchings
Sent: Monday, April 26, 2021 5:51 PM
To: main@jfw.groups.io
Subject: How do I edit in a cell in Excel 2016

 

I'm using Windows 10, JAWS 2021, and MS Office Excel 2016.  I used to be able to press F2 in any cell to edit in that cell in Office 2007 Excel, but I can no longer do that.  I know that it is a matter of unchecking a check box, but where is it?


 

FYI, the "Tell me what you want to do" help search in Excel is really helpful for this sort of thing.  I searched on "edit cell contents" and ran into this in the help.  You are trying to enable [check] the Allow editing directly in cells checkbox:

  1. Click File > Options > Advanced.

    -OR-

    In Excel 2007 only: Click the Microsoft Office Button Office button image , click Excel Options, and then click the Advanced category.

  2. Under Editing options, do one of the following:

    • To enable Edit mode, select the Allow editing directly in cells check box.

    • To disable Edit mode, clear the Allow editing directly in cells check box.

Enter Edit mode

To start working in Edit mode, do one of the following:

  • Double-click the cell that contains the data that you want to edit.

    This starts Edit mode and positions the cursor in the cell in the location that you double-clicked. The cell contents are also displayed in the formula bar.

  • Click the cell that contains the data that you want to edit, and then click anywhere in the formula bar.

    This starts Edit mode and positions the cursor in the formula bar at the location that you clicked.

  • Click the cell that contains the data that you want to edit, and then press F2.

    This starts Edit mode and positions the cursor at the end of the cell contents.

--

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

It is better to be hated for what you are than to be loved for what you are not.

           ~ André Gide


Richard Turner <richardturner42@...>
 

Press alt+f then t for options,

Then a to advanced, tab to the checkbox:

Allow editing directly in cells check box

And make sure it is checked.

 

Richard

"The highest reward for a person's toil is not what they get for it, but what they become by it."

- John Ruskin, 1819-1900

 

Web site: www.turner42.com

 

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Marty Hutchings
Sent: Monday, April 26, 2021 2:51 PM
To: main@jfw.groups.io
Subject: How do I edit in a cell in Excel 2016

 

I'm using Windows 10, JAWS 2021, and MS Office Excel 2016.  I used to be able to press F2 in any cell to edit in that cell in Office 2007 Excel, but I can no longer do that.  I know that it is a matter of unchecking a check box, but where is it?


Marty Hutchings
 

I'm using Windows 10, JAWS 2021, and MS Office Excel 2016.  I used to be able to press F2 in any cell to edit in that cell in Office 2007 Excel, but I can no longer do that.  I know that it is a matter of unchecking a check box, but where is it?