Forum Discussion
MarkSGA
Oct 21, 2022Copper Contributor
Excel glitch when trying to amend a formula range
Hello, Crazy problem that has just started. Working on Excel (latest version 365 and Windows 10) : After a few minutes of working on a new or existing worksheet click on a cell containing a formu...
Riny_van_Eekelen
Oct 22, 2022Platinum Contributor
ChrisHa91 Hi Chris, thanks for the rapid feedback.
I've attached a 20 second screen recording demonstrating a simple sum formula. When I select B6 and F2 to go to formula bar, I see the blue outline around the cells referenced. Hover the cursor over the sides or corners and you'll see the different styles of arrows to move or resize the selection. As soon as you click the cursor loses its focus on the outlined range and selects a nearby cell. This started a few weeks ago, if I'm not mistaken.
I'm subscribing to MS365 Apps for business, running Version 2211 (15813.20002 C-t-r) Beta channel.
Riny
MarkSGA
Oct 25, 2022Copper Contributor
Hello Chris/Riny,
Thank you for your replies, Riny's video is exactly what my Excel has started to do. You just can adjust the selection of an existing range within a cell formula. Hope you can see the issue and suggest a solution.
Best Mark
Thank you for your replies, Riny's video is exactly what my Excel has started to do. You just can adjust the selection of an existing range within a cell formula. Hope you can see the issue and suggest a solution.
Best Mark