Problem:
When pressing CTRL + Home in Excel it opens a new sheet but doesn’t go back to cell A1.
Challenge:
The user logged a call with us as she couldn’t press the CTRL + Home key any more to return to cell A1 in Excel. This was very strange. It would just open a new sheet.
Solution:
After extensive research on a well- known search engine we still struggled with this one. We tried new workbooks to rule out an actual spreadsheet issue but this didn’t resolve it, so I passed it over to my colleague as I was out of ideas. Then it hit me, she was using a laptop and the home key is on F11 on hers. I then asked her to try and hold the Fn key along with the control key before pressing the Home button. This worked but I was unsure how this had changed. I told my colleague and he said that she just had to press the Fn key + ESC and this then toggled the Fn key permanently as it was before.
Result:
Now the problem was resolved she could press CTRL + Home and it would go to cell A1 in Excel.
Lesson:
Look for the simpler solutions before blaming the software.
Action:
To find out more email Martin at martin@octagontech.com or call our office on 01522 797520.