Forum Discussion
Solved
Turning off an Excel feature accidentally activated
I accidentally activated an Excel feature which causes the following result: When I move my cursor from the activated cell to another location on the page, the feature creates a large grey square the...
I think the process for selecting a range is
1. Select the top/left cell
2. Click F8
3. Click on the bottom/right cell to select the range
4. Press Enter to commit the formula and clear the toggle setting
Note: multiple range arguments can be inserted within a function because moving to the next parameter using "," will also clear the toggle.
I tend to get that when I am using the VBA editor and hit F8 to evaluate the next VBA step. If the focus is on the worksheet rather than the code window one finishes with 'extend range' rather than select new cell. F8 is a toggle so, if it is that, clicking it a second time should revert to something more normal in terms of behaviour.
