Excel Arrow Key is Creating a Formula

0 votes
I've never encountered a problem like the one I'm encountering with Excel 2010. When I use the arrow key to move to the next cell, it tries to add the following cell instead of advancing to the next cell.

Example: If I press the right arrow key from Cell A1, instead of moving to Cell A2, Cell A1 displays "+A2." Has this ever happened to anyone else?

Because it occurs regardless of which spreadsheet I am in, I believe it to be some strange setting that may be enabled or disabled. Thanks in advance for your assistance.

Regarding the spreadsheet scrolling when you use the arrow keys, this is NOT the issue. I've already done it and been there.
Oct 23, 2022 in Others by Kithuzzz
• 38,010 points
437 views

1 answer to this question.

0 votes
Your scroll lock is on. This is a bug in Excel that surfaces sometimes -, particularly in the 64-bit office.
answered Oct 23, 2022 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
0 answers

What is the formula to keep first two words in a cell over excel?

I want to maintain the first two ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
• 38,010 points
194 views
0 votes
1 answer
0 votes
1 answer

Is there a way to test a formula result in excel and type it only once, all within one cell and not using a user defined function?

Use the Let function: =LET(Value,A1+B2+C4+G3+B4,IF(Value>10,"No",Value)) I hope this helps ...READ MORE

answered Jan 9, 2023 in Others by narikkadan
• 63,420 points
340 views
0 votes
1 answer
0 votes
1 answer

Word Mail Merge with Excel data has to be saved in different files with custom names

Try this: Public Sub Mail_Merge() On Error GoTo ErrH Dim ...READ MORE

answered Nov 6, 2022 in Others by narikkadan
• 63,420 points
1,275 views
0 votes
1 answer

In =RTD(ProgID,Server,String1,[String2],...), passing array for String2, String3 and so on

Since WorksheetFunction.RTD() method (https://learn.microsoft.com/en-us/office/vba/api/excel.worksheetfunction.rtd) signature (i.e.: how many parameters it is ...READ MORE

answered Jan 23, 2023 in Others by narikkadan
• 63,420 points
193 views
0 votes
1 answer

Highlight duplicates with only 2 colors

Try this: Sub ColorCompanyDuplicates2() 'best practice to define all ...READ MORE

answered Mar 27, 2023 in Others by narikkadan
• 63,420 points
200 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
829 views
0 votes
1 answer

Is there a maximum number of formula fields allowed in Excel (2010)

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE

answered Sep 30, 2022 in Others by narikkadan
• 63,420 points
366 views
0 votes
1 answer

Is there a way to hide excel formula using Apache POI

In Excel, hiding formulae is a feature ...READ MORE

answered Oct 11, 2022 in Others by narikkadan
• 63,420 points
668 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP