Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Rapidly Approaching Meltdown


Please help! This is driving me nuts!

For some reason that I have not been able to identify, when I try to
select a range of adjacent cells using the Ctrl+Shft+Arrow Key
combination in the Formula Bar, rather than select the range of cells I
would like the formula to operate on, only the first cell in the range
is selected!.

Example worksheet range:

Col B
Row 1 10
Row 2 10
Row 3 10
Row 4 10
Row 5 =SUM(

1. I enter =SUM( in cell B5
2. I select the last cell in the range I want to sum by hitting the up
arrow - B4
3. I hit Ctrl+Shift+Up Arrow+Enter - Until today, this resulted in
=SUM(B1:B4) in cell B5.
4. For some extremely infuriating reason, the resulting formula in Cell
B5 = SUM(B4)!!!!!!!!!!!!!!!!!!!!

This happens in all workbooks even when I restart Excel!

Somebody please please tell me why this happens and how I can fix it!

Thanks - Walker


--
walker.oliver
------------------------------------------------------------------------
walker.oliver's Profile: http://www.excelforum.com/member.php...o&userid=37918
View this thread: http://www.excelforum.com/showthread...hreadid=574442

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Rapidly Approaching Meltdown

Just hazarding some guesses .. Maybe it's just the good old keyboard, crying
out to be retired from service <g? From the sounds of it, you're a "key"
person. I'm more a "mouser", and I've worn out countless mice over the years.
Try with another/new keyboard.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"walker.oliver" wrote:

Please help! This is driving me nuts!

For some reason that I have not been able to identify, when I try to
select a range of adjacent cells using the Ctrl+Shft+Arrow Key
combination in the Formula Bar, rather than select the range of cells I
would like the formula to operate on, only the first cell in the range
is selected!.

Example worksheet range:

Col B
Row 1 10
Row 2 10
Row 3 10
Row 4 10
Row 5 =SUM(

1. I enter =SUM( in cell B5
2. I select the last cell in the range I want to sum by hitting the up
arrow - B4
3. I hit Ctrl+Shift+Up Arrow+Enter - Until today, this resulted in
=SUM(B1:B4) in cell B5.
4. For some extremely infuriating reason, the resulting formula in Cell
B5 = SUM(B4)!!!!!!!!!!!!!!!!!!!!

This happens in all workbooks even when I restart Excel!

Somebody please please tell me why this happens and how I can fix it!

Thanks - Walker


--
walker.oliver
------------------------------------------------------------------------
walker.oliver's Profile: http://www.excelforum.com/member.php...o&userid=37918
View this thread: http://www.excelforum.com/showthread...hreadid=574442


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 111
Default Rapidly Approaching Meltdown

One thing you might want to check is whether transition navigation keys got
turned on. I just checked first with out it turned on and result was as you
stated. Then I went to Tools-Options-Navigation and turned on Transition
Navigation keys and result was as you stated. BTW, I usually use
End-direction (as I started with Lotus 123 and that was the key combination
there) and this works both with transtion navigation keys turned on or off.
HTH
--
Kevin Vaughn


"walker.oliver" wrote:


Please help! This is driving me nuts!

For some reason that I have not been able to identify, when I try to
select a range of adjacent cells using the Ctrl+Shft+Arrow Key
combination in the Formula Bar, rather than select the range of cells I
would like the formula to operate on, only the first cell in the range
is selected!.

Example worksheet range:

Col B
Row 1 10
Row 2 10
Row 3 10
Row 4 10
Row 5 =SUM(

1. I enter =SUM( in cell B5
2. I select the last cell in the range I want to sum by hitting the up
arrow - B4
3. I hit Ctrl+Shift+Up Arrow+Enter - Until today, this resulted in
=SUM(B1:B4) in cell B5.
4. For some extremely infuriating reason, the resulting formula in Cell
B5 = SUM(B4)!!!!!!!!!!!!!!!!!!!!

This happens in all workbooks even when I restart Excel!

Somebody please please tell me why this happens and how I can fix it!

Thanks - Walker


--
walker.oliver
------------------------------------------------------------------------
walker.oliver's Profile: http://www.excelforum.com/member.php...o&userid=37918
View this thread: http://www.excelforum.com/showthread...hreadid=574442


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 sheet meltdown help! Philden Excel Discussion (Misc queries) 3 July 7th 05 06:35 PM


All times are GMT +1. The time now is 03:11 PM.

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

About Us

"It's about Microsoft Excel"