Forum Discussion

Copper Contributor

Oct 21, 2022

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...

excel

Formulas and Functions

ChrisHa91

Microsoft

Oct 21, 2022

MarkSGA

Hello Mark,

I saw your feedback. But I'm not able to reproduce the issue -- at least not with the simple formulas I was trying. Can you please provide more detail on the conditions under which you see the colored reference markers not working? For example, are you using Freeze panes or sheet protection?

If you'd prefer, you can submit more feedback through Excel. If you include your email and screenshot this time with the feedback, I can respond directly to you.

Thanks,

Chris

Excel Engineering

Riny_van_Eekelen
Platinum Contributor
Oct 22, 2022
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

Media1.mp44 MB
- MarkSGA
  Copper Contributor
  Oct 25, 2022
  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