Excel irritation - has something changed?

Soldato
Joined
7 Dec 2012
Posts
17,650
Location
Gloucestershire
A minor issue, but it's been annoying me for a few weeks.

Taking a cell with a plain number in it, say '150'

If you want to then change it to a formula, to add a second figure, say 25, I would traditionally click on the cell, then click in front of the '150', type '=' and then press the down arrow, which takes me to the end of the formula (i.e. after the '150') where I would type '+25' and then the enter key

Sometime in the last ~month or two, the down-arrow bit of that has stopped working - pressing down-arrow doesn't move the cursor at all, where it used to (I think - I do it pretty automatically) take you to the end of the formula.

Anyone else experience this, and is there a way to bring that function back?

Edit:

Just remembered that the remote desktop I use for some stuff at work has an old version of excel (2007) and the up and down arrows work in formulas there - so it's my Excel 2016 that isn't doing it.
 
Last edited:
Just opened my Excel 2016 and it does as you want it to, pressing down takes me to the end.

Guessing it must be a setting somewhere then?
That makes sense since it only changed a month or two ago, and I've been running Excel 2016 for about a year (it's on a work pc).

I should check with colleagues - see if they get it too, or if it's just my PC.
 
As an update, this issue seems to have disappeared. Pressing down when the cursor is editing a formula now takes the cursor to the end.

A bit weird, but pleased it's working properly again.
 
Back
Top Bottom