Ask Your Question
0

Trace dependents/precedents when in another sheet [closed]

asked 2012-02-22 11:39:26 +0200

Gon gravatar image

updated 2014-03-19 22:31:49 +0200

manj_k gravatar image

When precedents are in another sheet or file, the symbol we get shows a square and the cursor does not change over it, so there is no way to trace the cell.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by qubit
close date 2013-03-10 10:00:28.500348

Comments

Hi @Gon, did @mikebibo answer your question? If so, please mark his answer as correct. Thanks!

qubit gravatar imagequbit ( 2013-01-20 00:32:42 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2012-04-29 16:27:18 +0200

mikebibo gravatar image

Actually, an old Excel keyboard shortcut seems to work to trace a precedent on another worksheet: Ctrl+[ (Control + left square bracket). This works on Linux and Windows, but I haven't been able to find a mac-equivalent - Command+[ does not work.

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-02-22 11:39:26 +0200

Seen: 1,739 times

Last updated: Apr 29 '12