Formula movement (CTRL+TAB)

  • Thread starter Thread starter Maxwell
  • Start date Start date
M

Maxwell

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?
 
Maxwell,

CONTROL+SHIFT+TAB works for me - I hold down Control and Shift and then just
press TAB every time I want to move backwards between workbooks. What
version of Excel are you running?

Katherine
 
Back
Top