Formula movement (CTRL+TAB)

Giganews Newsgroups
Subject: Formula movement (CTRL+TAB)
Posted by:  maxwell (anonymo…@discussions.microsoft.com)
Date: Wed, 29 Oct 2003

Hello,

I need help doing the following:
When i write a formula in a cell that references another
workbook, I type "CTRL+TAB" to leaf through the workbooks
that are open rather than using th mouse.  My issue is
that when in formula mode, I can leaf thru workbooks going
forward, but not backwards.  Backwards
is "CTRL+SHIFT+TAB"....but it don't work.

I did it before but I think it has something to do with
changing something in excel to let me leaf thru
spreadsheets backwards.  I need to this cuz i have over 10-
15 workbooks open and lots of my cells link to multiple
workbooks.

HELP?

Any ideas?

Replies