Excel Formula Blocking adjacent cels. Very Frustrating.

%3CLINGO-SUB%20id%3D%22lingo-sub-2814613%22%20slang%3D%22en-US%22%3EExcel%20Formula%20Blocking%20adjacent%20cels.%20Very%20Frustrating.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2814613%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20I've%20been%20using%20Excel%20since%20it%20was%20invented.%20I%20am%20far%20from%20an%20expert%20but%20I%20use%20basic%20formulas%20all%20the%20time.%20I%20am%20using%20Office%202016%20but%20only%20started%20using%20it%20a%20couple%20years%20ago%20when%20my%20CD%20Roms%20of%20an%20older%20version%20wouldn't%20work%20in%20Windows%2010.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20use%20the%20mouse%20whenever%20possible%20to%20create%20formulas%20but%20as%20you%20can%20see%20below%20the%20cels%20on%20either%20side%20of%20the%20formula%20are%20blocked%20out.%20If%20I%20want%20to%20use%20those%20cels%20as%20part%20of%20the%20formula%20I%20have%20to%20manually%20type%20them%20in.%20Before%20switching%20to%202016%20I%20never%20had%20a%20problem.%20I%20could%20use%20the%20mouse%20to%20make%20formulas%20in%20adjacent%20cels%20no%20problem.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22shipdriver_0-1633463155416.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F315386i8A57B4F71ECBB433%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22shipdriver_0-1633463155416.png%22%20alt%3D%22shipdriver_0-1633463155416.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2814613%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2814674%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Blocking%20adjacent%20cels.%20Very%20Frustrating.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2814674%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1175026%22%20target%3D%22_blank%22%3E%40shipdriver%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%20editing%20the%20formula%20in%20the%20formula%20bar%20instead%20of%20in%20the%20cell%20itself.%3C%2FP%3E%0A%3CP%3EIf%20you%20prefer%20editing%20in-cell.%20you%20can%20probably%20use%20the%20arrow%20keys%20to%20select%20a%20cell%20to%20the%20left%20or%20right%20of%20the%20cell%20with%20the%20formula.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2814780%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Blocking%20adjacent%20cels.%20Very%20Frustrating.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2814780%22%20slang%3D%22en-US%22%3EThanks%20for%20replying.%20I%20can%20get%20the%20formula%20done%20by%20typing%20in%20the%20cel%20or%20formula%20bar.%20and%20thats%20what%20I%20have%20been%20doing%20(under%20protest).%20My%20goal%20is%20to%20just%20use%20the%20mouse%20like%20I%20did%20for%20lotsa%20years%20until%20I%20had%20to%20upgrade%20to%20Office%202016.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20arrow%20idea%20sounds%20cool%20but%20I%20tried%20it%20and%20it%20highlighted%20a%20random%20cel%20a%20few%20rows%20up.%20I%20used%20the%20arrows%20on%20the%20number%20pad%20right%20side%20of%20keyboard%20plus%20I%20tried%20the%20arrows%20to%20left%20of%20keypad%2C%20same%20result.%20Was%20worth%20a%20try%20though.%3C%2FLINGO-BODY%3E
New Contributor

So I've been using Excel since it was invented. I am far from an expert but I use basic formulas all the time. I am using Office 2016 but only started using it a couple years ago when my CD Roms of an older version wouldn't work in Windows 10.

 

I use the mouse whenever possible to create formulas but as you can see below the cels on either side of the formula are blocked out. If I want to use those cels as part of the formula I have to manually type them in. Before switching to 2016 I never had a problem. I could use the mouse to make formulas in adjacent cels no problem. 

 

I'm hoping it is a setting. I've search for articles, looked through the options pages and I can't find a solution. Is there a solution I pray? What can I do to stop Excel Formula from blocking out adjacent cels?

 

 

 

shipdriver_0-1633463155416.png

 

 

 

3 Replies

@shipdriver 

Try editing the formula in the formula bar instead of in the cell itself.

If you prefer editing in-cell. you can probably use the arrow keys to select a cell to the left or right of the cell with the formula.

Thanks for replying. I can get the formula done by typing in the cel or formula bar. and thats what I have been doing (under protest). My goal is to just use the mouse like I did for lotsa years until I had to upgrade to Office 2016.

The arrow idea sounds cool but I tried it and it highlighted a random cel a few rows up. I used the arrows on the number pad right side of keyboard plus I tried the arrows to left of keypad, same result. Was worth a try though.

It's happening again, aaagggh. Here is another example. I need to use the mouse to highlight the figure in the cel covered up by "SUM(number1...etc). With Office Professional 2000 this was never a problem. Somehow MS decided it was an improvement to take that capability away from us. They figured it's an improvement to figure out what cel that it is, then type a bunch of formula stuff. 

 

I use alot of formulas this constantly frustrates me. It's not the most terrible thing to figure out what cel I need then go type a bunch of stuff. If I had never done it the easier way I wouldn't care. But to me it is just ludacris that an improvement (or at least a newer version) comes along and things become more difficult.

 

shipdriver_0-1633489425167.png