Excel irritation - has something changed?

cheesyboy · 6 Jun 2018 at 10:04

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.

Martynt74 · 6 Jun 2018 at 10:23

Can't comment for sure about Excel 2016 but i've just tried that and it works as you describe in Excel 365.

Could try re-training yourself to use the "End" key?

UnworthyBean · 6 Jun 2018 at 11:55

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?

cheesyboy · 6 Jun 2018 at 16:17

UnworthyBean said:
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.

cheesyboy · 4 Jul 2018 at 16:06

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.