Shirtcut for return to the

[Dave Hawley]

Hi John

Get ready to kick yourself )

It's Ctrl+] to get back.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Kieran]

Ctrl + ] worked for me in Excel 97Sr2

 

[David McRitchie]

Hi John,

CTRL+[ (opening bracket)
Select only cells that are directly referred to by formulas in the selection
CTRL+SHIFT+{ (opening brace)
Select all cells that are directly or indirectly referred to by formulas in the selection
CTRL+] (closing bracket)
Select only cells with formulas that refer directly to the active cell
CTRL+SHIFT+} (closing brace)
Select all cells with formulas that refer directly or indirectly to the active cell

see shortcuts from Excel help on one web page.
http://www.mvps.org/dmcritchie/excel/shortx2k.htm

 

[John Wirt]

The shortcut for moving the selection from a cell that is linked directly to
another cell (or cells) to that cell is Ctrl + [ (i.e., ctrl and "[" ).

Then, what is the shortcut for moving the selection back to the original
cell?

Thanks.

John Wirt

 

[RagDyeR]

How about plain, simple <Home> ?

That is, if you're on the same sheet.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

The shortcut for moving the selection from a cell that is linked directly to
another cell (or cells) to that cell is Ctrl + [ (i.e., ctrl and "[" ).

Then, what is the shortcut for moving the selection back to the original
cell?

Thanks.

John Wirt

 

[RagDyeR]

Scratch that -
really doesn't work
bad testing
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

How about plain, simple <Home> ?

That is, if you're on the same sheet.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

The shortcut for moving the selection from a cell that is linked directly to
another cell (or cells) to that cell is Ctrl + [ (i.e., ctrl and "[" ).

Then, what is the shortcut for moving the selection back to the original
cell?

Thanks.

John Wirt

 

[David McRitchie]

Selection is misleading -- talking about trace dependents/precedents

Toolbar icons are also available
Tools, customize, commands, tools, ...
Trace Precedents
Remove Precedent Arrows
Trace Dependents
Remove Dependent Arrows
Remove all Arrows

Keyboard Shortcuts can be seen in
http://www.mvps.org/dmcritchie/excel/shortx2k.htm