Shirtcut for return to the

  • Thread starter Thread starter Dave Hawley
  • Start date Start date
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
 
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
 
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
 
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
 
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
 
Back
Top