How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
John D, Bachelor of Science - Engineering Consultant
Category: Programming
Satisfied Customers: 9654
Experience:  Vast experience in Excel programming and business solutions
Type Your Programming Question Here...
John D is online now
A new question is answered every 9 seconds

CTRL+ Home and CTRL+End do not take me to the beginning and

Customer Question

CTRL+ Home and CTRL+End do not take me to the beginning and end of the spreadsheet. How can I reset or edit them?
Submitted: 5 years ago.
Category: Programming
Expert:  John D replied 5 years ago.

Hi,

 

In Excel Ctrl + Home should take you to cell A1, but Ctrl + End takes you to the last cell that has data. You can also use Ctrl + Up or Down Arrows to skip blank cells.

 

Hope this helps. If you are experiencing something else let me know.

 

 

 

Customer: replied 5 years ago.
CTRL+Home takes me to column A of the current row and CTRL+End takes me to the last cell of this row. These shortcut were changed from the original configuration some how
Expert:  John D replied 5 years ago.

Ok, can you try this and let me know what happens.

 

Close all Excel sheets and Excel applications, then launch Excel from the Start > All Programs so that it will open a new workbook.

 

Type some text in cell D15, then

 

place the cursor in cell B10, and press

Ctrl + End .... where does the cursor go?

 

Next place cursor in cell B10 again and press

Ctrl + Home .... where does the cursor go?

 

Let me know.

 

Customer: replied 5 years ago.
It took me to D10 the it took then it to A10. It seems it is working on the current row as if it is the whole worksheet.
Expert:  John D replied 5 years ago.

Ok, the key combinations are working fine, which confirms that the issue is not with your Excel settings nor is there anything wrong in your system. The problem is most likely in the data of that file, which can happen when some data is deleted from the user range but excel does not properly reset the new range. I can try to fix the file for you if you do not mind sending it, or I can prepare step by step instructions if you like.

 

Let me know.

 

Customer: replied 5 years ago.
But that was in a new spreadsheet that did not have any data in it to start with.
Expert:  John D replied 5 years ago.

But I thought you said that the result of the previous test (which was on a new workbook) showed that the keys are working as expected. So where is the problem then?

 

 

Customer: replied 5 years ago.
The problem is that when you hit CTRL+HOme it takes you to coulumn A cell of the current row. When you hit CTRL+End it takes you the last cell of the current row.

CTRL+Home should take me to cell A1 which does not happen regardless of whether you are working in a fresh workbook or an existing one. When I used your test it took me to cell A10.
Expert:  John D replied 5 years ago.

I see.

 

The only explanation I can think of is that it is caused by an installed add-in or an auto macro that automatically executes when you launch excel or open any workbook (via either an Auto_Open procedure or the workbook's Workbook_Open event procedure). To bypass any add-ins or auto macro try starting excel in safe mode so that Excel does not open add-ins or other startup files. To run Excel in Safe Mode, go to the Windows Start menu, choose Run, and type the following line, then click OK.

Excel.exe /safe


(note:there is a space before the slash)

 

If in safe mode the keys act as they are supposed to then you will need to remove any suspicious add-n and disable the auto_open macro that may be running.

 

Finally, just to confirm what we have already discussed about how these keys are supposed to behave here is a clearly presented explanation.:

 

http://gaetc-ejournal.org/tutorials/excel/teachexcel/navigation/navigation-control.htm

 

Hope this helps.

Expert:  John D replied 5 years ago.

I see.

 

The only explanation I can think of is that it is caused by an installed add-in or an auto macro that automatically executes when you launch excel or open any workbook (via either an Auto_Open procedure or the workbook's Workbook_Open event procedure). To bypass any add-ins or auto macro try starting excel in safe mode so that Excel does not open add-ins or other startup files. To run Excel in Safe Mode, go to the Windows Start menu, choose Run, and type the following line, then click OK.

Excel.exe /safe


(note:there is a space before the slash)

 

If in safe mode the keys act as they are supposed to then you will need to remove any suspicious add-n and disable the auto_open macro that may be running.

 

Finally, just to confirm what we have already discussed about how these keys are supposed to behave here is a clearly presented explanation.:

 

http://gaetc-ejournal.org/tutorials/excel/teachexcel/navigation/navigation-control.htm

 

Hope this helps.

Customer: replied 5 years ago.
Thank you very much. The problem was caused by the Transition Navigation Keys checkbox checked under the Transition Tab under Options under Tools.
Expert:  John D replied 5 years ago.

Wow! Why would anyone want to switch to the alternative navigation keys in the first place!

 

Anyway, thanks for the update.

 

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • ATLPROG

    Computer Software Engineer

    Satisfied Customers:

    7463
    MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
< Last | Next >
  • http://ww2.justanswer.com/uploads/SP/spatlanta2010/2011-6-23_12450_photo.64x64.gif ATLPROG's Avatar

    ATLPROG

    Computer Software Engineer

    Satisfied Customers:

    7463
    MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
  • http://ww2.justanswer.com/uploads/ComputersGuru/2010-02-13_051118_Photo41.JPG LogicPro's Avatar

    LogicPro

    Computer Software Engineer

    Satisfied Customers:

    5603
    Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.
  • http://ww2.justanswer.com/uploads/unvadim/2010-11-15_210218_avatar.jpg unvadim's Avatar

    unvadim

    Computer Software Engineer

    Satisfied Customers:

    1158
    Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.
  • http://ww2.justanswer.com/uploads/lifesaver333/2010-10-17_191349_ls.jpeg lifesaver's Avatar

    lifesaver

    Computer Software Engineer

    Satisfied Customers:

    950
    Several years of intensive programming and application development experience in various platforms.
  • http://ww2.justanswer.com/uploads/EH/ehabtutor/2012-8-2_202016_1.64x64.jpg ehabtutor's Avatar

    ehabtutor

    Computer Software Engineer

    Satisfied Customers:

    864
    Bachelor of computer science, 5+ years experience in software development, software company owner
  • http://ww2.justanswer.com/uploads/RA/rajivsharma086/2012-6-6_17128_displaypic.64x64.jpg Raj's Avatar

    Raj

    Computer Engg.

    Satisfied Customers:

    860
    BE CS, 4+ Experience in Programming and Database (ERP)
  • http://ww2.justanswer.com/uploads/eljonis/2010-01-06_130406_eljon2.jpg Eljon's Avatar

    Eljon

    Consultant

    Satisfied Customers:

    590
    11 yrs of programming (PHP, WordPress, XSL, SQL, JavaScript)