Ask Your Question

Calc: shift f9 [closed]

asked 2019-10-06 20:39:36 +0100

Triggerhousinggroup gravatar image

Whilst trying to get my spreadsheet to recalculate (different issue), I was trying various modifications of F9.

(Again, different issue, but F9 and ctrl-shift-F9 didn't work)

I tried Shift-F9.

Here's what I got: image description ... and ... image description (Yeah, I liked it so much I did it again.)

But.... now I can't get rid of those handy markers telling me whence the calculation came.

Any ideas?

Shift-F9 appears to be undocumented .. at least in cheat sheets I've found.

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-10-09 18:41:55.077317

1 Answer

Sort by » oldest newest most voted

answered 2019-10-06 22:13:40 +0100

erAck gravatar image

Menu Tools -> Detective -> Remove All Traces; you did Trace Precedents.

edit flag offensive delete link more


Thanks! That was driving me crazy. I finally decided to try to take matters in my own hands and just remove the row. Unfortunately, that just moved the offending blue arrow thingie down a row, so did no good. Thanks for your solution. While in the menu, I see that Shift+F9 is Trace Precedents as you say. Shift+F5 is apparently Trace Dependents.

Would upvote, but draconian rules prevent me from upvoting here. Did mark it as "answer": apparently I'm allowed to do that, at least.

Triggerhousinggroup gravatar imageTriggerhousinggroup ( 2019-10-09 17:26:39 +0100 )edit

Marking the answer as correct if it solved the problem is the correct procedure. Thanks.

erAck gravatar imageerAck ( 2019-10-09 18:41:43 +0100 )edit

Question Tools

1 follower


Asked: 2019-10-06 20:39:36 +0100

Seen: 36 times

Last updated: Oct 06