CTRL+TAB!!!!!!

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

Maxwell

I know I can jump between workbooks by using 'CTRL+TAB' to
go FORWARD. Well if I want to go bacwards it will be
CTRL+SHIFT+TAB.

The Problemo...

While im in a writing function mode (In the middle of
writing a formula) I can jump to the next workbook "UP" to
reference something for a vlookup but not "Back" to
another....why? Please note that I can have up to 20
workbooks open at one time for the purpose of linking thus
if i need to reference the 19th workbook i need to
CTRL+TAB 19 time to get there rather than do a
CTRL+SHIFT+TAB 2 times. Is it somethint in my options
that I need to adjust?

Hope this is clear as mud.

Help
 
Intruder9

CRTL + PAGEUP and PAGEDOWN is used to navigate to worksheets in one workbook.

CRT + TAB is used to navigate to open workbooks.

Gord Dibben XL2002
 
Gord,

While editing inside a function in a formula, Ctrl-Tab takes you forward
through the workbooks where you can select cells for cell references in the
function. But Ctrl-Shift-Tab seems to end the process, as if you'd pressed
Enter. THEN it selects one workbook back. Not only that, it sets up the
formula as an array formula! (Unless there's an error). I guess the
Ctrl-Shift did that. Excel 2002 or 97.
 
Thanks Earl

I was not responding to OP but to Intruder9 who suggested CRTL + PAGEUP and
PAGEDOWN as a method of navigation, which did not fit this particular
scenario.

Was aware of the CRTL + TAB function and the apparent mis-functioning CRTL +
SHIFT + TAB while entering a formula.

Gord
 
Back
Top