I'm hoping there is a setting somewhere to fix this, because this is driving me nuts and slowing me down considerably.
Whenever I have columns hidden or grouped and I'm inserting a formula, as soon as I hit "+" or "-" or whatever to add two cells let's say, it opens up the grouping or hidden windows and if I click on a cell near that grouping will tend to select a group of cells and I have to then reclick on the exact cell I want to use in the formula.
If I'm working say with a formula that say adds several cells in a different worksheet, it keeps flipping back to the worksheet I am inserting the formula in everytime I hit a "+", "*", "-" or whatever so I constantly have to hit alt-tab to get back to the other sheet I'm linking to.
Hopefully I'm explaining this correctly. Because it's driving me nuts and if there isn't a fix for this, I'm utterly shocked that they would change this!
Another issue. When using a Sum formula and summing several rows of data let's say, I used to be able to click on the first cell, then hit CTRL and an arrow key which would include all the cells in that range (up, down, whatever) until it hit a break. That functionality seems to be gone as well with 2007!
Been working with this for weeks now, and am finally frustrated and tempted to go back to 2003 if I can't get a resolution!!
Thanks!!
Bookmarks