ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel keyboard shortcuts (https://www.excelbanter.com/excel-programming/381709-excel-keyboard-shortcuts.html)

Santa-D

Excel keyboard shortcuts
 
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.


Excelibur[_6_]

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

Santa-D wrote:
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.



Santa-D

Excel keyboard shortcuts
 
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)


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



Santa-D

Excel keyboard shortcuts
 
What I'm trying to refer to is in this document, under the section -
selecting cells.
http://www.mentortraining.com/pdf/qu...XL2003QREF.pdf


NickHK

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

NickHK

"Santa-D" wrote in message
ups.com...
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.




Santa-D

Excel keyboard shortcuts
 
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.


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

NickHK

"Santa-D" wrote in message
ups.com...
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.



Santa-D

Excel keyboard shortcuts
 
Found the solution:

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


NickHK

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

NickHK

"Santa-D" wrote in message
oups.com...
Found the solution:

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





All times are GMT +1. The time now is 04:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com