Ask Your Question

How to turn off visualization for ifsum() [closed]

asked 2019-08-12 19:34:36 +0200

FreeLunch gravatar image

I've somehow turned on some visualization for a cell with an '=ifsum(...)' function. Blue arrows span the columns covered by the =ifsum(), converging on the cell with the formula, and all cells in these columns have either a blue dot or a blue arrowhead.

Not sure how I turned this on, and would really like to turn it off. Visualization goes away when formula is delete, but returns on re-entering. Attempts to clear formatting on the cell have not helped.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2019-08-16 20:56:42.428500

1 Answer

Sort by » oldest newest most voted

answered 2019-08-13 17:02:36 +0200

erAck gravatar image

It's the Detective, turn off with menu Tools -> Detective -> Remove All Traces.

edit flag offensive delete link more


Right you are! Not sure how I got that turned on. Thanks so much.

FreeLunch gravatar imageFreeLunch ( 2019-08-14 19:01:30 +0200 )edit

Probably by hitting Shift+F9 or Shift+F5 at some point..

If the answer solves your problem then please mark it as correct by clicking the check mark icon, thanks.

erAck gravatar imageerAck ( 2019-08-16 17:22:47 +0200 )edit

Question Tools

1 follower


Asked: 2019-08-12 19:34:36 +0200

Seen: 14 times

Last updated: Aug 13