May 05 2024 08:30 AM
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 stretches from the original activated cell to the new location of the cursor. How do I turn this feature off?
(Because my files are automatically saved to OneDrive, I cannot get rid of this feature.)
Jimbo2024
May 05 2024 08:48 AM
Means you selected that range.
How do you move the cursor, by mouse or by keyboard. Do you keep pushed any mouse or keyboard button?
May 05 2024 01:20 PM
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.
May 10 2024 09:28 AM
May 10 2024 09:31 AM
May 10 2024 09:36 AM
But mouse button is pressed?
May 11 2024 01:25 AM
SolutionI 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.
May 11 2024 03:39 AM
That's with keyboard. With mouse Ctrl is enough.
How to Select Non-adjacent cells in Excel? (4 Easy Ways) (trumpexcel.com)
May 11 2024 01:25 AM
SolutionI 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.