Oct 05 2021 12:46 PM - edited Oct 05 2021 12:48 PM
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?
Oct 05 2021 01:08 PM
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.
Oct 05 2021 01:31 PM
Oct 05 2021 08:10 PM - edited Oct 05 2021 08:12 PM
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.
Feb 16 2023 04:52 AM
Feb 16 2023 09:45 AM
Feb 19 2023 09:24 AM
@shipdriver1540 - i know exactly what you mean, and how frustrating it is. Spreadsheets and formulas can be simple, but this results in increased time to enter. i usually select and adjacent cell and then correct the formula once it is entered