Excel keyboard shortcuts

S

Santa-D

Why is it in excel 2003 I can no longer press CTRL+SHIFT+ARROW Keys
when trying to select a row or selection when entering the details in
sum equations.
 
E

Excelibur

Because you pressed F2. And selecting a row is faster with
Shift+Space, selecting a column with Ctrl+Space.
 
S

Santa-D

Nope, that's incorrect.
I can do it on a different machine.
in any cell type =SUM(then press CTRL+SHIFT+UP) and it'll highlight the
the relevant range.
When I do it on my machine, I press =SUM(then press CTRL+SHIFT+UP) and
it enters the formula: =SUM(A8)
 
N

NickHK

For me, in XL2000 & 2002, those combination work on the worksheet, but not
from the formula bar.

NickHK
 
S

Santa-D

Yeah I know, and it's the worksheet that won't let me do it.
It's sending me insane, I'm so used to it.
 
S

Santa-D

Found the solution:

I removed an addin - namemanager.xla and after that everything went
back to normal.
 
N

NickHK

Maybe you could inform the author of that add-in of this problem, assuming
you are sure it is the cause.

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top