Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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.


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default 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.


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default 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

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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.





  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default 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.


  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default Excel keyboard shortcuts

Found the solution:

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

  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Keyboard Shortcuts Workbook Wondering[_2_] New Users to Excel 2 December 14th 07 08:55 PM
Excel keyboard shortcuts PLEASE JERRY Excel Discussion (Misc queries) 1 May 24th 07 12:07 AM
85 Keyboard Shortcuts for Excel Doug Kanter Excel Discussion (Misc queries) 1 April 28th 06 02:35 PM
Keyboard shortcuts for time in Pocket Excel Andrew Excel Worksheet Functions 1 October 7th 05 03:54 PM
Are there keyboard shortcuts for moving between sheets in Excel? Shayne Excel Discussion (Misc queries) 2 May 26th 05 07:27 AM


All times are GMT +1. The time now is 08:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"