Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

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 - 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 formuala 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!

For me it works as you want it to.

You might check tools/Options/transition and see if transition navigation keys

is turned on.

Didn't find what you were looking for?
Find more on Ctrl+Shift+Arrow Fails To Select Cells When Used in Formula Bar
Or get search suggestion and latest updates.

Related Topics:

- Copy Value produced by formula in cell C3 to cell D3
- Using an array formula as a hyperlink cell reference
- clearing cells value without deleting the formula I've made in cell from excel formula , HOW?
- VBA code to add values in two cells which have formulas
- cells containing formula that refer to user-defined VBA function
- Blank Formula bar
- formula returns to multiple cells, without Array object?
- Copying current cell's value to another cell
- Selecting Cells
- Select last n cells of a column
- select cells based on 3 criteria and delete rows
- Help with Selecting a Cell on a different Sheet
- selecting non adjacent cells
- VBA TO SELECT ALL EMPTY CELL IN SUDOKU3*3
- unselect all selected cells?
- Sort where a selected cell is preserved
- Select random cell in list and highlight contents
- update cell based on hyperlink selected
- Formula using range name in VBA code
- how are cell coordinates referenced on a clicked cell
- to see if text in a cell in a column is contained in any cell
- Moving data in the last cell of row to another column cell
- Action taken by Excel when a condition causes a cell's value
- Function needed to split the content of a cell intomany cells
- Function needed to split the content of a cell into many cells