Selecting Cell "Above"

[burchick]

I am having issues selecting the cell "above" in formulas.
Example, I want to insert a formula into cell B10, which includes a value from cell B9. So, I select cell B10, click = , and then try to click on cell B9 to insert the value, but it will not allow me the select B9. I can click on any other cell and it works, just not the cell directly above the current cell. Does any one know how to fix this?

Thanks!

 

[KaibleBasha]

Hi,

Sorry if this isn't any help, but the sheet you're working on isn't protected in any way is it?

Kai

 

[burchick]

Not that I am aware of. I can click on any cell except the cell directly above the cell I am working in. I can put a formula into any cell, but every cell acts the same way.

 

[bewsh1987]

can you delete rows/columns?

 

[KaibleBasha]

okie doke,

I'm really not sure about that (have tried google myself)

Are you unable to single click into the cell (B10) then press = and just hit the up arrow?

e.g. = then up should result in =B9

Thanks
Kai

p.s I'm leaving work and going home so may not reply

 

[burchick]

Yes, I can delete rows/columns.

 

[burchick]

I guess the arrow up is one solution. It would be nice just to click on the cell.
I noticed that once I click on the cell containing the formula, the cell is only highlighted green on three sides (bottom & both sides, not the top). When I try to select the cell "above", instead of the "cross" mouse pointer, I get an I-Beam pointer. But once I point to another cell, the mouse pointer goes back to the "cross".

 

[burchick]

This seems to be a workbook setting, but I am not sure what. I tried a different workbook and it works normally.

 

[bewsh1987]

Its hard to see an issue when your working blind but lets try a few things

1st try this

go to file
then got to options
go to advanced
look through and you should see Allow editing directly in cells this should be ticked if you need to change the cells on the worksheet. If you only want to change from the formula bar then this should be un-ticked

if the above is ticked then try some of these
1. Close Excel's shell down and reopen IT's favourite
2. Check to see if the workbook is shared(some functions are disabled however not your issue)
3. check to see if you have any freeze panes( this should not affect selection but is worth a try)

I understand that the above has nothing to-do with your issue however it nice to check

Does your up key work on your keyboard? or is it just for that specific workbook
is there any VBA code in the background?

I am very intrigued to know what is causing this.

 

[burchick]

Allow editing directly in cells is ticked.
The up arrow works, but it would be nice to use my mouse to select the cell.
I don't think there is any VBA code.
Is there anyway to send you the excel file to play around with?
Thanks for your help!